PostgreSQL 9.6 Popular
Hello. I'm not very good at PostgreSQL. If I did something wrong, please help me fix it.
This template is based on pgCayenne by Lesovsky Alexey, but I've updated it to work on PostgreSQL 9.6 and added some new itens.
Template Information
- Monitored Itens: 76
- Monitoring Graphs: 18
Items Description
Background Writer (10 Items)
- Buffers Allocated
- Buffers Written by the BGWriter
- Buffers Written Directly by a Backend
- Buffers Written During Checkpoints
- Checkpoints by Timeout
- Max Written
- Required Checkpoints
- Sync Time
- Times a Backend Had to Execute its Own Fsync
- Write Time
Buffers & Caches (5 Items)
- Cache Hit Ratio
- Clear Buffers
- Dirty Buffers
- Total Buffers
- Used Buffers
Configuration (3 Items)
- Fsync
- Full Page Writes
- Synchronous Commit
Connections (8 Items)
- Number of Active Connections
- Number of Idle Connections
- Number of Idle in Transaction Connections
- Number of Prepared Connections
- Number of Waiting Connections
- Ping
- Total Connections
- Total Connections (%)
Databases (1 Item)
- Database Zabbix Size
Database Status (13 Items)
- Blocks Hit per Second
- Blocks Read per Second
- Commits per Second
- Registered Conflicts
- Registered Deadlocks
- Rollbacks per Second
- Temp Bytes Written
- Temp Files Created
- Tuples Deleted per Second
- Tuples Fetched per Second
- Tuples Inserted per Second
- Tuples Returned per Second
- Tuples Updated per Second
General Information (3 Items)
- Number of Running Processes
- PostgreSQL Version
- Service Uptime
Operations (1 Item)
- Average Query Time
Streaming Replication (2 Items)
- Recovery State
- Stand-by Count
Table Info (25 Items)
- Indexes Size
- Rows Count
- Size
- Analyzes
- Autoanalyzes
- Autovacuums
- Cache Blocks Hits per Second
- Cache Blocks Read per Second
- Dead Rows
- Disk Blocks Hits per Second from TOAST
- Disk Blocks Hits per Second from TOAST Indexes
- Disk Blocks Read per Second from TOAST
- Disk Blocks Read per Second f
Listing Details
Type
Min Zabbix version
2.4.x
Created
Modified
Version 2.4
Download (4269 downloads)
1 version, '2017-09-01 15:38' modified
1 version, '2017-09-01 15:38' modified
Tags
Author
Andre Rocha
Owner