Comments (3)
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.
Related Issues (20)
- Log parsing clarification HOT 4
- How to read some values reported by pgmetrics (e.g. shared_buffers, max_wal_size) HOT 6
- Postgres 13: wal_keep_segments displays no value HOT 2
- What determines the sort order for list of table details in pgmetrics output? HOT 2
- Incorrect min_wal_size displayed for PG ver >= 10 HOT 2
- Improve heuristic to check if PG is local HOT 4
- Slow bloat query HOT 4
- AWS RDS, Aurora cloudwatch collection error HOT 3
- pg_stat_archiver query failed: sql: Scan error on column index 6, name "date_part": converting NULL to int64 is unsupported HOT 2
- Omitting retrieval of index definition HOT 1
- Please, add building instructions HOT 2
- Support Citus 11 HOT 2
- Crashes PSQL when table has high Partition Count HOT 2
- Break up the Postgres shared memory is not available in pgmetrics/pgDash currently.
- how to collect system info with pgmetrics HOT 1
- [Feature] Support connect by Keyword/Value Connection Strings HOT 1
- support PG16 HOT 2
- PgMetrics not working for AWS Aurora Instances HOT 1
- PGBOUNCER 1.21 breaking change. HOT 1
- pg_stat(io)_user_tables query failed: ERROR: canceling statement due to lock timeout (SQLSTATE 55P03) HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from pgmetrics.