Pg_stat_monitor – better insights into query performance in PostgreSQL | Hacker News Reader

Pg_stat_monitor – better insights into query performance in PostgreSQL

percona.com

134 pointsaleksi11 comments

Can I use this with RDS?

Yes: https://aws.amazon.com/premiumsupport/knowledge-center/rds-p...

This page talks about pg_stat_activity, which is a standard PostgreSQL feature, not about Percona's custom extension that was just announced.

Yep, so the answer to the GP's question is "no".

This is one of the biggest PITAs with hosted Postgres - you can't just use whatever extensions you want, or indeed whatever version of those extension. Invariably AWS and Azure (presumably GCP too, I haven't used it) have only the most popular extensions available, and invariably woefully outdated versions.

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.

This is something we're actively looking to change with Crunchy Bridge (https://www.crunchydata.com/products/crunchy-bridge/). We've started with PL/R and PL/Python in addition to the standard set of extensions. We're in the process of evaluating our next set of extensions including pg_repack, zhparser, pgroonga, and possibly pgsync.

Longer term we're exploring the ability to bring your own and already have some thoughts on how to make that possible.

If this plugin gets and traction either directly or through its feature set incorporated in some other plugins I hope we can convince Amazon and other cloud vendors to support it.

The way I've used external extensions in the past is by using a weird setup with non read-only replicas off the RDS primaries running in an EC2.

It "works," but... operator beware.

I'm also not exactly sure if you'll get full stats out of a replica.

Reply on news.ycombinator.com