Missing (interesting) stats about pgmetrics HOT 3 CLOSED

Thanks for the feedback.

Insert / Update / Fetch / Delete stats:

This is already present. You can see it in the JSON output as:

...
  "databases": [
    {
      "oid": 12558,
      "name": "postgres",
...
      "tup_returned": 2295255,
      "tup_fetched": 48882,
      "tup_inserted": 0,
      "tup_updated": 0,
      "tup_deleted": 0,
...

(Also in the text output (as percentages), but I assume you want to the use the JSON output to feed the numbers to Zabbix.)

Slow query count:

Would pg_stat_statements help? Adding that is on the roadmap.

Connections used for replication:

The entire list of connections, with application names (eg walreceiver for a streaming replication client) is available. The currently active replication destinations (from pg_stat_replication) are also there.

from pgmetrics.

from pgmetrics.

pgmetrics was written with the idea of scripts/tools further processing it's JSON output, so that you can invoke your tool like:

pgmetrics -f json | send-to-zabbix

where send-to-zabbix will:

import json, sys
data = json.loads(sys.stdin.read())
# process data and send to zabbix

Happy to link to your script from pgmetrics.io if it is generally usable for sending pgmetrics output to zabbix.

Tracking the pg_stat_statements as #4. Closing this one, feel free to open another one for any other requests.

from pgmetrics.