pgmonitor icon indicating copy to clipboard operation
pgmonitor copied to clipboard

make use of pg_stat_monitoring

Open hunleyd opened this issue 1 year ago • 1 comments

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

hunleyd avatar Dec 27 '23 14:12 hunleyd

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 avatar Mar 20 '24 16:03 keithf4