Search PostgreSQL documentation

pg_stat_all_tables.last_idx_scanStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_tablesThe time of the last index scan on this table, based on the most recent transaction stop time pg_stat_all_tables SELECT last_idx_scan FROM pg_catalog.pg_stat_all_tables; View pg_stat_all_ta… pg_stat_all_tables.last_seq_scanStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_tablesThe time of the last sequential scan on this table, based on the most recent transaction stop time pg_stat_all_tables SELECT last_seq_scan FROM pg_catalog.pg_stat_all_tables; View pg_stat_a… pg_stat_all_tables.last_vacuumStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_tablesLast time at which this table was manually vacuumed (not counting VACUUM FULL) pg_stat_all_tables SELECT last_vacuum FROM pg_catalog.pg_stat_all_tables; View pg_stat_all_tables Field last_v… pg_stat_all_tables.n_dead_tupStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_tablesEstimated number of dead rows pg_stat_all_tables SELECT n_dead_tup FROM pg_catalog.pg_stat_all_tables; View pg_stat_all_tables Field n_dead_tup SQL type bigint Units named in the field defi… pg_stat_all_tables.n_ins_since_vacuumStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_tablesEstimated number of rows inserted since this table was last vacuumed (not counting VACUUM FULL) pg_stat_all_tables Estimated number of rows inserted since this table was last vacuumed SELEC… pg_stat_all_tables.n_live_tupStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_tablesEstimated number of live rows pg_stat_all_tables SELECT n_live_tup FROM pg_catalog.pg_stat_all_tables; View pg_stat_all_tables Field n_live_tup SQL type bigint Units named in the field defi… pg_stat_all_tables.n_mod_since_analyzeStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_tablesEstimated number of rows modified since this table was last analyzed pg_stat_all_tables SELECT n_mod_since_analyze FROM pg_catalog.pg_stat_all_tables; View pg_stat_all_tables Field n_mod_si… pg_stat_all_tables.n_tup_delStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_tablesTotal number of rows deleted pg_stat_all_tables Number of rows deleted SELECT n_tup_del FROM pg_catalog.pg_stat_all_tables; View pg_stat_all_tables Field n_tup_del SQL type bigint Units nam… pg_stat_all_tables.n_tup_hot_updStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_tablesNumber of rows HOT updated. These are updates where no successor versions are required in indexes. pg_stat_all_tables Number of rows HOT updated (i.e., with no separate index update require… pg_stat_all_tables.n_tup_insStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_tablesTotal number of rows inserted pg_stat_all_tables Number of rows inserted SELECT n_tup_ins FROM pg_catalog.pg_stat_all_tables; View pg_stat_all_tables Field n_tup_ins SQL type bigint Units n… pg_stat_all_tables.n_tup_newpage_updStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_tablesNumber of rows updated where the successor version goes onto a new heap page, leaving behind an original version with a t_ctid field that points to a different heap page. These are always no… pg_stat_all_tables.n_tup_updStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_tablesTotal number of rows updated. (This includes row updates counted in n_tup_hot_upd and n_tup_newpage_upd, and remaining non-HOT updates.) pg_stat_all_tables Number of rows updated (includes … pg_stat_all_tables.relidStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_tablesOID of a table pg_stat_all_tables SELECT relid FROM pg_catalog.pg_stat_all_tables; View pg_stat_all_tables Field relid SQL type oid Units named in the field definition Not specified Reset o… pg_stat_all_tables.relnameStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_tablesName of this table pg_stat_all_tables SELECT relname FROM pg_catalog.pg_stat_all_tables; View pg_stat_all_tables Field relname SQL type name Units named in the field definition Not specifie… pg_stat_all_tables.schemanameStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_tablesName of the schema that this table is in pg_stat_all_tables SELECT schemaname FROM pg_catalog.pg_stat_all_tables; View pg_stat_all_tables Field schemaname SQL type name Units named in the f… pg_stat_all_tables.seq_scanStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_tablesNumber of sequential scans initiated on this table pg_stat_all_tables SELECT seq_scan FROM pg_catalog.pg_stat_all_tables; View pg_stat_all_tables Field seq_scan SQL type bigint Units named … pg_stat_all_tables.seq_tup_readStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_tablesNumber of live rows fetched by sequential scans pg_stat_all_tables SELECT seq_tup_read FROM pg_catalog.pg_stat_all_tables; View pg_stat_all_tables Field seq_tup_read SQL type bigint Units n… pg_stat_all_tables.stats_resetStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_tablesTime at which these statistics were last reset pg_stat_all_tables SELECT stats_reset FROM pg_catalog.pg_stat_all_tables; View pg_stat_all_tables Field stats_reset SQL type timestamp with ti… pg_stat_all_tables.total_analyze_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_tablesTotal time this table has been manually analyzed, in milliseconds. (This includes the time spent sleeping due to cost-based delays.) pg_stat_all_tables SELECT total_analyze_time FROM pg_cat… pg_stat_all_tables.total_autoanalyze_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_tablesTotal time this table has been analyzed by the autovacuum daemon, in milliseconds. (This includes the time spent sleeping due to cost-based delays.) pg_stat_all_tables SELECT total_autoanal… pg_stat_all_tables.total_autovacuum_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_tablesTotal time this table has been vacuumed by the autovacuum daemon, in milliseconds. (This includes the time spent sleeping due to cost-based delays.) pg_stat_all_tables SELECT total_autovacu… pg_stat_all_tables.total_vacuum_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_tablesTotal time this table has been manually vacuumed, in milliseconds (not counting VACUUM FULL). (This includes the time spent sleeping due to cost-based delays.) pg_stat_all_tables SELECT tot… pg_stat_all_tables.vacuum_countStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_tablesNumber of times this table has been manually vacuumed (not counting VACUUM FULL) pg_stat_all_tables SELECT vacuum_count FROM pg_catalog.pg_stat_all_tables; View pg_stat_all_tables Field vac… pg_stat_archiver.archived_countStatistics & MetricsWikiStatistics & Metrics · pg_stat_archiverNumber of WAL files that have been successfully archived pg_stat_archiver SELECT archived_count FROM pg_catalog.pg_stat_archiver; View pg_stat_archiver Field archived_count SQL type bigint … pg_stat_archiver.failed_countStatistics & MetricsWikiStatistics & Metrics · pg_stat_archiverNumber of failed attempts for archiving WAL files pg_stat_archiver SELECT failed_count FROM pg_catalog.pg_stat_archiver; View pg_stat_archiver Field failed_count SQL type bigint Units named… pg_stat_archiver.last_archived_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_archiverTime of the most recent successful archive operation pg_stat_archiver Time of the last successful archive operation SELECT last_archived_time FROM pg_catalog.pg_stat_archiver; View pg_stat_… pg_stat_archiver.last_archived_walStatistics & MetricsWikiStatistics & Metrics · pg_stat_archiverName of the WAL file most recently successfully archived pg_stat_archiver Name of the last WAL file successfully archived SELECT last_archived_wal FROM pg_catalog.pg_stat_archiver; View pg_… pg_stat_archiver.last_failed_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_archiverTime of the most recent failed archival operation pg_stat_archiver Time of the last failed archival operation SELECT last_failed_time FROM pg_catalog.pg_stat_archiver; View pg_stat_archiver… pg_stat_archiver.last_failed_walStatistics & MetricsWikiStatistics & Metrics · pg_stat_archiverName of the WAL file of the most recent failed archival operation pg_stat_archiver Name of the WAL file of the last failed archival operation SELECT last_failed_wal FROM pg_catalog.pg_stat_… pg_stat_archiver.stats_resetStatistics & MetricsWikiStatistics & Metrics · pg_stat_archiverTime at which these statistics were last reset pg_stat_archiver SELECT stats_reset FROM pg_catalog.pg_stat_archiver; View pg_stat_archiver Field stats_reset SQL type timestamp with time zon… pg_stat_autovacuum_scores.analyze_scoreStatistics & MetricsWikiStatistics & Metrics · pg_stat_autovacuum_scoresAnalyze component score. Scores greater than autovacuum_analyze_score_weight indicate that autovacuum would analyze the table (unless autovacuum is disabled). pg_stat_autovacuum_scores SELE… pg_stat_autovacuum_scores.do_analyzeStatistics & MetricsWikiStatistics & Metrics · pg_stat_autovacuum_scoresWhether autovacuum would analyze the table. Note that even if the component scores indicate that autovacuum would analyze the table, this may be false if autovacuum is disabled. pg_stat_aut… pg_stat_autovacuum_scores.do_vacuumStatistics & MetricsWikiStatistics & Metrics · pg_stat_autovacuum_scoresWhether autovacuum would vacuum the table. Note that even if the component scores indicate that autovacuum would vacuum the table, this may be false if autovacuum is disabled. pg_stat_autov… pg_stat_autovacuum_scores.for_wraparoundStatistics & MetricsWikiStatistics & Metrics · pg_stat_autovacuum_scoresWhether autovacuum would vacuum the table for wraparound prevention. pg_stat_autovacuum_scores SELECT for_wraparound FROM pg_catalog.pg_stat_autovacuum_scores; View pg_stat_autovacuum_score… pg_stat_autovacuum_scores.mxid_scoreStatistics & MetricsWikiStatistics & Metrics · pg_stat_autovacuum_scoresMultixact ID age component score. Scores greater than autovacuum_multixact_freeze_score_weight indicate that autovacuum would vacuum the table for multixact ID wraparound prevention. pg_sta… pg_stat_autovacuum_scores.relidStatistics & MetricsWikiStatistics & Metrics · pg_stat_autovacuum_scoresOid of the table. pg_stat_autovacuum_scores SELECT relid FROM pg_catalog.pg_stat_autovacuum_scores; View pg_stat_autovacuum_scores Field relid SQL type oid Units named in the field definiti… pg_stat_autovacuum_scores.relnameStatistics & MetricsWikiStatistics & Metrics · pg_stat_autovacuum_scoresName of the table. pg_stat_autovacuum_scores SELECT relname FROM pg_catalog.pg_stat_autovacuum_scores; View pg_stat_autovacuum_scores Field relname SQL type name Units named in the field de… pg_stat_autovacuum_scores.schemanameStatistics & MetricsWikiStatistics & Metrics · pg_stat_autovacuum_scoresName of the schema that the table is in. pg_stat_autovacuum_scores SELECT schemaname FROM pg_catalog.pg_stat_autovacuum_scores; View pg_stat_autovacuum_scores Field schemaname SQL type name… pg_stat_autovacuum_scores.scoreStatistics & MetricsWikiStatistics & Metrics · pg_stat_autovacuum_scoresMaximum value of all component scores. This is the value that autovacuum would use to sort the list of tables to process. pg_stat_autovacuum_scores SELECT score FROM pg_catalog.pg_stat_auto… pg_stat_autovacuum_scores.vacuum_insert_scoreStatistics & MetricsWikiStatistics & Metrics · pg_stat_autovacuum_scoresVacuum insert component score. Scores greater than autovacuum_vacuum_insert_score_weight indicate that autovacuum would vacuum the table (unless autovacuum is disabled). pg_stat_autovacuum_…