Template PostgreSQL by Zabbix agent show query

[iamthiagovillani]

Hello, I have a Zabbix Server environment that monitors a Postgresql database, I'm using the PostgreSQL by Zabbix agent template.
It's collecting data all right, but when it generates a lock alert, or slow query, how could I see the query command that was slow, or generated the block?
I can see the graph but not the log.

install template https://www.zabbix.com/br/integrations/postgresql

Thanks.

[iamthiagovillani]

Hello,

any tips on how to see query?, or do I need to create separate queries?

Thank.

[PeterZielony]

I don't know about Postresql..

But if there is an equivalent profiler or extended events for PostgreSQL you might catch it from a file (profiler/extended events file/sql) - but this won't come out of the box and will require some work (I'm working on the same thing for MSSQL)

but definitely there isn't a template for that kind of thing