search

CrunchyData / pgmonitor

PostgreSQL Monitoring, Metrics Collection and Alerting Resources from Crunchy Data
Other
596 stars 92 forks source link

make use of pg_stat_monitoring #385

Closed hunleyd closed 4 months ago

hunleyd commented 11 months ago

Describe the enhancement you are proposing:

Looking at this blog, it seems we might want to make use of some of the functionality that pg_stat_monitor includes

keithf4 commented 8 months ago

Finally evaluating this. It's like pg_stat_statements on steroids. Does seem like it would cause additional shared memory usage, but no additional storage requirements that I can see.

Not sure I'd want this installed as default with pgMonitor, but it could be useful as an optional feature. If we tried to make a metrics file and dashboard for it, that would be another application we'd then kind of be responsible for keeping up to date to support. Maybe just make a note of it as a reference for additional query analysis for now?

keithf4 commented 4 months ago

Noting in documentation