Updated on 2024-06-03 GMT+08:00

Database Stat

Table 1 describes columns in the Database Stat report.

Table 1 Columns in the Database Stat report

Column

Description

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 in writing data file blocks by backends in this database (unit: ms).

Stats Reset

Time at which the current statistics were reset.