postgres_pg_stat_tables.9.5(4) — Linux manual page
#version psql (PostgreSQL) 9.5.4 #table pg_stat_all_tables 000
pg_stat_all_tables relid 001 pg_stat_all_tables schemaname 002
pg_stat_all_tables relname 003 pg_stat_all_tables seq_scan 004
pg_stat_all_tables seq_tup_read 005 pg_stat_all_tables idx_scan
006 pg_stat_all_tables idx_tup_fetch 007 pg_stat_all_tables
n_tup_ins 008 pg_stat_all_tables n_tup_upd 009 pg_stat_all_tables
n_tup_del 010 pg_stat_all_tables n_tup_hot_upd 011
pg_stat_all_tables n_live_tup 012 pg_stat_all_tables n_dead_tup
013 pg_stat_all_tables n_mod_since_analyze 014 pg_stat_all_tables
last_vacuum 015 pg_stat_all_tables last_autovacuum 016
pg_stat_all_tables last_analyze 017 pg_stat_all_tables last_auto‐
analyze 018 pg_stat_all_tables vacuum_count 019 pg_stat_all_ta‐
bles autovacuum_count 020 pg_stat_all_tables analyze_count 021
pg_stat_all_tables autoanalyze_count #table pg_stat_activity 000
pg_stat_activity datid 001 pg_stat_activity datname 002
pg_stat_activity pid 003 pg_stat_activity usesysid 004
pg_stat_activity usename 005 pg_stat_activity application_name
006 pg_stat_activity client_addr 007 pg_stat_activity
client_hostname 008 pg_stat_activity client_port 009 pg_stat_ac‐
tivity backend_start 010 pg_stat_activity xact_start 011
pg_stat_activity query_start 012 pg_stat_activity state_change
013 pg_stat_activity waiting 014 pg_stat_activity state 015
pg_stat_activity backend_xid 016 pg_stat_activity backend_xmin
017 pg_stat_activity query #table pg_stat_bgwriter 000
pg_stat_bgwriter checkpoints_timed 001 pg_stat_bgwriter check‐
points_req 002 pg_stat_bgwriter checkpoint_write_time 003
pg_stat_bgwriter checkpoint_sync_time 004 pg_stat_bgwriter buf‐
fers_checkpoint 005 pg_stat_bgwriter buffers_clean 006
pg_stat_bgwriter maxwritten_clean 007 pg_stat_bgwriter buf‐
fers_backend 008 pg_stat_bgwriter buffers_backend_fsync 009
pg_stat_bgwriter buffers_alloc 010 pg_stat_bgwriter stats_reset
#table pg_stat_database 000 pg_stat_database datid 001
pg_stat_database datname 002 pg_stat_database numbackends 003
pg_stat_database xact_commit 004 pg_stat_database xact_rollback
005 pg_stat_database blks_read 006 pg_stat_database blks_hit 007
pg_stat_database tup_returned 008 pg_stat_database tup_fetched
009 pg_stat_database tup_inserted 010 pg_stat_database tup_updat‐
ed 011 pg_stat_database tup_deleted 012 pg_stat_database con‐
flicts 013 pg_stat_database temp_files 014 pg_stat_database
temp_bytes 015 pg_stat_database deadlocks 016 pg_stat_database
blk_read_time 017 pg_stat_database blk_write_time 018
pg_stat_database stats_reset #table pg_stat_all_tables 000
pg_stat_all_tables relid 001 pg_stat_all_tables schemaname 002
pg_stat_all_tables relname 003 pg_stat_all_tables seq_scan 004
pg_stat_all_tables seq_tup_read 005 pg_stat_all_tables idx_scan
006 pg_stat_all_tables idx_tup_fetch 007 pg_stat_all_tables
n_tup_ins 008 pg_stat_all_tables n_tup_upd 009 pg_stat_all_tables
n_tup_del 010 pg_stat_all_tables n_tup_hot_upd 011
pg_stat_all_tables n_live_tup 012 pg_stat_all_tables n_dead_tup
013 pg_stat_all_tables n_mod_since_analyze 014 pg_stat_all_tables
last_vacuum 015 pg_stat_all_tables last_autovacuum 016
pg_stat_all_tables last_analyze 017 pg_stat_all_tables last_auto‐
analyze 018 pg_stat_all_tables vacuum_count 019 pg_stat_all_ta‐
bles autovacuum_count 020 pg_stat_all_tables analyze_count 021
pg_stat_all_tables autoanalyze_count #table pg_stat_sys_tables
000 pg_stat_sys_tables relid 001 pg_stat_sys_tables schemaname
002 pg_stat_sys_tables relname 003 pg_stat_sys_tables seq_scan
004 pg_stat_sys_tables seq_tup_read 005 pg_stat_sys_tables
idx_scan 006 pg_stat_sys_tables idx_tup_fetch 007 pg_stat_sys_ta‐
bles n_tup_ins 008 pg_stat_sys_tables n_tup_upd 009
pg_stat_sys_tables n_tup_del 010 pg_stat_sys_tables n_tup_hot_upd
011 pg_stat_sys_tables n_live_tup 012 pg_stat_sys_tables
n_dead_tup 013 pg_stat_sys_tables n_mod_since_analyze 014
pg_stat_sys_tables last_vacuum 015 pg_stat_sys_tables last_auto‐
vacuum 016 pg_stat_sys_tables last_analyze 017 pg_stat_sys_tables
last_autoanalyze 018 pg_stat_sys_tables vacuum_count 019
pg_stat_sys_tables autovacuum_count 020 pg_stat_sys_tables ana‐
lyze_count 021 pg_stat_sys_tables autoanalyze_count #table
pg_stat_all_indexes 000 pg_stat_all_indexes relid 001
pg_stat_all_indexes indexrelid 002 pg_stat_all_indexes schemaname
003 pg_stat_all_indexes relname 004 pg_stat_all_indexes indexrel‐
name 005 pg_stat_all_indexes idx_scan 006 pg_stat_all_indexes
idx_tup_read 007 pg_stat_all_indexes idx_tup_fetch #table
pg_stat_sys_indexes 000 pg_stat_sys_indexes relid 001
pg_stat_sys_indexes indexrelid 002 pg_stat_sys_indexes schemaname
003 pg_stat_sys_indexes relname 004 pg_stat_sys_indexes indexrel‐
name 005 pg_stat_sys_indexes idx_scan 006 pg_stat_sys_indexes
idx_tup_read 007 pg_stat_sys_indexes idx_tup_fetch