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