Ad Widget

Collapse

Templates/PostgreSQL: Item for monitoring longest idle process

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • prcdpr
    Junior Member
    • Mar 2023
    • 2

    #1

    Templates/PostgreSQL: Item for monitoring longest idle process

    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
    Code:
    OR state = 'idle in transaction'
    Click image for larger version

Name:	image.png
Views:	189
Size:	1.24 MB
ID:	462178

    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.
  • cyber
    Senior Member
    Zabbix Certified SpecialistZabbix Certified Professional
    • Dec 2006
    • 4807

    #2
    I guess you can submit that to https://support.zabbix.com/projects/ZBXNEXT/issues as feature request... From here it probably wont reach anywhere to become official...

    Comment

    Working...