Database Stat
The following table describes columns in the Database Stat report.
|
Column |
Description |
|---|---|
|
Node Name |
Node name. |
|
DB Name |
Database name |
|
Backends |
Number of backends connected to this database |
|
Xact Commit |
Number of transactions in this database that have been committed |
|
Xact Rollback |
Number of transactions in this database that have been rolled back |
|
Blks Read |
Number of disk blocks read in this database |
|
Blks Hit |
Number of times that disk blocks have been found in the cache |
|
Tuple Returned |
Number of rows sequentially scanned |
|
Tuple Fetched |
Number of rows randomly scanned |
|
Tuple Inserted |
Number of rows inserted by queries in this database |
|
Tuple Updated |
Number of rows updated by queries in this database |
|
Tup Deleted |
Number of rows deleted by queries in this database |
|
Conflicts |
Number of queries canceled due to conflicts |
|
Temp Files |
Number of temporary files created by queries in this database |
|
Temp Bytes |
Total amount of data written to temporary files by queries in this database |
|
Deadlocks |
Number of deadlocks detected in this database |
|
Blk Read Time |
Time spent reading data file blocks by backends in this database (unit: ms) |
|
Blk Write Time |
Time spent reading data file blocks by backends in this database (unit: ms) |
|
Stats Reset |
Time at which the current statistics were reset |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.