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

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