Enabling pg_stat_statements in a Docker container

docker-compose.yml

version: '2'

services:
  db:
    image: postgres:16
    ports:
      - "5432:5432"
    command: >
      postgres
      -c shared_preload_libraries='pg_stat_statements'
    volumes:
      - /var/lib/postgresql/data
    environment:
      POSTGRES_USER: myproject

If you are on alpine and dont have perl then use:
sed -i "s/#shared_preload_libraries = ''/shared_preload_libraries = 'pg_stat_statements'/g" /var/lib/postgresql/data/postgresql.conf

I'm still getting ERROR: pg_stat_statements must be loaded via shared_preload_libraries. Tried some different solution, but still couldn't find one, which solves this error

Found another way (it worked for me):

version: '2'

services:
  db:
    image: postgres
    ports:
      - "5432:5432"
    volumes:
      - /var/lib/postgresql/data
    command: postgres -c shared_preload_libraries=pg_stat_statements -c pg_stat_statements.track=all -c max_connections=200
    environment:
      POSTGRES_USER: myproject

docker cp postgres:/var/lib/postgresql/data/postgresql.conf postgresql.conf
vi postgresql.conf
docker cp postgresql.conf postgres:/var/lib/postgresql/data/postgresql.conf
docker restart postgres

This helped. Great article.

Finally, login to the container with postgres user and enable the extension with command:
CREATE EXTENSION pg_stat_statements;
Check if good:
SELECT *
FROM pg_available_extensions
WHERE
name = 'pg_stat_statements' and
installed_version is not null;

Found another way (it worked for me):

version: '2'

services:
  db:
    image: postgres
    ports:
      - "5432:5432"
    volumes:
      - /var/lib/postgresql/data
    command: postgres -c shared_preload_libraries=pg_stat_statements -c pg_stat_statements.track=all -c max_connections=200
    environment:
      POSTGRES_USER: myproject

This worked for me.

Found another way (it worked for me):

version: '2'

services:
  db:
    image: postgres
    ports:
      - "5432:5432"
    volumes:
      - /var/lib/postgresql/data
    command: postgres -c shared_preload_libraries=pg_stat_statements -c pg_stat_statements.track=all -c max_connections=200
    environment:
      POSTGRES_USER: myproject

thank you, worked fine here

Found another way (it worked for me):

version: '2'

services:
  db:
    image: postgres
    ports:
      - "5432:5432"
    volumes:
      - /var/lib/postgresql/data
    command: postgres -c shared_preload_libraries=pg_stat_statements -c pg_stat_statements.track=all -c max_connections=200
    environment:
      POSTGRES_USER: myproject

Works for me, too! tks⛄︎

Notes

Found another way (it worked for me):

version: '2'

services:
  db:
    image: postgres
    ports:
      - "5432:5432"
    volumes:
      - /var/lib/postgresql/data
    command: postgres -c shared_preload_libraries=pg_stat_statements -c pg_stat_statements.track=all -c max_connections=200
    environment:
      POSTGRES_USER: myproject

Works for me, too! tks⛄︎

Another +1 for this solution.

Same here, postgres -c shared_preload_libraries=pg_stat_statements portion allowed me to use the view.

Thanks all for the comments - updated the gist to make it easier for anyone landing here :)

For me, adding the commands of pg_stat_statements in docker-compose.yml is not worked
I added manually in the postgresql.conf inside the docker container worked