Can anybody help me: I enabled pg_stat_statements in PostgreSQL and it works in the psql console. But which comes with 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.

· · Web · 0 · 1 · 0

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.

Sign in to participate in the conversation

This Mastodon instance is dedicated to all people interested in a united Europe, a post-national and truly democratic Europe. But even if you are not so interested in European politics you are welcome.

Diese Mastodon-Instanz ist für alle, die interessiert sind an einem vereinten Europa, einem post-nationalen und wirklich demokratischen Europa.

Impressum dieser Instanz