Search PostgreSQL documentation

pg_stat_progress_basebackup.tablespaces_streamedStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_basebackupNumber of tablespaces streamed. This counter only advances when the phase is streaming database files. pg_stat_progress_basebackup SELECT tablespaces_streamed FROM pg_catalog.pg_stat_progre… pg_stat_progress_basebackup.tablespaces_totalStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_basebackupTotal number of tablespaces that will be streamed. pg_stat_progress_basebackup SELECT tablespaces_total FROM pg_catalog.pg_stat_progress_basebackup; View pg_stat_progress_basebackup Field t… pg_stat_progress_cluster.cluster_index_relidStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_clusterOID of the index defining the order of the rewritten table, or zero if no index ordering is requested. pg_stat_progress_cluster If the table is being scanned using an index, this is the OID… pg_stat_progress_cluster.commandStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_clusterThe command that is running. Either CLUSTER or VACUUM FULL. Because this view exists for backwards-compatibility purposes only, it will translate a REPACK command into CLUSTER if index order… pg_stat_progress_cluster.datidStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_clusterOID of the database to which this backend is connected. pg_stat_progress_cluster SELECT datid FROM pg_catalog.pg_stat_progress_cluster; View pg_stat_progress_cluster Field datid SQL type oi… pg_stat_progress_cluster.datnameStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_clusterName of the database to which this backend is connected. pg_stat_progress_cluster SELECT datname FROM pg_catalog.pg_stat_progress_cluster; View pg_stat_progress_cluster Field datname SQL ty… pg_stat_progress_cluster.heap_blks_scannedStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_clusterNumber of heap blocks scanned. This counter only advances when the phase is seq scanning heap. pg_stat_progress_cluster SELECT heap_blks_scanned FROM pg_catalog.pg_stat_progress_cluster; Vi… pg_stat_progress_cluster.heap_blks_totalStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_clusterTotal number of heap blocks in the table. This number is reported as of the beginning of seq scanning heap. pg_stat_progress_cluster SELECT heap_blks_total FROM pg_catalog.pg_stat_progress_… pg_stat_progress_cluster.heap_tuples_scannedStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_clusterNumber 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_cluster SELECT heap_tuples_scanned F… pg_stat_progress_cluster.heap_tuples_writtenStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_clusterNumber of heap tuples written. This counter only advances when the phase is seq scanning heap, index scanning heap or writing new heap. pg_stat_progress_cluster SELECT heap_tuples_written F… pg_stat_progress_cluster.index_rebuild_countStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_clusterNumber of indexes rebuilt. This counter only advances when the phase is rebuilding index. pg_stat_progress_cluster SELECT index_rebuild_count FROM pg_catalog.pg_stat_progress_cluster; View … pg_stat_progress_cluster.phaseStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_clusterCurrent processing phase. See Table 27.45. pg_stat_progress_cluster Current processing phase. See Table 27.27. SELECT phase FROM pg_catalog.pg_stat_progress_cluster; View pg_stat_progress_c… pg_stat_progress_cluster.pidStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_clusterProcess ID of backend. pg_stat_progress_cluster SELECT pid FROM pg_catalog.pg_stat_progress_cluster; View pg_stat_progress_cluster Field pid SQL type integer Units named in the field defini… pg_stat_progress_cluster.relidStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_clusterOID of the table being clustered. pg_stat_progress_cluster SELECT relid FROM pg_catalog.pg_stat_progress_cluster; View pg_stat_progress_cluster Field relid SQL type oid Units named in the f… pg_stat_progress_copy.bytes_processedStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_copyNumber of bytes already processed by COPY command. pg_stat_progress_copy SELECT bytes_processed FROM pg_catalog.pg_stat_progress_copy; View pg_stat_progress_copy Field bytes_processed SQL t… pg_stat_progress_copy.bytes_totalStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_copySize of source file for COPY FROM command in bytes. It is set to 0 if not available. pg_stat_progress_copy SELECT bytes_total FROM pg_catalog.pg_stat_progress_copy; View pg_stat_progress_co… pg_stat_progress_copy.commandStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_copyThe command that is running: COPY FROM, or COPY TO. pg_stat_progress_copy SELECT command FROM pg_catalog.pg_stat_progress_copy; View pg_stat_progress_copy Field command SQL type text Units … pg_stat_progress_copy.datidStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_copyOID of the database to which this backend is connected. pg_stat_progress_copy SELECT datid FROM pg_catalog.pg_stat_progress_copy; View pg_stat_progress_copy Field datid SQL type oid Units n… pg_stat_progress_copy.datnameStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_copyName of the database to which this backend is connected. pg_stat_progress_copy SELECT datname FROM pg_catalog.pg_stat_progress_copy; View pg_stat_progress_copy Field datname SQL type name U… pg_stat_progress_copy.pidStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_copyProcess ID of backend. pg_stat_progress_copy SELECT pid FROM pg_catalog.pg_stat_progress_copy; View pg_stat_progress_copy Field pid SQL type integer Units named in the field definition Not … pg_stat_progress_copy.relidStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_copyOID of the table on which the COPY command is executed. It is set to 0 if copying from a SELECT query. pg_stat_progress_copy SELECT relid FROM pg_catalog.pg_stat_progress_copy; View pg_stat… pg_stat_progress_copy.tuples_excludedStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_copyNumber of tuples not processed because they were excluded by the WHERE clause of the COPY command. pg_stat_progress_copy SELECT tuples_excluded FROM pg_catalog.pg_stat_progress_copy; View p… pg_stat_progress_copy.tuples_processedStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_copyNumber of tuples already processed by COPY command. pg_stat_progress_copy SELECT tuples_processed FROM pg_catalog.pg_stat_progress_copy; View pg_stat_progress_copy Field tuples_processed SQ… pg_stat_progress_copy.tuples_skippedStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_copyNumber of tuples skipped because they contain malformed data. This counter only advances when ignore is specified to the ON_ERROR option. pg_stat_progress_copy Number of tuples skipped beca… pg_stat_progress_copy.typeStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_copyThe I/O type that the data is read from or written to: FILE, PROGRAM, PIPE (for COPY FROM STDIN and COPY TO STDOUT), or CALLBACK (used for example during the initial table synchronization in… pg_stat_progress_create_index.blocks_doneStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_create_indexNumber of blocks already processed in the current phase. pg_stat_progress_create_index SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index; View pg_stat_progress_create_index F… pg_stat_progress_create_index.blocks_totalStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_create_indexTotal number of blocks to be processed in the current phase. pg_stat_progress_create_index SELECT blocks_total FROM pg_catalog.pg_stat_progress_create_index; View pg_stat_progress_create_in… pg_stat_progress_create_index.commandStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_create_indexSpecific command type: CREATE INDEX, CREATE INDEX CONCURRENTLY, REINDEX, or REINDEX CONCURRENTLY. pg_stat_progress_create_index The command that is running: CREATE INDEX, CREATE INDEX CONCU… pg_stat_progress_create_index.current_locker_pidStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_create_indexProcess ID of the locker currently being waited for. pg_stat_progress_create_index SELECT current_locker_pid FROM pg_catalog.pg_stat_progress_create_index; View pg_stat_progress_create_inde… pg_stat_progress_create_index.datidStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_create_indexOID of the database to which this backend is connected. pg_stat_progress_create_index SELECT datid FROM pg_catalog.pg_stat_progress_create_index; View pg_stat_progress_create_index Field da… pg_stat_progress_create_index.datnameStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_create_indexName of the database to which this backend is connected. pg_stat_progress_create_index SELECT datname FROM pg_catalog.pg_stat_progress_create_index; View pg_stat_progress_create_index Field… pg_stat_progress_create_index.index_relidStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_create_indexOID of the index being created or reindexed. During a non-concurrent CREATE INDEX, this is 0. pg_stat_progress_create_index SELECT index_relid FROM pg_catalog.pg_stat_progress_create_index;… pg_stat_progress_create_index.lockers_doneStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_create_indexNumber of lockers already waited for. pg_stat_progress_create_index SELECT lockers_done FROM pg_catalog.pg_stat_progress_create_index; View pg_stat_progress_create_index Field lockers_done … pg_stat_progress_create_index.lockers_totalStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_create_indexTotal number of lockers to wait for, when applicable. pg_stat_progress_create_index SELECT lockers_total FROM pg_catalog.pg_stat_progress_create_index; View pg_stat_progress_create_index Fi… pg_stat_progress_create_index.partitions_doneStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_create_indexNumber of partitions on which the index has already been created or attached, including both direct and indirect partitions. 0 during a REINDEX, or when the index is not partitioned. pg_sta… pg_stat_progress_create_index.partitions_totalStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_create_indexTotal number of partitions on which the index is to be created or attached, including both direct and indirect partitions. 0 during a REINDEX, or when the index is not partitioned. pg_stat_… pg_stat_progress_create_index.phaseStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_create_indexCurrent processing phase of index creation. See Table 27.48. pg_stat_progress_create_index Current processing phase of index creation. See Table 27.23. SELECT phase FROM pg_catalog.pg_stat_… pg_stat_progress_create_index.pidStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_create_indexProcess ID of the backend creating indexes. pg_stat_progress_create_index Process ID of backend. SELECT pid FROM pg_catalog.pg_stat_progress_create_index; View pg_stat_progress_create_index… pg_stat_progress_create_index.relidStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_create_indexOID of the table on which the index is being created. pg_stat_progress_create_index SELECT relid FROM pg_catalog.pg_stat_progress_create_index; View pg_stat_progress_create_index Field reli… pg_stat_progress_create_index.tuples_doneStatistics & MetricsWikiStatistics & Metrics · pg_stat_progress_create_indexNumber of tuples already processed in the current phase. pg_stat_progress_create_index SELECT tuples_done FROM pg_catalog.pg_stat_progress_create_index; View pg_stat_progress_create_index F…