Search PostgreSQL documentation

pg_stat_sys_tables.last_seq_scanStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_tablesThe time of the last sequential scan on this table, based on the most recent transaction stop time pg_stat_sys_tables SELECT last_seq_scan FROM pg_catalog.pg_stat_sys_tables; View pg_stat_s… pg_stat_sys_tables.last_vacuumStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_tablesLast time at which this table was manually vacuumed (not counting VACUUM FULL) pg_stat_sys_tables SELECT last_vacuum FROM pg_catalog.pg_stat_sys_tables; View pg_stat_sys_tables Field last_v… pg_stat_sys_tables.n_dead_tupStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_tablesEstimated number of dead rows pg_stat_sys_tables SELECT n_dead_tup FROM pg_catalog.pg_stat_sys_tables; View pg_stat_sys_tables Field n_dead_tup SQL type bigint Units named in the field defi… pg_stat_sys_tables.n_ins_since_vacuumStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_tablesEstimated number of rows inserted since this table was last vacuumed (not counting VACUUM FULL) pg_stat_sys_tables Estimated number of rows inserted since this table was last vacuumed SELEC… pg_stat_sys_tables.n_live_tupStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_tablesEstimated number of live rows pg_stat_sys_tables SELECT n_live_tup FROM pg_catalog.pg_stat_sys_tables; View pg_stat_sys_tables Field n_live_tup SQL type bigint Units named in the field defi… pg_stat_sys_tables.n_mod_since_analyzeStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_tablesEstimated number of rows modified since this table was last analyzed pg_stat_sys_tables SELECT n_mod_since_analyze FROM pg_catalog.pg_stat_sys_tables; View pg_stat_sys_tables Field n_mod_si… pg_stat_sys_tables.n_tup_delStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_tablesTotal number of rows deleted pg_stat_sys_tables Number of rows deleted SELECT n_tup_del FROM pg_catalog.pg_stat_sys_tables; View pg_stat_sys_tables Field n_tup_del SQL type bigint Units nam… pg_stat_sys_tables.n_tup_hot_updStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_tablesNumber of rows HOT updated. These are updates where no successor versions are required in indexes. pg_stat_sys_tables Number of rows HOT updated (i.e., with no separate index update require… pg_stat_sys_tables.n_tup_insStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_tablesTotal number of rows inserted pg_stat_sys_tables Number of rows inserted SELECT n_tup_ins FROM pg_catalog.pg_stat_sys_tables; View pg_stat_sys_tables Field n_tup_ins SQL type bigint Units n… pg_stat_sys_tables.n_tup_newpage_updStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_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_sys_tables.n_tup_updStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_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_sys_tables Number of rows updated (includes … pg_stat_sys_tables.relidStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_tablesOID of a table pg_stat_sys_tables SELECT relid FROM pg_catalog.pg_stat_sys_tables; View pg_stat_sys_tables Field relid SQL type oid Units named in the field definition Not specified Reset o… pg_stat_sys_tables.relnameStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_tablesName of this table pg_stat_sys_tables SELECT relname FROM pg_catalog.pg_stat_sys_tables; View pg_stat_sys_tables Field relname SQL type name Units named in the field definition Not specifie… pg_stat_sys_tables.schemanameStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_tablesName of the schema that this table is in pg_stat_sys_tables SELECT schemaname FROM pg_catalog.pg_stat_sys_tables; View pg_stat_sys_tables Field schemaname SQL type name Units named in the f… pg_stat_sys_tables.seq_scanStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_tablesNumber of sequential scans initiated on this table pg_stat_sys_tables SELECT seq_scan FROM pg_catalog.pg_stat_sys_tables; View pg_stat_sys_tables Field seq_scan SQL type bigint Units named … pg_stat_sys_tables.seq_tup_readStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_tablesNumber of live rows fetched by sequential scans pg_stat_sys_tables SELECT seq_tup_read FROM pg_catalog.pg_stat_sys_tables; View pg_stat_sys_tables Field seq_tup_read SQL type bigint Units n… pg_stat_sys_tables.stats_resetStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_tablesTime at which these statistics were last reset pg_stat_sys_tables SELECT stats_reset FROM pg_catalog.pg_stat_sys_tables; View pg_stat_sys_tables Field stats_reset SQL type timestamp with ti… pg_stat_sys_tables.total_analyze_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_tablesTotal time this table has been manually analyzed, in milliseconds. (This includes the time spent sleeping due to cost-based delays.) pg_stat_sys_tables SELECT total_analyze_time FROM pg_cat… pg_stat_sys_tables.total_autoanalyze_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_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_sys_tables SELECT total_autoanal… pg_stat_sys_tables.total_autovacuum_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_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_sys_tables SELECT total_autovacu… pg_stat_sys_tables.total_vacuum_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_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_sys_tables SELECT tot… pg_stat_sys_tables.vacuum_countStatistics & MetricsWikiStatistics & Metrics · pg_stat_sys_tablesNumber of times this table has been manually vacuumed (not counting VACUUM FULL) pg_stat_sys_tables SELECT vacuum_count FROM pg_catalog.pg_stat_sys_tables; View pg_stat_sys_tables Field vac… pg_stat_user_functions.callsStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_functionsNumber of times this function has been called pg_stat_user_functions SELECT calls FROM pg_catalog.pg_stat_user_functions; View pg_stat_user_functions Field calls SQL type bigint Units named… pg_stat_user_functions.funcidStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_functionsOID of a function pg_stat_user_functions SELECT funcid FROM pg_catalog.pg_stat_user_functions; View pg_stat_user_functions Field funcid SQL type oid Units named in the field definition Not … pg_stat_user_functions.funcnameStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_functionsName of this function pg_stat_user_functions SELECT funcname FROM pg_catalog.pg_stat_user_functions; View pg_stat_user_functions Field funcname SQL type name Units named in the field defini… pg_stat_user_functions.schemanameStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_functionsName of the schema this function is in pg_stat_user_functions SELECT schemaname FROM pg_catalog.pg_stat_user_functions; View pg_stat_user_functions Field schemaname SQL type name Units name… pg_stat_user_functions.self_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_functionsTotal time spent in this function itself, not including other functions called by it, in milliseconds pg_stat_user_functions SELECT self_time FROM pg_catalog.pg_stat_user_functions; View pg… pg_stat_user_functions.stats_resetStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_functionsTime at which these statistics were last reset pg_stat_user_functions SELECT stats_reset FROM pg_catalog.pg_stat_user_functions; View pg_stat_user_functions Field stats_reset SQL type times… pg_stat_user_functions.total_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_functionsTotal time spent in this function and all other functions called by it, in milliseconds pg_stat_user_functions SELECT total_time FROM pg_catalog.pg_stat_user_functions; View pg_stat_user_fu… pg_stat_user_indexes.idx_scanStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_indexesNumber of index scans initiated on this index pg_stat_user_indexes SELECT idx_scan FROM pg_catalog.pg_stat_user_indexes; View pg_stat_user_indexes Field idx_scan SQL type bigint Units named… pg_stat_user_indexes.idx_tup_fetchStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_indexesNumber of live table rows fetched by simple index scans using this index pg_stat_user_indexes SELECT idx_tup_fetch FROM pg_catalog.pg_stat_user_indexes; View pg_stat_user_indexes Field idx_… pg_stat_user_indexes.idx_tup_readStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_indexesNumber of index entries returned by scans on this index pg_stat_user_indexes SELECT idx_tup_read FROM pg_catalog.pg_stat_user_indexes; View pg_stat_user_indexes Field idx_tup_read SQL type … pg_stat_user_indexes.indexrelidStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_indexesOID of this index pg_stat_user_indexes SELECT indexrelid FROM pg_catalog.pg_stat_user_indexes; View pg_stat_user_indexes Field indexrelid SQL type oid Units named in the field definition No… pg_stat_user_indexes.indexrelnameStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_indexesName of this index pg_stat_user_indexes SELECT indexrelname FROM pg_catalog.pg_stat_user_indexes; View pg_stat_user_indexes Field indexrelname SQL type name Units named in the field definit… pg_stat_user_indexes.last_idx_scanStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_indexesThe time of the last scan on this index, based on the most recent transaction stop time pg_stat_user_indexes SELECT last_idx_scan FROM pg_catalog.pg_stat_user_indexes; View pg_stat_user_ind… pg_stat_user_indexes.relidStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_indexesOID of the table for this index pg_stat_user_indexes SELECT relid FROM pg_catalog.pg_stat_user_indexes; View pg_stat_user_indexes Field relid SQL type oid Units named in the field definitio… pg_stat_user_indexes.relnameStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_indexesName of the table for this index pg_stat_user_indexes SELECT relname FROM pg_catalog.pg_stat_user_indexes; View pg_stat_user_indexes Field relname SQL type name Units named in the field def… pg_stat_user_indexes.schemanameStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_indexesName of the schema this index is in pg_stat_user_indexes SELECT schemaname FROM pg_catalog.pg_stat_user_indexes; View pg_stat_user_indexes Field schemaname SQL type name Units named in the … pg_stat_user_indexes.stats_resetStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_indexesTime at which these statistics were last reset pg_stat_user_indexes SELECT stats_reset FROM pg_catalog.pg_stat_user_indexes; View pg_stat_user_indexes Field stats_reset SQL type timestamp w… pg_stat_user_tables.analyze_countStatistics & MetricsWikiStatistics & Metrics · pg_stat_user_tablesNumber of times this table has been manually analyzed pg_stat_user_tables SELECT analyze_count FROM pg_catalog.pg_stat_user_tables; View pg_stat_user_tables Field analyze_count SQL type big…