Search PostgreSQL documentation

pg_stat_xact_user_functions.callsStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_user_functionsSource-defined field pg_stat_xact_user_functions.calls. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_stat_x… pg_stat_xact_user_functions.funcidStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_user_functionsSource-defined field pg_stat_xact_user_functions.funcid. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_stat_… pg_stat_xact_user_functions.funcnameStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_user_functionsSource-defined field pg_stat_xact_user_functions.funcname. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_sta… pg_stat_xact_user_functions.schemanameStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_user_functionsSource-defined field pg_stat_xact_user_functions.schemaname. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_s… pg_stat_xact_user_functions.self_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_user_functionsSource-defined field pg_stat_xact_user_functions.self_time. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_st… pg_stat_xact_user_functions.total_timeStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_user_functionsSource-defined field pg_stat_xact_user_functions.total_time. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_s… pg_stat_xact_user_tables.idx_scanStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_user_tablesSource-defined field pg_stat_xact_user_tables.idx_scan. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_stat_x… pg_stat_xact_user_tables.idx_tup_fetchStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_user_tablesSource-defined field pg_stat_xact_user_tables.idx_tup_fetch. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_s… pg_stat_xact_user_tables.n_tup_delStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_user_tablesSource-defined field pg_stat_xact_user_tables.n_tup_del. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_stat_… pg_stat_xact_user_tables.n_tup_hot_updStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_user_tablesSource-defined field pg_stat_xact_user_tables.n_tup_hot_upd. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_s… pg_stat_xact_user_tables.n_tup_insStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_user_tablesSource-defined field pg_stat_xact_user_tables.n_tup_ins. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_stat_… pg_stat_xact_user_tables.n_tup_newpage_updStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_user_tablesSource-defined field pg_stat_xact_user_tables.n_tup_newpage_upd. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. … pg_stat_xact_user_tables.n_tup_updStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_user_tablesSource-defined field pg_stat_xact_user_tables.n_tup_upd. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_stat_… pg_stat_xact_user_tables.relidStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_user_tablesSource-defined field pg_stat_xact_user_tables.relid. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_stat_xact… pg_stat_xact_user_tables.relnameStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_user_tablesSource-defined field pg_stat_xact_user_tables.relname. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_stat_xa… pg_stat_xact_user_tables.schemanameStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_user_tablesSource-defined field pg_stat_xact_user_tables.schemaname. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_stat… pg_stat_xact_user_tables.seq_scanStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_user_tablesSource-defined field pg_stat_xact_user_tables.seq_scan. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_stat_x… pg_stat_xact_user_tables.seq_tup_readStatistics & MetricsWikiStatistics & Metrics · pg_stat_xact_user_tablesSource-defined field pg_stat_xact_user_tables.seq_tup_read. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below. pg_st… pg_statio_all_indexes.idx_blks_hitStatistics & MetricsWikiStatistics & Metrics · pg_statio_all_indexesNumber of buffer hits in this index pg_statio_all_indexes SELECT idx_blks_hit FROM pg_catalog.pg_statio_all_indexes; View pg_statio_all_indexes Field idx_blks_hit SQL type bigint Units name… pg_statio_all_indexes.idx_blks_readStatistics & MetricsWikiStatistics & Metrics · pg_statio_all_indexesNumber of disk blocks read from this index pg_statio_all_indexes SELECT idx_blks_read FROM pg_catalog.pg_statio_all_indexes; View pg_statio_all_indexes Field idx_blks_read SQL type bigint U… pg_statio_all_indexes.indexrelidStatistics & MetricsWikiStatistics & Metrics · pg_statio_all_indexesOID of this index pg_statio_all_indexes SELECT indexrelid FROM pg_catalog.pg_statio_all_indexes; View pg_statio_all_indexes Field indexrelid SQL type oid Units named in the field definition… pg_statio_all_indexes.indexrelnameStatistics & MetricsWikiStatistics & Metrics · pg_statio_all_indexesName of this index pg_statio_all_indexes SELECT indexrelname FROM pg_catalog.pg_statio_all_indexes; View pg_statio_all_indexes Field indexrelname SQL type name Units named in the field defi… pg_statio_all_indexes.relidStatistics & MetricsWikiStatistics & Metrics · pg_statio_all_indexesOID of the table for this index pg_statio_all_indexes SELECT relid FROM pg_catalog.pg_statio_all_indexes; View pg_statio_all_indexes Field relid SQL type oid Units named in the field defini… pg_statio_all_indexes.relnameStatistics & MetricsWikiStatistics & Metrics · pg_statio_all_indexesName of the table for this index pg_statio_all_indexes SELECT relname FROM pg_catalog.pg_statio_all_indexes; View pg_statio_all_indexes Field relname SQL type name Units named in the field … pg_statio_all_indexes.schemanameStatistics & MetricsWikiStatistics & Metrics · pg_statio_all_indexesName of the schema this index is in pg_statio_all_indexes SELECT schemaname FROM pg_catalog.pg_statio_all_indexes; View pg_statio_all_indexes Field schemaname SQL type name Units named in t… pg_statio_all_indexes.stats_resetStatistics & MetricsWikiStatistics & Metrics · pg_statio_all_indexesTime at which these statistics were last reset pg_statio_all_indexes SELECT stats_reset FROM pg_catalog.pg_statio_all_indexes; View pg_statio_all_indexes Field stats_reset SQL type timestam… pg_statio_all_sequences.blks_hitStatistics & MetricsWikiStatistics & Metrics · pg_statio_all_sequencesNumber of buffer hits in this sequence pg_statio_all_sequences SELECT blks_hit FROM pg_catalog.pg_statio_all_sequences; View pg_statio_all_sequences Field blks_hit SQL type bigint Units nam… pg_statio_all_sequences.blks_readStatistics & MetricsWikiStatistics & Metrics · pg_statio_all_sequencesNumber of disk blocks read from this sequence pg_statio_all_sequences SELECT blks_read FROM pg_catalog.pg_statio_all_sequences; View pg_statio_all_sequences Field blks_read SQL type bigint … pg_statio_all_sequences.relidStatistics & MetricsWikiStatistics & Metrics · pg_statio_all_sequencesOID of a sequence pg_statio_all_sequences SELECT relid FROM pg_catalog.pg_statio_all_sequences; View pg_statio_all_sequences Field relid SQL type oid Units named in the field definition Not… pg_statio_all_sequences.relnameStatistics & MetricsWikiStatistics & Metrics · pg_statio_all_sequencesName of this sequence pg_statio_all_sequences SELECT relname FROM pg_catalog.pg_statio_all_sequences; View pg_statio_all_sequences Field relname SQL type name Units named in the field defin… pg_statio_all_sequences.schemanameStatistics & MetricsWikiStatistics & Metrics · pg_statio_all_sequencesName of the schema this sequence is in pg_statio_all_sequences SELECT schemaname FROM pg_catalog.pg_statio_all_sequences; View pg_statio_all_sequences Field schemaname SQL type name Units n… pg_statio_all_sequences.stats_resetStatistics & MetricsWikiStatistics & Metrics · pg_statio_all_sequencesTime at which these statistics were last reset pg_statio_all_sequences SELECT stats_reset FROM pg_catalog.pg_statio_all_sequences; View pg_statio_all_sequences Field stats_reset SQL type ti… pg_statio_all_tables.heap_blks_hitStatistics & MetricsWikiStatistics & Metrics · pg_statio_all_tablesNumber of buffer hits in this table pg_statio_all_tables SELECT heap_blks_hit FROM pg_catalog.pg_statio_all_tables; View pg_statio_all_tables Field heap_blks_hit SQL type bigint Units named… pg_statio_all_tables.heap_blks_readStatistics & MetricsWikiStatistics & Metrics · pg_statio_all_tablesNumber of disk blocks read from this table pg_statio_all_tables SELECT heap_blks_read FROM pg_catalog.pg_statio_all_tables; View pg_statio_all_tables Field heap_blks_read SQL type bigint Un… pg_statio_all_tables.idx_blks_hitStatistics & MetricsWikiStatistics & Metrics · pg_statio_all_tablesNumber of buffer hits in all indexes on this table pg_statio_all_tables SELECT idx_blks_hit FROM pg_catalog.pg_statio_all_tables; View pg_statio_all_tables Field idx_blks_hit SQL type bigin… pg_statio_all_tables.idx_blks_readStatistics & MetricsWikiStatistics & Metrics · pg_statio_all_tablesNumber of disk blocks read from all indexes on this table pg_statio_all_tables SELECT idx_blks_read FROM pg_catalog.pg_statio_all_tables; View pg_statio_all_tables Field idx_blks_read SQL t… pg_statio_all_tables.relidStatistics & MetricsWikiStatistics & Metrics · pg_statio_all_tablesOID of a table pg_statio_all_tables SELECT relid FROM pg_catalog.pg_statio_all_tables; View pg_statio_all_tables Field relid SQL type oid Units named in the field definition Not specified R… pg_statio_all_tables.relnameStatistics & MetricsWikiStatistics & Metrics · pg_statio_all_tablesName of this table pg_statio_all_tables SELECT relname FROM pg_catalog.pg_statio_all_tables; View pg_statio_all_tables Field relname SQL type name Units named in the field definition Not sp… pg_statio_all_tables.schemanameStatistics & MetricsWikiStatistics & Metrics · pg_statio_all_tablesName of the schema that this table is in pg_statio_all_tables SELECT schemaname FROM pg_catalog.pg_statio_all_tables; View pg_statio_all_tables Field schemaname SQL type name Units named in… pg_statio_all_tables.stats_resetStatistics & MetricsWikiStatistics & Metrics · pg_statio_all_tablesTime at which these statistics were last reset pg_statio_all_tables SELECT stats_reset FROM pg_catalog.pg_statio_all_tables; View pg_statio_all_tables Field stats_reset SQL type timestamp w…