SUMMARY_STAT_DATABASE
SUMMARY_STAT_DATABASE contains every row of each database in the cluster, showing database-wide statistics.
Table 1 SUMMARY_STAT_DATABASE
Number of backends currently connected to this database. This is the only column in this view that returns a value reflecting the current state; all other columns return the accumulated values since the last reset. | ||
Number of transactions in this database that have been committed | ||
Number of transactions in this database that have been rolled back | ||
Number of times disk blocks were found in the buffer cache (unnecessary as the number includes only hits in the PostgreSQL buffer cache) | ||
Number of queries canceled due to database recovery conflicts (conflicts occurring only on the standby server). For details, see STAT_DATABASE_CONFLICTS. | ||
Number of temporary files created by queries in this database. All temporary files are counted, regardless of why the temporary file was created (for example, sorting or hashing), and regardless of the log_temp_files setting. | ||
Total amount of data written to temporary files by queries in this database. All temporary files are counted, regardless of why the temporary file was created, and regardless of the log_temp_files setting. | ||
Time spent reading data file blocks by backends in this database (unit: ms) | ||
Time spent writing into data file blocks by backends in this database (unit: ms) | ||