PostgreSQL / EDB Monitoring
LPAR2RRD requires a database user (typically "lpar2rrd") with the view only permissions to collect monitoring data
 |
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 |
locks  |
ratio  |
sessions  |
sqlquery  |
throughput  |