In https://git.zabbix.com/projects/ZBX/...actions.sql#11
we collect
PostgreSQL: Get transactions: Transactions: Max idle transaction time
I'd like to propose adding
We're often affected by idle/dead processes that are stuck in 'idle' state and we'd like to create a trigger for that.
I think it would be a good idea to add such monitoring to official template.
I'm not sure whether should it replace existing item or become a new monitored item.
we collect
PostgreSQL: Get transactions: Transactions: Max idle transaction time
I'd like to propose adding
Code:
OR state = 'idle in transaction'
We're often affected by idle/dead processes that are stuck in 'idle' state and we'd like to create a trigger for that.
I think it would be a good idea to add such monitoring to official template.
I'm not sure whether should it replace existing item or become a new monitored item.
Comment