Documentation

PostgreSQL monitoring

LPAR2RRD obtains data through SQL protocol.
LPAR2RRD requires a database user (typically "lpar2rrd") with the view only permissions to collect monitoring data

PostgreSQL monitoring schema

Collected Metrics

Subsystem Metric Standalone
Configuration DB size yes
Main yes
BG writer Buffers yes
Checkpoints yes
Throughput Blocks yes
Tuples yes
Temp yes
Sessions Active yes
Disabled yes
Fastpath yes
Idle yes
Locks Held yes
Awaited yes
Deadlocks yes
SQL query User yes
Cursors yes
Wait events LWLockNamed yes
LWLLockTranche yes
Lock yes
BufferPin yes
Vacuum Phase yes
Ratio Cache hit yes
Commit yes

You can see implementation on Free Demo

Examples

bgwriter
PostgreSQL monitoring bgwriter

locks
PostgreSQL monitoring locks

ratio
PostgreSQL monitoring ratio

sessions
PostgreSQL monitoring sessions

sqlquery
PostgreSQL monitoring sqlquery

throughput
PostgreSQL monitoring throughput