Search PostgreSQL documentation

pg_stat_subscription.pidStatistics & MetricsWikiStatistics & Metrics · pg_stat_subscriptionProcess ID of the subscription worker process pg_stat_subscription SELECT pid FROM pg_catalog.pg_stat_subscription; View pg_stat_subscription Field pid SQL type integer Units named in the f… pg_stat_subscription.received_lsnStatistics & MetricsWikiStatistics & Metrics · pg_stat_subscriptionLast write-ahead log location received, the initial value of this field being 0; NULL for parallel apply workers and the sequence synchronization worker pg_stat_subscription Last write-ahea… pg_stat_subscription.relidStatistics & MetricsWikiStatistics & Metrics · pg_stat_subscriptionOID of the relation that the worker is synchronizing; NULL for the leader apply worker, parallel apply workers and the sequence synchronization worker pg_stat_subscription OID of the relati… pg_stat_subscription.subidStatistics & MetricsWikiStatistics & Metrics · pg_stat_subscriptionOID of the subscription pg_stat_subscription SELECT subid FROM pg_catalog.pg_stat_subscription; View pg_stat_subscription Field subid SQL type oid Units named in the field definition Not sp… pg_stat_subscription.subnameStatistics & MetricsWikiStatistics & Metrics · pg_stat_subscriptionName of the subscription pg_stat_subscription SELECT subname FROM pg_catalog.pg_stat_subscription; View pg_stat_subscription Field subname SQL type text Units named in the field definition … pg_stat_subscription.worker_typeStatistics & MetricsWikiStatistics & Metrics · pg_stat_subscriptionType of the subscription worker process. Possible types are apply, parallel apply, table synchronization, and sequence synchronization. pg_stat_subscription Type of the subscription worker … pg_stat_subscription_stats.apply_error_countStatistics & MetricsWikiStatistics & Metrics · pg_stat_subscription_statsNumber of times an error occurred while applying changes. Note that any conflict resulting in an apply error will be counted in both apply_error_count and the corresponding conflict count (e… pg_stat_subscription_stats.confl_delete_missingStatistics & MetricsWikiStatistics & Metrics · pg_stat_subscription_statsNumber of times the tuple to be deleted was not found during the application of changes. See delete_missing for details about this conflict. pg_stat_subscription_stats SELECT confl_delete_m… pg_stat_subscription_stats.confl_delete_origin_differsStatistics & MetricsWikiStatistics & Metrics · pg_stat_subscription_statsNumber of times a delete operation was applied to row that had been previously modified by another source during the application of changes. See delete_origin_differs for details about this … pg_stat_subscription_stats.confl_insert_existsStatistics & MetricsWikiStatistics & Metrics · pg_stat_subscription_statsNumber of times a row insertion violated a NOT DEFERRABLE unique constraint during the application of changes. See insert_exists for details about this conflict. pg_stat_subscription_stats … pg_stat_subscription_stats.confl_multiple_unique_conflictsStatistics & MetricsWikiStatistics & Metrics · pg_stat_subscription_statsNumber of times a row insertion or an updated row values violated multiple NOT DEFERRABLE unique constraints during the application of changes. See multiple_unique_conflicts for details abou… pg_stat_subscription_stats.confl_update_deletedStatistics & MetricsWikiStatistics & Metrics · pg_stat_subscription_statsNumber of times the tuple to be updated was concurrently deleted by another source during the application of changes. See update_deleted for details about this conflict. pg_stat_subscriptio… pg_stat_subscription_stats.confl_update_existsStatistics & MetricsWikiStatistics & Metrics · pg_stat_subscription_statsNumber of times that an updated row value violated a NOT DEFERRABLE unique constraint during the application of changes. See update_exists for details about this conflict. pg_stat_subscript… pg_stat_subscription_stats.confl_update_missingStatistics & MetricsWikiStatistics & Metrics · pg_stat_subscription_statsNumber of times the tuple to be updated was not found during the application of changes. See update_missing for details about this conflict. pg_stat_subscription_stats SELECT confl_update_m… pg_stat_subscription_stats.confl_update_origin_differsStatistics & MetricsWikiStatistics & Metrics · pg_stat_subscription_statsNumber of times an update was applied to a row that had been previously modified by another source during the application of changes. See update_origin_differs for details about this conflic… pg_stat_subscription_stats.stats_resetStatistics & MetricsWikiStatistics & Metrics · pg_stat_subscription_statsTime at which these statistics were last reset pg_stat_subscription_stats SELECT stats_reset FROM pg_catalog.pg_stat_subscription_stats; View pg_stat_subscription_stats Field stats_reset SQ… pg_stat_subscription_stats.subidStatistics & MetricsWikiStatistics & Metrics · pg_stat_subscription_statsOID of the subscription pg_stat_subscription_stats SELECT subid FROM pg_catalog.pg_stat_subscription_stats; View pg_stat_subscription_stats Field subid SQL type oid Units named in the field… pg_stat_subscription_stats.subnameStatistics & MetricsWikiStatistics & Metrics · pg_stat_subscription_statsName of the subscription pg_stat_subscription_stats SELECT subname FROM pg_catalog.pg_stat_subscription_stats; View pg_stat_subscription_stats Field subname SQL type name Units named in the… pg_stat_subscription_stats.sync_error_countStatistics & MetricsWikiStatistics & Metrics · pg_stat_subscription_statsNumber of times an error occurred during the initial table synchronization pg_stat_subscription_stats SELECT sync_error_count FROM pg_catalog.pg_stat_subscription_stats; View pg_stat_subscr… pg_stat_subscription_stats.sync_seq_error_countStatistics & MetricsWikiStatistics & Metrics · pg_stat_subscription_statsNumber of times an error occurred in the sequence synchronization worker. A single worker synchronizes all sequences, so one error increment may represent failures across multiple sequences.… pg_stat_subscription_stats.sync_table_error_countStatistics & MetricsWikiStatistics & Metrics · pg_stat_subscription_statsNumber of times an error occurred during the initial table synchronization pg_stat_subscription_stats SELECT sync_table_error_count FROM pg_catalog.pg_stat_subscription_stats; View pg_stat_… pg_stat_sys_indexes.idx_scanStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_indexesNumber of index scans initiated on this index pg_stat_sys_indexes SELECT idx_scan FROM pg_catalog.pg_stat_sys_indexes; View pg_stat_sys_indexes Field idx_scan SQL type bigint Units named in… pg_stat_sys_indexes.idx_tup_fetchStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_indexesNumber of live table rows fetched by simple index scans using this index pg_stat_sys_indexes SELECT idx_tup_fetch FROM pg_catalog.pg_stat_sys_indexes; View pg_stat_sys_indexes Field idx_tup… pg_stat_sys_indexes.idx_tup_readStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_indexesNumber of index entries returned by scans on this index pg_stat_sys_indexes SELECT idx_tup_read FROM pg_catalog.pg_stat_sys_indexes; View pg_stat_sys_indexes Field idx_tup_read SQL type big… pg_stat_sys_indexes.indexrelidStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_indexesOID of this index pg_stat_sys_indexes SELECT indexrelid FROM pg_catalog.pg_stat_sys_indexes; View pg_stat_sys_indexes Field indexrelid SQL type oid Units named in the field definition Not s… pg_stat_sys_indexes.indexrelnameStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_indexesName of this index pg_stat_sys_indexes SELECT indexrelname FROM pg_catalog.pg_stat_sys_indexes; View pg_stat_sys_indexes Field indexrelname SQL type name Units named in the field definition… pg_stat_sys_indexes.last_idx_scanStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_indexesThe time of the last scan on this index, based on the most recent transaction stop time pg_stat_sys_indexes SELECT last_idx_scan FROM pg_catalog.pg_stat_sys_indexes; View pg_stat_sys_indexe… pg_stat_sys_indexes.relidStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_indexesOID of the table for this index pg_stat_sys_indexes SELECT relid FROM pg_catalog.pg_stat_sys_indexes; View pg_stat_sys_indexes Field relid SQL type oid Units named in the field definition N… pg_stat_sys_indexes.relnameStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_indexesName of the table for this index pg_stat_sys_indexes SELECT relname FROM pg_catalog.pg_stat_sys_indexes; View pg_stat_sys_indexes Field relname SQL type name Units named in the field defini… pg_stat_sys_indexes.schemanameStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_indexesName of the schema this index is in pg_stat_sys_indexes SELECT schemaname FROM pg_catalog.pg_stat_sys_indexes; View pg_stat_sys_indexes Field schemaname SQL type name Units named in the fie… pg_stat_sys_indexes.stats_resetStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_indexesTime at which these statistics were last reset pg_stat_sys_indexes SELECT stats_reset FROM pg_catalog.pg_stat_sys_indexes; View pg_stat_sys_indexes Field stats_reset SQL type timestamp with… pg_stat_sys_tables.analyze_countStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_tablesNumber of times this table has been manually analyzed pg_stat_sys_tables SELECT analyze_count FROM pg_catalog.pg_stat_sys_tables; View pg_stat_sys_tables Field analyze_count SQL type bigint… pg_stat_sys_tables.autoanalyze_countStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_tablesNumber of times this table has been analyzed by the autovacuum daemon pg_stat_sys_tables SELECT autoanalyze_count FROM pg_catalog.pg_stat_sys_tables; View pg_stat_sys_tables Field autoanaly… pg_stat_sys_tables.autovacuum_countStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_tablesNumber of times this table has been vacuumed by the autovacuum daemon pg_stat_sys_tables SELECT autovacuum_count FROM pg_catalog.pg_stat_sys_tables; View pg_stat_sys_tables Field autovacuum… pg_stat_sys_tables.idx_scanStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_tablesNumber of index scans initiated on this table pg_stat_sys_tables SELECT idx_scan FROM pg_catalog.pg_stat_sys_tables; View pg_stat_sys_tables Field idx_scan SQL type bigint Units named in th… pg_stat_sys_tables.idx_tup_fetchStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_tablesNumber of live rows fetched by index scans pg_stat_sys_tables SELECT idx_tup_fetch FROM pg_catalog.pg_stat_sys_tables; View pg_stat_sys_tables Field idx_tup_fetch SQL type bigint Units name… pg_stat_sys_tables.last_analyzeStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_tablesLast time at which this table was manually analyzed pg_stat_sys_tables SELECT last_analyze FROM pg_catalog.pg_stat_sys_tables; View pg_stat_sys_tables Field last_analyze SQL type timestamp … pg_stat_sys_tables.last_autoanalyzeStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_tablesLast time at which this table was analyzed by the autovacuum daemon pg_stat_sys_tables SELECT last_autoanalyze FROM pg_catalog.pg_stat_sys_tables; View pg_stat_sys_tables Field last_autoana… pg_stat_sys_tables.last_autovacuumStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_tablesLast time at which this table was vacuumed by the autovacuum daemon pg_stat_sys_tables SELECT last_autovacuum FROM pg_catalog.pg_stat_sys_tables; View pg_stat_sys_tables Field last_autovacu… pg_stat_sys_tables.last_idx_scanStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_tablesThe time of the last index scan on this table, based on the most recent transaction stop time pg_stat_sys_tables SELECT last_idx_scan FROM pg_catalog.pg_stat_sys_tables; View pg_stat_sys_ta…