Skip to content

Instantly share code, notes, and snippets.

@lfittl

lfittl/docker-compose.yml

Last active December 31, 2023 15:33
Show Gist options
  • Star 15 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save lfittl/1b0671ac07b33521ea35fcd22b0120f5 to your computer and use it in GitHub Desktop.
Save lfittl/1b0671ac07b33521ea35fcd22b0120f5 to your computer and use it in GitHub Desktop.
Download ZIP
Enabling pg_stat_statements in a Docker container
Raw
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
Copy link

ghost commented Dec 19, 2023

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

@lfittl
Copy link
Author

lfittl commented Dec 20, 2023

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment