Postgresql slow transactions

Hi,

is it possible for Netdata to monitor Postgresql slow transactions and alerts on them ?

thank you !

Morgan

I would imagine slow transactions would be picked up on the default charts for the PostgreSQL collector.

https://learn.netdata.cloud/docs/agent/collectors/python.d.plugin/postgres

As for how to then define alarms for slow transactions i’m not so sure. I’d imagine you could maybe use the mysql alarms for inspiration to some extent.

p.s we also have a “help-me-build-an-alert” channel in our discord where other might be able to help: Discord

Hi, thanks for your answer.
Default Postgresql charts don’t show slow queries and I didn’t found any metrics for them…