Search PostgreSQL documentation

pg_stat_autovacuum_scores.vacuum_scoreStatistics & MetricsWikiStatistics & Metrics · pg_stat_autovacuum_scoresVacuum component score. Scores greater than autovacuum_vacuum_score_weight indicate that autovacuum would vacuum the table (unless autovacuum is disabled). pg_stat_autovacuum_scores SELECT … pg_stat_autovacuum_scores.xid_scoreStatistics & MetricsWikiStatistics & Metrics · pg_stat_autovacuum_scoresTransaction ID age component score. Scores greater than autovacuum_freeze_score_weight indicate that autovacuum would vacuum the table for transaction ID wraparound prevention. pg_stat_auto… pg_stat_bgwriter.buffers_allocStatistics & MetricsWikiStatistics & Metrics · pg_stat_bgwriterNumber of buffers allocated pg_stat_bgwriter SELECT buffers_alloc FROM pg_catalog.pg_stat_bgwriter; View pg_stat_bgwriter Field buffers_alloc SQL type bigint Units named in the field defini… pg_stat_bgwriter.buffers_backendStatistics & MetricsWikiStatistics & Metrics · pg_stat_bgwriterNumber of buffers written directly by a backend pg_stat_bgwriter SELECT buffers_backend FROM pg_catalog.pg_stat_bgwriter; View pg_stat_bgwriter Field buffers_backend SQL type bigint Units n… pg_stat_bgwriter.buffers_backend_fsyncStatistics & MetricsWikiStatistics & Metrics · pg_stat_bgwriterNumber of times a backend had to execute its own fsync call (normally the background writer handles those even when the backend does its own write) pg_stat_bgwriter SELECT buffers_backend_f… pg_stat_bgwriter.buffers_checkpointStatistics & MetricsWikiStatistics & Metrics · pg_stat_bgwriterNumber of buffers written during checkpoints pg_stat_bgwriter SELECT buffers_checkpoint FROM pg_catalog.pg_stat_bgwriter; View pg_stat_bgwriter Field buffers_checkpoint SQL type bigint Unit… pg_stat_bgwriter.buffers_cleanStatistics & MetricsWikiStatistics & Metrics · pg_stat_bgwriterNumber of buffers written by the background writer pg_stat_bgwriter SELECT buffers_clean FROM pg_catalog.pg_stat_bgwriter; View pg_stat_bgwriter Field buffers_clean SQL type bigint Units na… pg_stat_bgwriter.checkpoint_sync_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_bgwriterTotal amount of time that has been spent in the portion of checkpoint processing where files are synchronized to disk, in milliseconds pg_stat_bgwriter SELECT checkpoint_sync_time FROM pg_c… pg_stat_bgwriter.checkpoint_write_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_bgwriterTotal amount of time that has been spent in the portion of checkpoint processing where files are written to disk, in milliseconds pg_stat_bgwriter SELECT checkpoint_write_time FROM pg_catal… pg_stat_bgwriter.checkpoints_reqStatistics & MetricsWikiStatistics & Metrics · pg_stat_bgwriterNumber of requested checkpoints that have been performed pg_stat_bgwriter SELECT checkpoints_req FROM pg_catalog.pg_stat_bgwriter; View pg_stat_bgwriter Field checkpoints_req SQL type bigin… pg_stat_bgwriter.checkpoints_timedStatistics & MetricsWikiStatistics & Metrics · pg_stat_bgwriterNumber of scheduled checkpoints that have been performed pg_stat_bgwriter SELECT checkpoints_timed FROM pg_catalog.pg_stat_bgwriter; View pg_stat_bgwriter Field checkpoints_timed SQL type b… pg_stat_bgwriter.maxwritten_cleanStatistics & MetricsWikiStatistics & Metrics · pg_stat_bgwriterNumber of times the background writer stopped a cleaning scan because it had written too many buffers pg_stat_bgwriter SELECT maxwritten_clean FROM pg_catalog.pg_stat_bgwriter; View pg_stat… pg_stat_bgwriter.stats_resetStatistics & MetricsWikiStatistics & Metrics · pg_stat_bgwriterTime at which these statistics were last reset pg_stat_bgwriter SELECT stats_reset FROM pg_catalog.pg_stat_bgwriter; View pg_stat_bgwriter Field stats_reset SQL type timestamp with time zon… pg_stat_checkpointer.buffers_writtenStatistics & MetricsWikiStatistics & Metrics · pg_stat_checkpointerNumber of shared buffers written during checkpoints and restartpoints pg_stat_checkpointer Number of buffers written during checkpoints and restartpoints SELECT buffers_written FROM pg_cata… pg_stat_checkpointer.num_doneStatistics & MetricsWikiStatistics & Metrics · pg_stat_checkpointerNumber of checkpoints that have been performed pg_stat_checkpointer SELECT num_done FROM pg_catalog.pg_stat_checkpointer; View pg_stat_checkpointer Field num_done SQL type bigint Units name… pg_stat_checkpointer.num_requestedStatistics & MetricsWikiStatistics & Metrics · pg_stat_checkpointerNumber of requested checkpoints pg_stat_checkpointer Number of requested checkpoints that have been performed SELECT num_requested FROM pg_catalog.pg_stat_checkpointer; View pg_stat_checkpo… pg_stat_checkpointer.num_timedStatistics & MetricsWikiStatistics & Metrics · pg_stat_checkpointerNumber of scheduled checkpoints due to timeout pg_stat_checkpointer Number of scheduled checkpoints due to timeout. Note that checkpoints may be skipped if the server has been idle since th… pg_stat_checkpointer.restartpoints_doneStatistics & MetricsWikiStatistics & Metrics · pg_stat_checkpointerNumber of restartpoints that have been performed pg_stat_checkpointer SELECT restartpoints_done FROM pg_catalog.pg_stat_checkpointer; View pg_stat_checkpointer Field restartpoints_done SQL … pg_stat_checkpointer.restartpoints_reqStatistics & MetricsWikiStatistics & Metrics · pg_stat_checkpointerNumber of requested restartpoints pg_stat_checkpointer SELECT restartpoints_req FROM pg_catalog.pg_stat_checkpointer; View pg_stat_checkpointer Field restartpoints_req SQL type bigint Units… pg_stat_checkpointer.restartpoints_timedStatistics & MetricsWikiStatistics & Metrics · pg_stat_checkpointerNumber of scheduled restartpoints due to timeout or after a failed attempt to perform it pg_stat_checkpointer SELECT restartpoints_timed FROM pg_catalog.pg_stat_checkpointer; View pg_stat_c… pg_stat_checkpointer.slru_writtenStatistics & MetricsWikiStatistics & Metrics · pg_stat_checkpointerNumber of SLRU buffers written during checkpoints and restartpoints pg_stat_checkpointer SELECT slru_written FROM pg_catalog.pg_stat_checkpointer; View pg_stat_checkpointer Field slru_writt… pg_stat_checkpointer.stats_resetStatistics & MetricsWikiStatistics & Metrics · pg_stat_checkpointerTime at which these statistics were last reset pg_stat_checkpointer SELECT stats_reset FROM pg_catalog.pg_stat_checkpointer; View pg_stat_checkpointer Field stats_reset SQL type timestamp w… pg_stat_checkpointer.sync_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_checkpointerTotal amount of time that has been spent in the portion of processing checkpoints and restartpoints where files are synchronized to disk, in milliseconds pg_stat_checkpointer SELECT sync_ti… pg_stat_checkpointer.write_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_checkpointerTotal amount of time that has been spent in the portion of processing checkpoints and restartpoints where files are written to disk, in milliseconds pg_stat_checkpointer SELECT write_time F… pg_stat_database.active_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_databaseTime spent executing SQL statements in this database, in milliseconds (this corresponds to the states active and fastpath function call in pg_stat_activity) pg_stat_database SELECT active_t… pg_stat_database.blk_read_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_databaseTime spent reading data file blocks by backends in this database, in milliseconds (if track_io_timing is enabled, otherwise zero) pg_stat_database Time spent reading data file blocks by bac… pg_stat_database.blk_write_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_databaseTime spent writing data file blocks by backends in this database, in milliseconds (if track_io_timing is enabled, otherwise zero) pg_stat_database Time spent writing data file blocks by bac… pg_stat_database.blks_hitStatistics & MetricsWikiStatistics & Metrics · pg_stat_databaseNumber of times disk blocks were found already in the buffer cache, so that a read was not necessary (this only includes hits in the PostgreSQL buffer cache, not the operating system's file … pg_stat_database.blks_readStatistics & MetricsWikiStatistics & Metrics · pg_stat_databaseNumber of disk blocks read in this database pg_stat_database SELECT blks_read FROM pg_catalog.pg_stat_database; View pg_stat_database Field blks_read SQL type bigint Units named in the fiel… pg_stat_database.checksum_failuresStatistics & MetricsWikiStatistics & Metrics · pg_stat_databaseNumber of data page checksum failures detected in this database (or on a shared object). Detected failures are not reset if the data_checksums setting changes. Clusters which are initialized… pg_stat_database.checksum_last_failureStatistics & MetricsWikiStatistics & Metrics · pg_stat_databaseTime at which the last data page checksum failure was detected in this database (or on a shared object). Last failure is reported regardless of the data_checksums setting. pg_stat_database … pg_stat_database.conflictsStatistics & MetricsWikiStatistics & Metrics · pg_stat_databaseNumber of queries canceled due to conflicts with recovery in this database. (Conflicts occur only on standby servers; see pg_stat_database_conflicts for details.) pg_stat_database SELECT co… pg_stat_database.datidStatistics & MetricsWikiStatistics & Metrics · pg_stat_databaseOID of this database, or 0 for objects belonging to a shared relation pg_stat_database OID of a database SELECT datid FROM pg_catalog.pg_stat_database; View pg_stat_database Field datid SQL… pg_stat_database.datnameStatistics & MetricsWikiStatistics & Metrics · pg_stat_databaseName of this database, or NULL for shared objects. pg_stat_database Name of this database SELECT datname FROM pg_catalog.pg_stat_database; View pg_stat_database Field datname SQL type name … pg_stat_database.deadlocksStatistics & MetricsWikiStatistics & Metrics · pg_stat_databaseNumber of deadlocks detected in this database pg_stat_database SELECT deadlocks FROM pg_catalog.pg_stat_database; View pg_stat_database Field deadlocks SQL type bigint Units named in the fi… pg_stat_database.idle_in_transaction_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_databaseTime spent idling while in a transaction in this database, in milliseconds (this corresponds to the states idle in transaction and idle in transaction (aborted) in pg_stat_activity) pg_stat… pg_stat_database.numbackendsStatistics & MetricsWikiStatistics & Metrics · pg_stat_databaseNumber of backends currently connected to this database, or NULL for shared objects. This is the only column in this view that returns a value reflecting current state; all other columns ret… pg_stat_database.parallel_workers_launchedStatistics & MetricsWikiStatistics & Metrics · pg_stat_databaseNumber of parallel workers launched by queries on this database pg_stat_database SELECT parallel_workers_launched FROM pg_catalog.pg_stat_database; View pg_stat_database Field parallel_work… pg_stat_database.parallel_workers_to_launchStatistics & MetricsWikiStatistics & Metrics · pg_stat_databaseNumber of parallel workers planned to be launched by queries on this database pg_stat_database SELECT parallel_workers_to_launch FROM pg_catalog.pg_stat_database; View pg_stat_database Fiel… pg_stat_database.session_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_databaseTime spent by database sessions in this database, in milliseconds (note that statistics are only updated when the state of a session changes, so if sessions have been idle for a long time, t…