Search PostgreSQL documentation

pg_stat_io.read_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_ioTime spent waiting for read operations in milliseconds (if track_io_timing is enabled and object is not wal, or if track_wal_io_timing is enabled and object is wal, otherwise zero). This may… pg_stat_io.readsStatistics & MetricsWikiStatistics & Metrics · pg_stat_ioNumber of read operations. pg_stat_io Number of read operations, each of the size specified in op_bytes. SELECT reads FROM pg_catalog.pg_stat_io; View pg_stat_io Field reads SQL type bigint… pg_stat_io.reusesStatistics & MetricsWikiStatistics & Metrics · pg_stat_ioThe number of times an existing buffer in a size-limited ring buffer outside of shared buffers was reused as part of an I/O operation in the bulkread, bulkwrite, or vacuum contexts. pg_stat… pg_stat_io.stats_resetStatistics & MetricsWikiStatistics & Metrics · pg_stat_ioTime at which these statistics were last reset. pg_stat_io SELECT stats_reset FROM pg_catalog.pg_stat_io; View pg_stat_io Field stats_reset SQL type timestamp with time zone Units named in … pg_stat_io.write_bytesStatistics & MetricsWikiStatistics & Metrics · pg_stat_ioThe total size of write operations in bytes. pg_stat_io SELECT write_bytes FROM pg_catalog.pg_stat_io; View pg_stat_io Field write_bytes SQL type numeric Units named in the field definition… pg_stat_io.write_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_ioTime spent waiting for write operations in milliseconds (if track_io_timing is enabled and object is not wal, or if track_wal_io_timing is enabled and object is wal, otherwise zero) pg_stat… pg_stat_io.writeback_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_ioTime spent waiting for writeback operations in milliseconds (if track_io_timing is enabled, otherwise zero). This includes the time spent queueing write-out requests and, potentially, the ti… pg_stat_io.writebacksStatistics & MetricsWikiStatistics & Metrics · pg_stat_ioNumber of units of size BLCKSZ (typically 8kB) which the process requested the kernel write out to permanent storage. pg_stat_io Number of units of size op_bytes which the process requested… pg_stat_io.writesStatistics & MetricsWikiStatistics & Metrics · pg_stat_ioNumber of write operations. pg_stat_io Number of write operations, each of the size specified in op_bytes. SELECT writes FROM pg_catalog.pg_stat_io; View pg_stat_io Field writes SQL type bi… pg_stat_kind_info.accessed_across_databasesStatistics & MetricsWikiStatistics & Metrics · pg_stat_kind_infoTrue if entries of this kind are accessed across databases (cluster-wide statistics), false if they are scoped to a single database. pg_stat_kind_info SELECT accessed_across_databases FROM … pg_stat_kind_info.builtinStatistics & MetricsWikiStatistics & Metrics · pg_stat_kind_infoTrue if this is a built-in statistics kind, false if it was registered by an extension. pg_stat_kind_info SELECT builtin FROM pg_catalog.pg_stat_kind_info; View pg_stat_kind_info Field buil… pg_stat_kind_info.entry_countStatistics & MetricsWikiStatistics & Metrics · pg_stat_kind_infoNumber of tracked entries for this kind. For variable-numbered kinds, this is the number of objects currently tracked. NULL for fixed-sized statistics kinds, or if the kind does not track en… pg_stat_kind_info.fixed_amountStatistics & MetricsWikiStatistics & Metrics · pg_stat_kind_infoTrue if this kind tracks a fixed amount of data (a single, statically allocated entry), false if it tracks a variable number of entries keyed by object identifier. pg_stat_kind_info SELECT … pg_stat_kind_info.idStatistics & MetricsWikiStatistics & Metrics · pg_stat_kind_infoNumeric identifier of the statistics kind. pg_stat_kind_info SELECT id FROM pg_catalog.pg_stat_kind_info; View pg_stat_kind_info Field id SQL type integer Units named in the field definitio… pg_stat_kind_info.nameStatistics & MetricsWikiStatistics & Metrics · pg_stat_kind_infoName of the statistics kind. pg_stat_kind_info SELECT name FROM pg_catalog.pg_stat_kind_info; View pg_stat_kind_info Field name SQL type text Units named in the field definition Not specifi… pg_stat_kind_info.write_to_fileStatistics & MetricsWikiStatistics & Metrics · pg_stat_kind_infoTrue if entries of this kind are persisted to the statistics file at shutdown and reloaded on startup, false if they are kept only in shared memory. pg_stat_kind_info SELECT write_to_file F… pg_stat_lock.fastpath_exceededStatistics & MetricsWikiStatistics & Metrics · pg_stat_lockNumber of times a lock of this type could not be acquired via fast path because the fast path slot limit was exceeded. Increasing max_locks_per_transaction can reduce this number. See Sectio… pg_stat_lock.locktypeStatistics & MetricsWikiStatistics & Metrics · pg_stat_lockType of the lockable object. See pg_locks for details. pg_stat_lock SELECT locktype FROM pg_catalog.pg_stat_lock; View pg_stat_lock Field locktype SQL type text Units named in the field def… pg_stat_lock.stats_resetStatistics & MetricsWikiStatistics & Metrics · pg_stat_lockTime at which these statistics were last reset. pg_stat_lock SELECT stats_reset FROM pg_catalog.pg_stat_lock; View pg_stat_lock Field stats_reset SQL type timestamp with time zone Units nam… pg_stat_lock.wait_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_lockTotal time spent waiting for locks of this type, in milliseconds. Only incremented when the lock was successfully acquired after waiting longer than deadlock_timeout. pg_stat_lock SELECT wa… pg_stat_lock.waitsStatistics & MetricsWikiStatistics & Metrics · pg_stat_lockNumber of times a lock of this type had to wait because of a conflicting lock. Only incremented when the lock was successfully acquired after waiting longer than deadlock_timeout. pg_stat_l… pg_stat_progress_analyze.child_tables_doneStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_analyzeNumber of child tables scanned. This counter only advances when the phase is acquiring inherited sample rows. pg_stat_progress_analyze SELECT child_tables_done FROM pg_catalog.pg_stat_progr… pg_stat_progress_analyze.child_tables_totalStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_analyzeNumber of child tables. pg_stat_progress_analyze SELECT child_tables_total FROM pg_catalog.pg_stat_progress_analyze; View pg_stat_progress_analyze Field child_tables_total SQL type bigint U… pg_stat_progress_analyze.current_child_table_relidStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_analyzeOID of the child table currently being scanned. This field is only valid when the phase is acquiring inherited sample rows. pg_stat_progress_analyze SELECT current_child_table_relid FROM pg… pg_stat_progress_analyze.datidStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_analyzeOID of the database to which this backend is connected. pg_stat_progress_analyze SELECT datid FROM pg_catalog.pg_stat_progress_analyze; View pg_stat_progress_analyze Field datid SQL type oi… pg_stat_progress_analyze.datnameStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_analyzeName of the database to which this backend is connected. pg_stat_progress_analyze SELECT datname FROM pg_catalog.pg_stat_progress_analyze; View pg_stat_progress_analyze Field datname SQL ty… pg_stat_progress_analyze.delay_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_analyzeTotal time spent sleeping due to cost-based delay (see Section 19.10.2), in milliseconds (if track_cost_delay_timing is enabled, otherwise zero). pg_stat_progress_analyze SELECT delay_time … pg_stat_progress_analyze.ext_stats_computedStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_analyzeNumber of extended statistics computed. This counter only advances when the phase is computing extended statistics. pg_stat_progress_analyze SELECT ext_stats_computed FROM pg_catalog.pg_sta… pg_stat_progress_analyze.ext_stats_totalStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_analyzeNumber of extended statistics. pg_stat_progress_analyze SELECT ext_stats_total FROM pg_catalog.pg_stat_progress_analyze; View pg_stat_progress_analyze Field ext_stats_total SQL type bigint … pg_stat_progress_analyze.phaseStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_analyzeCurrent processing phase. See Table 27.43. pg_stat_progress_analyze Current processing phase. See Table 27.33. SELECT phase FROM pg_catalog.pg_stat_progress_analyze; View pg_stat_progress_a… pg_stat_progress_analyze.pidStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_analyzeProcess ID of backend. pg_stat_progress_analyze SELECT pid FROM pg_catalog.pg_stat_progress_analyze; View pg_stat_progress_analyze Field pid SQL type integer Units named in the field defini… pg_stat_progress_analyze.relidStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_analyzeOID of the table being analyzed. pg_stat_progress_analyze SELECT relid FROM pg_catalog.pg_stat_progress_analyze; View pg_stat_progress_analyze Field relid SQL type oid Units named in the fi… pg_stat_progress_analyze.sample_blks_scannedStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_analyzeNumber of heap blocks scanned. pg_stat_progress_analyze SELECT sample_blks_scanned FROM pg_catalog.pg_stat_progress_analyze; View pg_stat_progress_analyze Field sample_blks_scanned SQL type… pg_stat_progress_analyze.sample_blks_totalStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_analyzeTotal number of heap blocks that will be sampled. pg_stat_progress_analyze SELECT sample_blks_total FROM pg_catalog.pg_stat_progress_analyze; View pg_stat_progress_analyze Field sample_blks… pg_stat_progress_analyze.started_byStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_analyzeShows what caused the current ANALYZE operation to be started. Possible values are: manual: The analyze was started by an explicit ANALYZE, or by VACUUM with the ANALYZE option. autovacuum:… pg_stat_progress_basebackup.backup_streamedStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_basebackupAmount of data streamed. This counter only advances when the phase is streaming database files or transferring wal files. pg_stat_progress_basebackup SELECT backup_streamed FROM pg_catalog.… pg_stat_progress_basebackup.backup_totalStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_basebackupTotal amount of data that will be streamed. This is estimated and reported as of the beginning of streaming database files phase. Note that this is only an approximation since the database m… pg_stat_progress_basebackup.backup_typeStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_basebackupBackup type. Either full or incremental. pg_stat_progress_basebackup SELECT backup_type FROM pg_catalog.pg_stat_progress_basebackup; View pg_stat_progress_basebackup Field backup_type SQL t… pg_stat_progress_basebackup.phaseStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_basebackupCurrent processing phase. See Table 27.54. pg_stat_progress_basebackup Current processing phase. See Table 27.41. SELECT phase FROM pg_catalog.pg_stat_progress_basebackup; View pg_stat_prog… pg_stat_progress_basebackup.pidStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_basebackupProcess ID of a WAL sender process. pg_stat_progress_basebackup SELECT pid FROM pg_catalog.pg_stat_progress_basebackup; View pg_stat_progress_basebackup Field pid SQL type integer Units nam…