+ : after recent upgrade, I wanted to try out /pghero only to find out it's broken with the following error in logs:

ERROR: column "total_plan_time" does not exist [1]

The supposed fix is to run the following command:

ALTER EXTENSION pg_stat_statements UPDATE;

Which only works under the "creator" creator account, so I ran it under "postgresql" role instead of "mastodon".

However, even after running it, it still didn't work...

[1] github.com/ankane/pghero/issue


It turns out that the extensions are maintained *per database*, so while I was upgrading the extension version in "postgres" database, I was *not* upgrading the extension in "mastodon" database.

After checking the extension versions in both using "\dx", the fix was simple - use the "postgres" user in the "mastodon" database and voila, it worked!

Sign in to participate in the conversation

The social network of the future: No ads, no corporate surveillance, ethical design, and decentralization! Own your data with Mastodon!