Zabbi 5.2 and Postgresql Plugin Active (Zabbix-agent2)

[velocity08]

Hi All

hoping someone may be able to assist.

Ive done a search in the forums about setting up the native zabbix-agent 2 for monitoring Postgresql performance.

we've gone through the blog in details https://blog.zabbix.com/setting-up-z...t-works/13208/

watched the youtube video which is basically related to the blog.

looked at other websites that are referencing the Blog with like for like write up.

unfortunately there are still missing pieces on getting this working.

many posts on the forum are in Russian which i'm not able to read very well or follow.

Has anyone successfully been able to get the Postgresql template working?

Or can you recommend another template that we can use to monitor Postgresql engine/ database performance?

any assistance would be greatly appreciated.

""Cheers
G

[Amelie]

SELECT * FROM pg_stat_activity WHERE datname = 'dbname' and state = 'active';
Since pg_stat_activity contains connection statistics of all databases having any state, either idle or active, database name and connection state should be included in the query to get the desired output.



PrepaidGiftBalance