Search PostgreSQL documentation

pg_stat_progress_create_index.tuples_totalStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_create_indexTotal number of tuples to be processed in the current phase. pg_stat_progress_create_index SELECT tuples_total FROM pg_catalog.pg_stat_progress_create_index; View pg_stat_progress_create_in… pg_stat_progress_data_checksums.blocks_doneStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_data_checksumsThe number of blocks in the current relation fork which have been processed. The launcher process has this set to NULL. pg_stat_progress_data_checksums SELECT blocks_done FROM pg_catalog.pg… pg_stat_progress_data_checksums.blocks_totalStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_data_checksumsThe number of blocks in the current relation fork which will be processed, or NULL if the worker process hasn't calculated the number of blocks yet. The launcher process has this set to NULL… pg_stat_progress_data_checksums.databases_doneStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_data_checksumsThe number of databases which have been processed. Only the launcher process has this value set when enabling data checksums; otherwise this is set to NULL. pg_stat_progress_data_checksums … pg_stat_progress_data_checksums.databases_totalStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_data_checksumsThe total number of databases which will be processed. Only the launcher process has this value set when enabling data checksums; otherwise this is set to NULL. pg_stat_progress_data_checks… pg_stat_progress_data_checksums.datidStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_data_checksumsOID of this database, or 0 for the launcher process. pg_stat_progress_data_checksums SELECT datid FROM pg_catalog.pg_stat_progress_data_checksums; View pg_stat_progress_data_checksums Field… pg_stat_progress_data_checksums.datnameStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_data_checksumsName of this database, or NULL for the launcher process. pg_stat_progress_data_checksums SELECT datname FROM pg_catalog.pg_stat_progress_data_checksums; View pg_stat_progress_data_checksums… pg_stat_progress_data_checksums.phaseStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_data_checksumsCurrent processing phase, see Table 27.56 for description of the phases. pg_stat_progress_data_checksums SELECT phase FROM pg_catalog.pg_stat_progress_data_checksums; View pg_stat_progress_… pg_stat_progress_data_checksums.pidStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_data_checksumsProcess ID of the data checksum process, launcher or worker. pg_stat_progress_data_checksums SELECT pid FROM pg_catalog.pg_stat_progress_data_checksums; View pg_stat_progress_data_checksums… pg_stat_progress_data_checksums.relations_doneStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_data_checksumsThe number of relations which have been processed. The launcher process has this set to NULL. pg_stat_progress_data_checksums SELECT relations_done FROM pg_catalog.pg_stat_progress_data_che… pg_stat_progress_data_checksums.relations_totalStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_data_checksumsThe total number of relations which will be processed, or NULL if the worker process hasn't calculated the number of relations yet. The launcher process has this set to NULL since it isn't r… pg_stat_progress_repack.commandStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_repackThe command that is running. One of CLUSTER, REPACK, or VACUUM FULL. pg_stat_progress_repack SELECT command FROM pg_catalog.pg_stat_progress_repack; View pg_stat_progress_repack Field comma… pg_stat_progress_repack.datidStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_repackOID of the database to which this backend is connected. pg_stat_progress_repack SELECT datid FROM pg_catalog.pg_stat_progress_repack; View pg_stat_progress_repack Field datid SQL type oid U… pg_stat_progress_repack.datnameStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_repackName of the database to which this backend is connected. pg_stat_progress_repack SELECT datname FROM pg_catalog.pg_stat_progress_repack; View pg_stat_progress_repack Field datname SQL type … pg_stat_progress_repack.heap_blks_scannedStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_repackNumber of heap blocks scanned. This counter only advances when the phase is seq scanning heap. pg_stat_progress_repack SELECT heap_blks_scanned FROM pg_catalog.pg_stat_progress_repack; View… pg_stat_progress_repack.heap_blks_totalStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_repackTotal number of heap blocks in the table. This number is reported as of the beginning of seq scanning heap. pg_stat_progress_repack SELECT heap_blks_total FROM pg_catalog.pg_stat_progress_r… pg_stat_progress_repack.heap_tuples_deletedStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_repackNumber of heap tuples deleted. This counter only advances when the phase is catch-up. pg_stat_progress_repack SELECT heap_tuples_deleted FROM pg_catalog.pg_stat_progress_repack; View pg_sta… pg_stat_progress_repack.heap_tuples_insertedStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_repackNumber of heap tuples inserted. This counter only advances when the phase is seq scanning heap, index scanning heap, writing new heap or catch-up. pg_stat_progress_repack SELECT heap_tuples… pg_stat_progress_repack.heap_tuples_scannedStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_repackNumber of heap tuples scanned. This counter only advances when the phase is seq scanning heap, index scanning heap or writing new heap. pg_stat_progress_repack SELECT heap_tuples_scanned FR… pg_stat_progress_repack.heap_tuples_updatedStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_repackNumber of heap tuples updated. This counter only advances when the phase is catch-up. pg_stat_progress_repack SELECT heap_tuples_updated FROM pg_catalog.pg_stat_progress_repack; View pg_sta… pg_stat_progress_repack.index_rebuild_countStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_repackNumber of indexes rebuilt. This counter only advances when the phase is rebuilding index. pg_stat_progress_repack SELECT index_rebuild_count FROM pg_catalog.pg_stat_progress_repack; View pg… pg_stat_progress_repack.phaseStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_repackCurrent processing phase. See Table 27.50. pg_stat_progress_repack Current processing phase. See Table 27.49. SELECT phase FROM pg_catalog.pg_stat_progress_repack; View pg_stat_progress_rep… pg_stat_progress_repack.pidStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_repackProcess ID of backend. pg_stat_progress_repack SELECT pid FROM pg_catalog.pg_stat_progress_repack; View pg_stat_progress_repack Field pid SQL type integer Units named in the field definitio… pg_stat_progress_repack.relidStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_repackOID of the table being processed. pg_stat_progress_repack SELECT relid FROM pg_catalog.pg_stat_progress_repack; View pg_stat_progress_repack Field relid SQL type oid Units named in the fiel… pg_stat_progress_repack.repack_index_relidStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_repackOID of the index defining the order of the rewritten table, or zero if no index ordering is requested. pg_stat_progress_repack SELECT repack_index_relid FROM pg_catalog.pg_stat_progress_rep… pg_stat_progress_vacuum.datidStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_vacuumOID of the database to which this backend is connected. pg_stat_progress_vacuum SELECT datid FROM pg_catalog.pg_stat_progress_vacuum; View pg_stat_progress_vacuum Field datid SQL type oid U… pg_stat_progress_vacuum.datnameStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_vacuumName of the database to which this backend is connected. pg_stat_progress_vacuum SELECT datname FROM pg_catalog.pg_stat_progress_vacuum; View pg_stat_progress_vacuum Field datname SQL type … pg_stat_progress_vacuum.dead_tuple_bytesStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_vacuumAmount of dead tuple data collected since the last index vacuum cycle. pg_stat_progress_vacuum SELECT dead_tuple_bytes FROM pg_catalog.pg_stat_progress_vacuum; View pg_stat_progress_vacuum … pg_stat_progress_vacuum.delay_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_vacuumTotal time spent sleeping due to cost-based delay (see Section 19.10.2), in milliseconds (if track_cost_delay_timing is enabled, otherwise zero). This includes the time that any associated p… pg_stat_progress_vacuum.heap_blks_scannedStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_vacuumNumber of heap blocks scanned. Because the visibility map is used to optimize scans, some blocks will be skipped without inspection; skipped blocks are included in this total, so that this n… pg_stat_progress_vacuum.heap_blks_totalStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_vacuumTotal number of heap blocks in the table. This number is reported as of the beginning of the scan; blocks added later will not be (and need not be) visited by this VACUUM. pg_stat_progress_… pg_stat_progress_vacuum.heap_blks_vacuumedStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_vacuumNumber of heap blocks vacuumed. Unless the table has no indexes, this counter only advances when the phase is vacuuming heap. Blocks that contain no dead tuples are skipped, so the counter m… pg_stat_progress_vacuum.index_vacuum_countStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_vacuumNumber of completed index vacuum cycles. pg_stat_progress_vacuum SELECT index_vacuum_count FROM pg_catalog.pg_stat_progress_vacuum; View pg_stat_progress_vacuum Field index_vacuum_count SQL… pg_stat_progress_vacuum.indexes_processedStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_vacuumNumber of indexes processed. This counter only advances when the phase is vacuuming indexes or cleaning up indexes. pg_stat_progress_vacuum SELECT indexes_processed FROM pg_catalog.pg_stat_… pg_stat_progress_vacuum.indexes_totalStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_vacuumTotal number of indexes that will be vacuumed or cleaned up. This number is reported at the beginning of the vacuuming indexes phase or the cleaning up indexes phase. pg_stat_progress_vacuu… pg_stat_progress_vacuum.max_dead_tuple_bytesStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_vacuumAmount of dead tuple data that we can store before needing to perform an index vacuum cycle, based on maintenance_work_mem. pg_stat_progress_vacuum SELECT max_dead_tuple_bytes FROM pg_catal… pg_stat_progress_vacuum.max_dead_tuplesStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_vacuumNumber of dead tuples that we can store before needing to perform an index vacuum cycle, based on maintenance_work_mem. pg_stat_progress_vacuum SELECT max_dead_tuples FROM pg_catalog.pg_sta… pg_stat_progress_vacuum.modeStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_vacuumThe mode in which the current VACUUM operation is running. See Section 24.1.5 for details of each mode. Possible values are: normal: The operation is performing a standard vacuum. It is nei… pg_stat_progress_vacuum.num_dead_item_idsStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_vacuumNumber of dead item identifiers collected since the last index vacuum cycle. pg_stat_progress_vacuum SELECT num_dead_item_ids FROM pg_catalog.pg_stat_progress_vacuum; View pg_stat_progress_… pg_stat_progress_vacuum.num_dead_tuplesStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_vacuumNumber of dead tuples collected since the last index vacuum cycle. pg_stat_progress_vacuum SELECT num_dead_tuples FROM pg_catalog.pg_stat_progress_vacuum; View pg_stat_progress_vacuum Field…