Search PostgreSQL documentation

pg_statio_all_tables.tidx_blks_hitStatistics & MetricsWikiStatistics & Metrics · pg_statio_all_tablesNumber of buffer hits in this table's TOAST table indexes (if any) pg_statio_all_tables SELECT tidx_blks_hit FROM pg_catalog.pg_statio_all_tables; View pg_statio_all_tables Field tidx_blks_… pg_statio_all_tables.tidx_blks_readStatistics & MetricsWikiStatistics & Metrics · pg_statio_all_tablesNumber of disk blocks read from this table's TOAST table indexes (if any) pg_statio_all_tables SELECT tidx_blks_read FROM pg_catalog.pg_statio_all_tables; View pg_statio_all_tables Field ti… pg_statio_all_tables.toast_blks_hitStatistics & MetricsWikiStatistics & Metrics · pg_statio_all_tablesNumber of buffer hits in this table's TOAST table (if any) pg_statio_all_tables SELECT toast_blks_hit FROM pg_catalog.pg_statio_all_tables; View pg_statio_all_tables Field toast_blks_hit SQ… pg_statio_all_tables.toast_blks_readStatistics & MetricsWikiStatistics & Metrics · pg_statio_all_tablesNumber of disk blocks read from this table's TOAST table (if any) pg_statio_all_tables SELECT toast_blks_read FROM pg_catalog.pg_statio_all_tables; View pg_statio_all_tables Field toast_blk… pg_statio_sys_indexes.idx_blks_hitStatistics & MetricsWikiStatistics & Metrics · pg_statio_sys_indexesNumber of buffer hits in this index pg_statio_sys_indexes SELECT idx_blks_hit FROM pg_catalog.pg_statio_sys_indexes; View pg_statio_sys_indexes Field idx_blks_hit SQL type bigint Units name… pg_statio_sys_indexes.idx_blks_readStatistics & MetricsWikiStatistics & Metrics · pg_statio_sys_indexesNumber of disk blocks read from this index pg_statio_sys_indexes SELECT idx_blks_read FROM pg_catalog.pg_statio_sys_indexes; View pg_statio_sys_indexes Field idx_blks_read SQL type bigint U… pg_statio_sys_indexes.indexrelidStatistics & MetricsWikiStatistics & Metrics · pg_statio_sys_indexesOID of this index pg_statio_sys_indexes SELECT indexrelid FROM pg_catalog.pg_statio_sys_indexes; View pg_statio_sys_indexes Field indexrelid SQL type oid Units named in the field definition… pg_statio_sys_indexes.indexrelnameStatistics & MetricsWikiStatistics & Metrics · pg_statio_sys_indexesName of this index pg_statio_sys_indexes SELECT indexrelname FROM pg_catalog.pg_statio_sys_indexes; View pg_statio_sys_indexes Field indexrelname SQL type name Units named in the field defi… pg_statio_sys_indexes.relidStatistics & MetricsWikiStatistics & Metrics · pg_statio_sys_indexesOID of the table for this index pg_statio_sys_indexes SELECT relid FROM pg_catalog.pg_statio_sys_indexes; View pg_statio_sys_indexes Field relid SQL type oid Units named in the field defini… pg_statio_sys_indexes.relnameStatistics & MetricsWikiStatistics & Metrics · pg_statio_sys_indexesName of the table for this index pg_statio_sys_indexes SELECT relname FROM pg_catalog.pg_statio_sys_indexes; View pg_statio_sys_indexes Field relname SQL type name Units named in the field … pg_statio_sys_indexes.schemanameStatistics & MetricsWikiStatistics & Metrics · pg_statio_sys_indexesName of the schema this index is in pg_statio_sys_indexes SELECT schemaname FROM pg_catalog.pg_statio_sys_indexes; View pg_statio_sys_indexes Field schemaname SQL type name Units named in t… pg_statio_sys_indexes.stats_resetStatistics & MetricsWikiStatistics & Metrics · pg_statio_sys_indexesTime at which these statistics were last reset pg_statio_sys_indexes SELECT stats_reset FROM pg_catalog.pg_statio_sys_indexes; View pg_statio_sys_indexes Field stats_reset SQL type timestam… pg_statio_sys_sequences.blks_hitStatistics & MetricsWikiStatistics & Metrics · pg_statio_sys_sequencesNumber of buffer hits in this sequence pg_statio_sys_sequences SELECT blks_hit FROM pg_catalog.pg_statio_sys_sequences; View pg_statio_sys_sequences Field blks_hit SQL type bigint Units nam… pg_statio_sys_sequences.blks_readStatistics & MetricsWikiStatistics & Metrics · pg_statio_sys_sequencesNumber of disk blocks read from this sequence pg_statio_sys_sequences SELECT blks_read FROM pg_catalog.pg_statio_sys_sequences; View pg_statio_sys_sequences Field blks_read SQL type bigint … pg_statio_sys_sequences.relidStatistics & MetricsWikiStatistics & Metrics · pg_statio_sys_sequencesOID of a sequence pg_statio_sys_sequences SELECT relid FROM pg_catalog.pg_statio_sys_sequences; View pg_statio_sys_sequences Field relid SQL type oid Units named in the field definition Not… pg_statio_sys_sequences.relnameStatistics & MetricsWikiStatistics & Metrics · pg_statio_sys_sequencesName of this sequence pg_statio_sys_sequences SELECT relname FROM pg_catalog.pg_statio_sys_sequences; View pg_statio_sys_sequences Field relname SQL type name Units named in the field defin… pg_statio_sys_sequences.schemanameStatistics & MetricsWikiStatistics & Metrics · pg_statio_sys_sequencesName of the schema this sequence is in pg_statio_sys_sequences SELECT schemaname FROM pg_catalog.pg_statio_sys_sequences; View pg_statio_sys_sequences Field schemaname SQL type name Units n… pg_statio_sys_sequences.stats_resetStatistics & MetricsWikiStatistics & Metrics · pg_statio_sys_sequencesTime at which these statistics were last reset pg_statio_sys_sequences SELECT stats_reset FROM pg_catalog.pg_statio_sys_sequences; View pg_statio_sys_sequences Field stats_reset SQL type ti… pg_statio_sys_tables.heap_blks_hitStatistics & MetricsWikiStatistics & Metrics · pg_statio_sys_tablesNumber of buffer hits in this table pg_statio_sys_tables SELECT heap_blks_hit FROM pg_catalog.pg_statio_sys_tables; View pg_statio_sys_tables Field heap_blks_hit SQL type bigint Units named… pg_statio_sys_tables.heap_blks_readStatistics & MetricsWikiStatistics & Metrics · pg_statio_sys_tablesNumber of disk blocks read from this table pg_statio_sys_tables SELECT heap_blks_read FROM pg_catalog.pg_statio_sys_tables; View pg_statio_sys_tables Field heap_blks_read SQL type bigint Un… pg_statio_sys_tables.idx_blks_hitStatistics & MetricsWikiStatistics & Metrics · pg_statio_sys_tablesNumber of buffer hits in all indexes on this table pg_statio_sys_tables SELECT idx_blks_hit FROM pg_catalog.pg_statio_sys_tables; View pg_statio_sys_tables Field idx_blks_hit SQL type bigin… pg_statio_sys_tables.idx_blks_readStatistics & MetricsWikiStatistics & Metrics · pg_statio_sys_tablesNumber of disk blocks read from all indexes on this table pg_statio_sys_tables SELECT idx_blks_read FROM pg_catalog.pg_statio_sys_tables; View pg_statio_sys_tables Field idx_blks_read SQL t… pg_statio_sys_tables.relidStatistics & MetricsWikiStatistics & Metrics · pg_statio_sys_tablesOID of a table pg_statio_sys_tables SELECT relid FROM pg_catalog.pg_statio_sys_tables; View pg_statio_sys_tables Field relid SQL type oid Units named in the field definition Not specified R… pg_statio_sys_tables.relnameStatistics & MetricsWikiStatistics & Metrics · pg_statio_sys_tablesName of this table pg_statio_sys_tables SELECT relname FROM pg_catalog.pg_statio_sys_tables; View pg_statio_sys_tables Field relname SQL type name Units named in the field definition Not sp… pg_statio_sys_tables.schemanameStatistics & MetricsWikiStatistics & Metrics · pg_statio_sys_tablesName of the schema that this table is in pg_statio_sys_tables SELECT schemaname FROM pg_catalog.pg_statio_sys_tables; View pg_statio_sys_tables Field schemaname SQL type name Units named in… pg_statio_sys_tables.stats_resetStatistics & MetricsWikiStatistics & Metrics · pg_statio_sys_tablesTime at which these statistics were last reset pg_statio_sys_tables SELECT stats_reset FROM pg_catalog.pg_statio_sys_tables; View pg_statio_sys_tables Field stats_reset SQL type timestamp w… pg_statio_sys_tables.tidx_blks_hitStatistics & MetricsWikiStatistics & Metrics · pg_statio_sys_tablesNumber of buffer hits in this table's TOAST table indexes (if any) pg_statio_sys_tables SELECT tidx_blks_hit FROM pg_catalog.pg_statio_sys_tables; View pg_statio_sys_tables Field tidx_blks_… pg_statio_sys_tables.tidx_blks_readStatistics & MetricsWikiStatistics & Metrics · pg_statio_sys_tablesNumber of disk blocks read from this table's TOAST table indexes (if any) pg_statio_sys_tables SELECT tidx_blks_read FROM pg_catalog.pg_statio_sys_tables; View pg_statio_sys_tables Field ti… pg_statio_sys_tables.toast_blks_hitStatistics & MetricsWikiStatistics & Metrics · pg_statio_sys_tablesNumber of buffer hits in this table's TOAST table (if any) pg_statio_sys_tables SELECT toast_blks_hit FROM pg_catalog.pg_statio_sys_tables; View pg_statio_sys_tables Field toast_blks_hit SQ… pg_statio_sys_tables.toast_blks_readStatistics & MetricsWikiStatistics & Metrics · pg_statio_sys_tablesNumber of disk blocks read from this table's TOAST table (if any) pg_statio_sys_tables SELECT toast_blks_read FROM pg_catalog.pg_statio_sys_tables; View pg_statio_sys_tables Field toast_blk… pg_statio_user_indexes.idx_blks_hitStatistics & MetricsWikiStatistics & Metrics · pg_statio_user_indexesNumber of buffer hits in this index pg_statio_user_indexes SELECT idx_blks_hit FROM pg_catalog.pg_statio_user_indexes; View pg_statio_user_indexes Field idx_blks_hit SQL type bigint Units n… pg_statio_user_indexes.idx_blks_readStatistics & MetricsWikiStatistics & Metrics · pg_statio_user_indexesNumber of disk blocks read from this index pg_statio_user_indexes SELECT idx_blks_read FROM pg_catalog.pg_statio_user_indexes; View pg_statio_user_indexes Field idx_blks_read SQL type bigin… pg_statio_user_indexes.indexrelidStatistics & MetricsWikiStatistics & Metrics · pg_statio_user_indexesOID of this index pg_statio_user_indexes SELECT indexrelid FROM pg_catalog.pg_statio_user_indexes; View pg_statio_user_indexes Field indexrelid SQL type oid Units named in the field definit… pg_statio_user_indexes.indexrelnameStatistics & MetricsWikiStatistics & Metrics · pg_statio_user_indexesName of this index pg_statio_user_indexes SELECT indexrelname FROM pg_catalog.pg_statio_user_indexes; View pg_statio_user_indexes Field indexrelname SQL type name Units named in the field d… pg_statio_user_indexes.relidStatistics & MetricsWikiStatistics & Metrics · pg_statio_user_indexesOID of the table for this index pg_statio_user_indexes SELECT relid FROM pg_catalog.pg_statio_user_indexes; View pg_statio_user_indexes Field relid SQL type oid Units named in the field def… pg_statio_user_indexes.relnameStatistics & MetricsWikiStatistics & Metrics · pg_statio_user_indexesName of the table for this index pg_statio_user_indexes SELECT relname FROM pg_catalog.pg_statio_user_indexes; View pg_statio_user_indexes Field relname SQL type name Units named in the fie… pg_statio_user_indexes.schemanameStatistics & MetricsWikiStatistics & Metrics · pg_statio_user_indexesName of the schema this index is in pg_statio_user_indexes SELECT schemaname FROM pg_catalog.pg_statio_user_indexes; View pg_statio_user_indexes Field schemaname SQL type name Units named i… pg_statio_user_indexes.stats_resetStatistics & MetricsWikiStatistics & Metrics · pg_statio_user_indexesTime at which these statistics were last reset pg_statio_user_indexes SELECT stats_reset FROM pg_catalog.pg_statio_user_indexes; View pg_statio_user_indexes Field stats_reset SQL type times… pg_statio_user_sequences.blks_hitStatistics & MetricsWikiStatistics & Metrics · pg_statio_user_sequencesNumber of buffer hits in this sequence pg_statio_user_sequences SELECT blks_hit FROM pg_catalog.pg_statio_user_sequences; View pg_statio_user_sequences Field blks_hit SQL type bigint Units … pg_statio_user_sequences.blks_readStatistics & MetricsWikiStatistics & Metrics · pg_statio_user_sequencesNumber of disk blocks read from this sequence pg_statio_user_sequences SELECT blks_read FROM pg_catalog.pg_statio_user_sequences; View pg_statio_user_sequences Field blks_read SQL type bigi…