Mastodon - pghero recommendation

[shanelord01]

Hi,

When I check pghero, it suggests the following:

"Query stats must be enabled for slow queries"

Query Stats
Make them available by adding the following lines to postgresql.conf:

shared_preload_libraries = 'pg_stat_statements'
pg_stat_statements.track = all
Restart the server for the changes to take effect.

---

I can't see any way to add this or change these settings...

Any thoughts?

Thanks,
Shane.

[girish]

@shanelord01 I guess this is meant for development setups. It has to be enabled in the postgesql addon (which is in a container named postgresql). Currently, there is no easy way to persist changes to the postgresql addon.

If you like, you can docker exec -ti postgresql /bin/bash and then edit /run/postgresql/postgresql.conf and then supervisorctl restart postgresql. As mentioned, any changes will be overwritten on container restart or server restart.

[shanelord01]

@girish Thanks for this. Should I just ignore the recommendation or will it do something beneficial to my instance?

[girish]

@shanelord01 You can ignore the recommendation. I think it's a hint for developers to optimize (and maybe sysadmins to report back to upstream project of bug/issues).