8182ad75b9
Fix activity query
...
* Modify the activity query to ensure each state is always reported.
* Fix the activity preprocessor to unwrap the value from the array
containing it.
2025-10-18 12:49:09 -04:00
e7b97a9e88
Add items to template
...
* Add items to the Zabbix template for:
- Backgroubd writer / checkpoint stats
- Lock stats
- Connection states
2025-10-17 01:24:33 -04:00
75c5d76047
Add a metric for tracking the number of granted locks
2025-09-23 01:14:50 -04:00
cc71547f5f
Include application_name in replication discovery data
2025-07-07 13:07:11 -04:00
7cb0f7ad40
Fix typo in activity query
2025-07-05 01:17:35 -04:00
98b74d9aed
Add sequence metrics to Zabbix template
2025-07-04 02:45:43 -04:00
45953848e2
Remove some type casts from working around Decimal types
2025-07-03 10:16:20 -04:00
3c39d8aa97
Remove CIDR prefix from replication id
2025-07-03 01:13:58 -04:00
ebb084aa9d
Add initial query for sequence usage
2025-07-01 02:29:56 -04:00
be84e2b89a
Report some I/O metrics in bytes
2025-06-30 02:00:06 -04:00
b934a30124
Add pg_stat_io query
...
* Add a query for pg_stat_io metrics grouped by backend type
* Switch some unsupported values from 0 to NULL to better reflect their
nonexistence
2025-06-28 00:30:03 -04:00
ecb616f6d9
Allow retry in query tests
2025-06-18 03:23:43 -04:00
b7f731c6ac
Fix and reformat several queries
2025-06-18 03:03:34 -04:00
4fba81dc2c
Add initial bgwriter and activity metrics queries
2025-06-17 02:40:52 -04:00
9225e745b0
Handle division by zero possibility
...
* When no I/O activity has been reported in pg_statio_all_tables for a
database, the queries resulted in a division by zero. Cange this to a
NULL instead. Still a problem for Zabbix, but maybe a little cleaner.
2025-06-17 01:16:57 -04:00
c0185d4b86
Remove extra quotes in replication slot query
2025-06-15 02:20:45 -04:00
d34dfc5bf7
Fix replication monitoring queries
2025-06-15 02:19:10 -04:00
7c395a80fe
Add metrics for tracking cache hit ratios
2025-06-13 01:16:24 -04:00
6a22597f1f
Fix ID age query and template
2025-06-04 00:47:51 -04:00
80304f40d1
Revise the versions on a few queries, improve query tests
...
* Add ability to specify the sslmode parameter when connecting to
PostgreSQL
* Fix min versions for replication queries
* Add query-tests target to main Makefile
2025-06-01 00:12:31 -04:00
c0e1531083
Add query test script and test mode
...
* Add a mode to test all metric queries
* Add a script to run query tests against different versions of
PostgeSQL
* Add Docker elements for query testing
* Switch to using a --config flag when specifying the config file
* Fix some metric queries
* Allow the agent address to be configured
* Allow the sslmode connection parameter to be configured
2025-05-22 14:53:25 -04:00
98ac25743b
Add queries for replication slot monitoring
2025-04-19 02:33:48 -04:00
a21a4355e5
Restructure for packaging
2025-01-08 18:34:51 -05:00
