Follow
Can anybody help me: I enabled pg_stat_statements in PostgreSQL and it works in the psql console. But #PgHero which comes with #Mastodon still says "Query stats are available but not enabled." I restarted mastodon-web but doesn't help. Do I need to restart PgHero? How can I do this? I could only find a command for the PgHero version which is installed with the OS package manager.
Solved: I created the pg_stat_statements only for the postgres database. I didn't know that every database I want to monitor needs this extension. So \c mastodon_production and then CREATE EXTENSION pg_stat_statements did the job.