Search PostgreSQL documentation

pg_stat_user_tables.autoanalyze_countStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_tablesNumber of times this table has been analyzed by the autovacuum daemon pg_stat_user_tables SELECT autoanalyze_count FROM pg_catalog.pg_stat_user_tables; View pg_stat_user_tables Field autoan… pg_stat_user_tables.autovacuum_countStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_tablesNumber of times this table has been vacuumed by the autovacuum daemon pg_stat_user_tables SELECT autovacuum_count FROM pg_catalog.pg_stat_user_tables; View pg_stat_user_tables Field autovac… pg_stat_user_tables.idx_scanStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_tablesNumber of index scans initiated on this table pg_stat_user_tables SELECT idx_scan FROM pg_catalog.pg_stat_user_tables; View pg_stat_user_tables Field idx_scan SQL type bigint Units named in… pg_stat_user_tables.idx_tup_fetchStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_tablesNumber of live rows fetched by index scans pg_stat_user_tables SELECT idx_tup_fetch FROM pg_catalog.pg_stat_user_tables; View pg_stat_user_tables Field idx_tup_fetch SQL type bigint Units n… pg_stat_user_tables.last_analyzeStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_tablesLast time at which this table was manually analyzed pg_stat_user_tables SELECT last_analyze FROM pg_catalog.pg_stat_user_tables; View pg_stat_user_tables Field last_analyze SQL type timesta… pg_stat_user_tables.last_autoanalyzeStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_tablesLast time at which this table was analyzed by the autovacuum daemon pg_stat_user_tables SELECT last_autoanalyze FROM pg_catalog.pg_stat_user_tables; View pg_stat_user_tables Field last_auto… pg_stat_user_tables.last_autovacuumStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_tablesLast time at which this table was vacuumed by the autovacuum daemon pg_stat_user_tables SELECT last_autovacuum FROM pg_catalog.pg_stat_user_tables; View pg_stat_user_tables Field last_autov… pg_stat_user_tables.last_idx_scanStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_tablesThe time of the last index scan on this table, based on the most recent transaction stop time pg_stat_user_tables SELECT last_idx_scan FROM pg_catalog.pg_stat_user_tables; View pg_stat_user… pg_stat_user_tables.last_seq_scanStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_tablesThe time of the last sequential scan on this table, based on the most recent transaction stop time pg_stat_user_tables SELECT last_seq_scan FROM pg_catalog.pg_stat_user_tables; View pg_stat… pg_stat_user_tables.last_vacuumStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_tablesLast time at which this table was manually vacuumed (not counting VACUUM FULL) pg_stat_user_tables SELECT last_vacuum FROM pg_catalog.pg_stat_user_tables; View pg_stat_user_tables Field las… pg_stat_user_tables.n_dead_tupStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_tablesEstimated number of dead rows pg_stat_user_tables SELECT n_dead_tup FROM pg_catalog.pg_stat_user_tables; View pg_stat_user_tables Field n_dead_tup SQL type bigint Units named in the field d… pg_stat_user_tables.n_ins_since_vacuumStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_tablesEstimated number of rows inserted since this table was last vacuumed (not counting VACUUM FULL) pg_stat_user_tables Estimated number of rows inserted since this table was last vacuumed SELE… pg_stat_user_tables.n_live_tupStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_tablesEstimated number of live rows pg_stat_user_tables SELECT n_live_tup FROM pg_catalog.pg_stat_user_tables; View pg_stat_user_tables Field n_live_tup SQL type bigint Units named in the field d… pg_stat_user_tables.n_mod_since_analyzeStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_tablesEstimated number of rows modified since this table was last analyzed pg_stat_user_tables SELECT n_mod_since_analyze FROM pg_catalog.pg_stat_user_tables; View pg_stat_user_tables Field n_mod… pg_stat_user_tables.n_tup_delStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_tablesTotal number of rows deleted pg_stat_user_tables Number of rows deleted SELECT n_tup_del FROM pg_catalog.pg_stat_user_tables; View pg_stat_user_tables Field n_tup_del SQL type bigint Units … pg_stat_user_tables.n_tup_hot_updStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_tablesNumber of rows HOT updated. These are updates where no successor versions are required in indexes. pg_stat_user_tables Number of rows HOT updated (i.e., with no separate index update requir… pg_stat_user_tables.n_tup_insStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_tablesTotal number of rows inserted pg_stat_user_tables Number of rows inserted SELECT n_tup_ins FROM pg_catalog.pg_stat_user_tables; View pg_stat_user_tables Field n_tup_ins SQL type bigint Unit… pg_stat_user_tables.n_tup_newpage_updStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_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_user_tables.n_tup_updStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_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_user_tables Number of rows updated (includes… pg_stat_user_tables.relidStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_tablesOID of a table pg_stat_user_tables SELECT relid FROM pg_catalog.pg_stat_user_tables; View pg_stat_user_tables Field relid SQL type oid Units named in the field definition Not specified Rese… pg_stat_user_tables.relnameStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_tablesName of this table pg_stat_user_tables SELECT relname FROM pg_catalog.pg_stat_user_tables; View pg_stat_user_tables Field relname SQL type name Units named in the field definition Not speci… pg_stat_user_tables.schemanameStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_tablesName of the schema that this table is in pg_stat_user_tables SELECT schemaname FROM pg_catalog.pg_stat_user_tables; View pg_stat_user_tables Field schemaname SQL type name Units named in th… pg_stat_user_tables.seq_scanStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_tablesNumber of sequential scans initiated on this table pg_stat_user_tables SELECT seq_scan FROM pg_catalog.pg_stat_user_tables; View pg_stat_user_tables Field seq_scan SQL type bigint Units nam… pg_stat_user_tables.seq_tup_readStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_tablesNumber of live rows fetched by sequential scans pg_stat_user_tables SELECT seq_tup_read FROM pg_catalog.pg_stat_user_tables; View pg_stat_user_tables Field seq_tup_read SQL type bigint Unit… pg_stat_user_tables.stats_resetStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_tablesTime at which these statistics were last reset pg_stat_user_tables SELECT stats_reset FROM pg_catalog.pg_stat_user_tables; View pg_stat_user_tables Field stats_reset SQL type timestamp with… pg_stat_user_tables.total_analyze_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_tablesTotal time this table has been manually analyzed, in milliseconds. (This includes the time spent sleeping due to cost-based delays.) pg_stat_user_tables SELECT total_analyze_time FROM pg_ca… pg_stat_user_tables.total_autoanalyze_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_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_user_tables SELECT total_autoana… pg_stat_user_tables.total_autovacuum_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_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_user_tables SELECT total_autovac… pg_stat_user_tables.total_vacuum_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_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_user_tables SELECT to… pg_stat_user_tables.vacuum_countStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_tablesNumber of times this table has been manually vacuumed (not counting VACUUM FULL) pg_stat_user_tables SELECT vacuum_count FROM pg_catalog.pg_stat_user_tables; View pg_stat_user_tables Field … pg_stat_wal.stats_resetStatistics & MetricsWikiStatistics & Metrics · pg_stat_walTime at which these statistics were last reset pg_stat_wal SELECT stats_reset FROM pg_catalog.pg_stat_wal; View pg_stat_wal Field stats_reset SQL type timestamp with time zone Units named i… pg_stat_wal.wal_buffers_fullStatistics & MetricsWikiStatistics & Metrics · pg_stat_walNumber of times WAL data was written to disk because WAL buffers became full pg_stat_wal SELECT wal_buffers_full FROM pg_catalog.pg_stat_wal; View pg_stat_wal Field wal_buffers_full SQL typ… pg_stat_wal.wal_bytesStatistics & MetricsWikiStatistics & Metrics · pg_stat_walTotal amount of WAL generated in bytes pg_stat_wal SELECT wal_bytes FROM pg_catalog.pg_stat_wal; View pg_stat_wal Field wal_bytes SQL type numeric Units named in the field definition bytes … pg_stat_wal.wal_fpiStatistics & MetricsWikiStatistics & Metrics · pg_stat_walTotal number of WAL full page images generated pg_stat_wal SELECT wal_fpi FROM pg_catalog.pg_stat_wal; View pg_stat_wal Field wal_fpi SQL type bigint Units named in the field definition Not… pg_stat_wal.wal_fpi_bytesStatistics & MetricsWikiStatistics & Metrics · pg_stat_walTotal amount of WAL full page images in bytes pg_stat_wal SELECT wal_fpi_bytes FROM pg_catalog.pg_stat_wal; View pg_stat_wal Field wal_fpi_bytes SQL type numeric Units named in the field de… pg_stat_wal.wal_recordsStatistics & MetricsWikiStatistics & Metrics · pg_stat_walTotal number of WAL records generated pg_stat_wal SELECT wal_records FROM pg_catalog.pg_stat_wal; View pg_stat_wal Field wal_records SQL type bigint Units named in the field definition Not … pg_stat_wal.wal_syncStatistics & MetricsWikiStatistics & Metrics · pg_stat_walNumber of times WAL files were synced to disk via issue_xlog_fsync request (if fsync is on and wal_sync_method is either fdatasync, fsync or fsync_writethrough, otherwise zero). See Section … pg_stat_wal.wal_sync_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_walTotal amount of time spent syncing WAL files to disk via issue_xlog_fsync request, in milliseconds (if track_wal_io_timing is enabled, fsync is on, and wal_sync_method is either fdatasync, f… pg_stat_wal.wal_writeStatistics & MetricsWikiStatistics & Metrics · pg_stat_walNumber of times WAL buffers were written out to disk via XLogWrite request. See Section 28.5 for more information about the internal WAL function XLogWrite. pg_stat_wal Number of times WAL … pg_stat_wal.wal_write_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_walTotal amount of time spent writing WAL buffers to disk via XLogWrite request, in milliseconds (if track_wal_io_timing is enabled, otherwise zero). This includes the sync time when wal_sync_m…