Hacker News Reader

pg_stat_activity isn't an extension -- it's a standard system view

I don't know how you figure that - the article describes it as a "plugin", which fore Postgres generally means "extension". I just checked the github repo too - pg_stat_monitor is definitely an extension, not merely a view (it includes views that build on top of the standard pg_stat_statements extension).

I think you may be talking past each other. @petergeoghegan referenced pg_stat_activity which is a system view; now his response to you is definitely a non-sequitur, but he's right.

Now of course your statement about pg_stat_monitor is correct, too. But you missed when you questioned Peter since he was talking about something different.

Fun fact: Peter Geoghegan is a PostgreSQL major contributor per https://www.postgresql.org/community/contributors/, pretty sure he's a committer as well.

I did notice they had written "pg_stat_activity", but assumed it was a typo, since the original question was about running the Percona extension. Never thought to check their profile; seems like crossed wires.

Reply on news.ycombinator.com