Postgresql configuration

[g-normand]

Hello, I would like to get information about the requests that are really long to optimize them. Is it possible to modify the Postgresql configuration?

I wanted to add log_min_duration_statement = 5000

I saw that there is a command postgres:set <service> <key> <value> but it doesn't seems to be helpful for my case. What would be the best practice?

Thanks Guillaume

[Schlepptop]

You can dokku postgres:enter the container, modify the config file directly and then dokku postgres:restart the DB. Entering is not strictly necessary, you can also modify the file from where it is mounted (somewhere in /var/lib/dokku/), but I don't remember the exact path.

[g-normand]

Thanks!

I could change this way:

dokku postgres:enter service
sed -i "s/^#log_min_duration_statement = -1/log_min_duration_statement = 5000/" /var/lib/postgresql/data/postgresql.conf
dokku postgres:restart service
dokku ps:restart app
dokku postgres:logs service

now it's logging and it works well, thanks!