↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Search PostgreSQL documentation

PG 18 · Browse by category, or enter a name or keyword

Category index616
pg_statio_user_sequences.relidStatistics & MetricsWikiStatistics & Metrics · pg_statio_user_sequencesOID of a sequence pg_statio_user_sequences SELECT relid FROM pg_catalog.pg_statio_user_sequences; View pg_statio_user_sequences Field relid SQL type oid Units named in the field definition … pg_statio_user_sequences.relnameStatistics & MetricsWikiStatistics & Metrics · pg_statio_user_sequencesName of this sequence pg_statio_user_sequences SELECT relname FROM pg_catalog.pg_statio_user_sequences; View pg_statio_user_sequences Field relname SQL type name Units named in the field de… pg_statio_user_sequences.schemanameStatistics & MetricsWikiStatistics & Metrics · pg_statio_user_sequencesName of the schema this sequence is in pg_statio_user_sequences SELECT schemaname FROM pg_catalog.pg_statio_user_sequences; View pg_statio_user_sequences Field schemaname SQL type name Unit… pg_statio_user_sequences.stats_resetStatistics & MetricsWikiStatistics & Metrics · pg_statio_user_sequencesTime at which these statistics were last reset pg_statio_user_sequences SELECT stats_reset FROM pg_catalog.pg_statio_user_sequences; View pg_statio_user_sequences Field stats_reset SQL type… pg_statio_user_tables.heap_blks_hitStatistics & MetricsWikiStatistics & Metrics · pg_statio_user_tablesNumber of buffer hits in this table pg_statio_user_tables SELECT heap_blks_hit FROM pg_catalog.pg_statio_user_tables; View pg_statio_user_tables Field heap_blks_hit SQL type bigint Units na… pg_statio_user_tables.heap_blks_readStatistics & MetricsWikiStatistics & Metrics · pg_statio_user_tablesNumber of disk blocks read from this table pg_statio_user_tables SELECT heap_blks_read FROM pg_catalog.pg_statio_user_tables; View pg_statio_user_tables Field heap_blks_read SQL type bigint… pg_statio_user_tables.idx_blks_hitStatistics & MetricsWikiStatistics & Metrics · pg_statio_user_tablesNumber of buffer hits in all indexes on this table pg_statio_user_tables SELECT idx_blks_hit FROM pg_catalog.pg_statio_user_tables; View pg_statio_user_tables Field idx_blks_hit SQL type bi… pg_statio_user_tables.idx_blks_readStatistics & MetricsWikiStatistics & Metrics · pg_statio_user_tablesNumber of disk blocks read from all indexes on this table pg_statio_user_tables SELECT idx_blks_read FROM pg_catalog.pg_statio_user_tables; View pg_statio_user_tables Field idx_blks_read SQ… pg_statio_user_tables.relidStatistics & MetricsWikiStatistics & Metrics · pg_statio_user_tablesOID of a table pg_statio_user_tables SELECT relid FROM pg_catalog.pg_statio_user_tables; View pg_statio_user_tables Field relid SQL type oid Units named in the field definition Not specifie… pg_statio_user_tables.relnameStatistics & MetricsWikiStatistics & Metrics · pg_statio_user_tablesName of this table pg_statio_user_tables SELECT relname FROM pg_catalog.pg_statio_user_tables; View pg_statio_user_tables Field relname SQL type name Units named in the field definition Not… pg_statio_user_tables.schemanameStatistics & MetricsWikiStatistics & Metrics · pg_statio_user_tablesName of the schema that this table is in pg_statio_user_tables SELECT schemaname FROM pg_catalog.pg_statio_user_tables; View pg_statio_user_tables Field schemaname SQL type name Units named… pg_statio_user_tables.stats_resetStatistics & MetricsWikiStatistics & Metrics · pg_statio_user_tablesTime at which these statistics were last reset pg_statio_user_tables SELECT stats_reset FROM pg_catalog.pg_statio_user_tables; View pg_statio_user_tables Field stats_reset SQL type timestam… pg_statio_user_tables.tidx_blks_hitStatistics & MetricsWikiStatistics & Metrics · pg_statio_user_tablesNumber of buffer hits in this table's TOAST table indexes (if any) pg_statio_user_tables SELECT tidx_blks_hit FROM pg_catalog.pg_statio_user_tables; View pg_statio_user_tables Field tidx_bl… pg_statio_user_tables.tidx_blks_readStatistics & MetricsWikiStatistics & Metrics · pg_statio_user_tablesNumber of disk blocks read from this table's TOAST table indexes (if any) pg_statio_user_tables SELECT tidx_blks_read FROM pg_catalog.pg_statio_user_tables; View pg_statio_user_tables Field… pg_statio_user_tables.toast_blks_hitStatistics & MetricsWikiStatistics & Metrics · pg_statio_user_tablesNumber of buffer hits in this table's TOAST table (if any) pg_statio_user_tables SELECT toast_blks_hit FROM pg_catalog.pg_statio_user_tables; View pg_statio_user_tables Field toast_blks_hit… pg_statio_user_tables.toast_blks_readStatistics & MetricsWikiStatistics & Metrics · pg_statio_user_tablesNumber of disk blocks read from this table's TOAST table (if any) pg_statio_user_tables SELECT toast_blks_read FROM pg_catalog.pg_statio_user_tables; View pg_statio_user_tables Field toast_…

Find definitions in the PostgreSQL manuals, reference library, and extension catalogue.

Searching every version by default. Manual pages are indexed for PostgreSQL 10–20; the reference library and extension catalogue are not version-bound.

all: every version pg17: one version ex: extensions only ↑↓ select ↵ open