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

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

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

Nice!! Worked like a charm. Thank you so much!

PS: don't forget to docker compose down and then docker compose up