Database Stat |
- Database performance statistics: transactions, read and write operations, row activities, write conflicts, and deadlocks.
- Cluster-wide report, which can be viewed only in cluster mode.
|
Load Profile |
- Cluster performance statistics: CPU time, DB time, logical or physical read operation, I/O performance, login and logout, load strength, and load performance.
- Cluster-wide report, which can be viewed only in cluster mode.
|
Instance Efficiency Percentages |
- Cluster-level or node-level cache hit ratio.
- Cluster- or node-wide report, which can be viewed in cluster or node mode.
|
Top 10 Events by Total Wait Time |
- Most time-consuming event.
- Node-wide report, which can be viewed in node mode.
|
Wait Classes by Total Wait Time |
- Category of the wait time that is most time-consuming.
- Node-wide report, which can be viewed in node mode.
|
Host CPU |
- CPU usage of the host.
- Node-wide report, which can be viewed in node mode.
|
IO Profile |
- I/O usage in the cluster or node dimension.
- Cluster- or node-wide report, which can be viewed in cluster or node mode.
|
Memory Statistics |
- Kernel memory usage distribution.
- Node-wide report, which can be viewed in node mode.
|
Time Model |
- Time model data generated by running SQL statements on a node range.
- Node-wide report, which can be viewed in node mode.
|
SQL Statistics |
- SQL statement performance statistics are displayed in the following dimensions: total time, average time, CPU duration, lock wait time, number of returned rows, number of scanned rows, number of execution times, logical read, and physical read.
- Cluster- or node-wide report, which can be viewed in cluster or node mode.
|
Wait Events |
- Statistics on wait events at the node level.
- Node-wide report, which can be viewed in node mode.
For details, see "Waiting state list", "List of wait events corresponding to lightweight locks", "List of wait events corresponding to I/Os", and "List of wait events corresponding to transaction locks" in "System Catalogs and System Views > System Views > Other System Views > PG_THREAD_WAIT_STATUS" in the Developer Guide. |
Cache IO Stats |
- I/O statistics on user tables and indexes.
- Cluster- or node-wide report, which can be viewed in cluster or node mode.
|
Utility status |
- Status information about the replication slot and background checkpoint.
- Node-wide report, which can be viewed in node mode.
|
Object stats |
- Performance statistics in the index and table dimensions.
- Cluster- or node-wide report, which can be viewed in cluster or node mode.
|
Configuration settings |
- Node configuration.
- Node-wide report, which can be viewed in node mode.
|
SQL Detail |
- SQL statement text details.
- Cluster- or node-wide report, which can be viewed in cluster or node mode.
|
