Follow

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.

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
Mastodon

English

This Maston 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.

Hosting: Germany, Uptime: https://stats.uptimerobot.com/v8KKlhJ2E


Deutsch

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

Aber auch wenn Du Dich nicht so sehr für Europaplitik interessierst, bist Du herzlich willkommen.

Hosting: Deutschland, Verfügbarkeit: https://stats.uptimerobot.com/v8KKlhJ2E

Impressum