How to get count of active sql thread via API

[malaybiswal]

Hi,
I'm writing a program, which needs to pull metrics every few minutes from zabbix via API.
Below are those metrics. I could not find how to get these data via API call in API documentation. Can anybody point me from where i'll get API documentation for these?


PostgreSQL Instance Responding: this is just up/down status of the instance… UP=1; DOWN=not 1
PostgreSQL BE Active SQL: count of active SQL threads
PostgreSQL BE Lock Waits: count of threads waiting on a lock
PostgreSQL Trx Commits/sec: count of commits per second
PostgreSQL Streaming Replication Lag Time: number of seconds of replication lag

Thanks
Malay

[jan.garaj]

Use history_get.

Example - last value of item with id 1: http://monitoringartist.github.io/za...20%20%20%20%7D

[malaybiswal]

Hi Jan,
I did try history.get , but result set for metrics which i'm looking for is NULL.
I could able to get API calls for some item but none from below list.
Any of these “data discovery” item is not providing any data via API.