postgres_pg_stat_tables.10.3(1) — Linux manual page

#version psql (PostgreSQL) 10.3 #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_activity backend_start 010 pg_stat_activity xact_start
011 pg_stat_activity query_start 012 pg_stat_activity
state_change 013 pg_stat_activity wait_event_type 014
pg_stat_activity wait_event 015 pg_stat_activity state 016
pg_stat_activity backend_xid 017 pg_stat_activity backend_xmin
018 pg_stat_activity query 019 pg_stat_activity backend_type
#table pg_stat_bgwriter 000 pg_stat_bgwriter checkpoints_timed
001 pg_stat_bgwriter checkpoints_req 002 pg_stat_bgwriter
checkpoint_write_time 003 pg_stat_bgwriter checkpoint_sync_time
004 pg_stat_bgwriter buffers_checkpoint 005 pg_stat_bgwriter
buffers_clean 006 pg_stat_bgwriter maxwritten_clean 007
pg_stat_bgwriter buffers_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_updated 011 pg_stat_database tup_deleted
012 pg_stat_database conflicts 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_database_conflicts 000 pg_stat_database_conflicts datid
001 pg_stat_database_conflicts datname 002
pg_stat_database_conflicts confl_tablespace 003
pg_stat_database_conflicts confl_lock 004
pg_stat_database_conflicts confl_snapshot 005
pg_stat_database_conflicts confl_bufferpin 006
pg_stat_database_conflicts confl_deadlock #table
pg_stat_replication 000 pg_stat_replication pid 001
pg_stat_replication usesysid 002 pg_stat_replication usename 003
pg_stat_replication application_name 004 pg_stat_replication
client_addr 005 pg_stat_replication client_hostname 006
pg_stat_replication client_port 007 pg_stat_replication
backend_start 008 pg_stat_replication backend_xmin 009
pg_stat_replication state 010 pg_stat_replication sent_lsn 011
pg_stat_replication write_lsn 012 pg_stat_replication flush_lsn
013 pg_stat_replication replay_lsn 014 pg_stat_replication
write_lag 015 pg_stat_replication flush_lag 016
pg_stat_replication replay_lag 017 pg_stat_replication
sync_priority 018 pg_stat_replication sync_state #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_autoanalyze 018 pg_stat_all_tables vacuum_count 019
pg_stat_all_tables 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_tables 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_autovacuum 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
analyze_count 021 pg_stat_sys_tables autoanalyze_count #table
pg_stat_user_tables 000 pg_stat_user_tables relid 001
pg_stat_user_tables schemaname 002 pg_stat_user_tables relname
003 pg_stat_user_tables seq_scan 004 pg_stat_user_tables
seq_tup_read 005 pg_stat_user_tables idx_scan 006
pg_stat_user_tables idx_tup_fetch 007 pg_stat_user_tables
n_tup_ins 008 pg_stat_user_tables n_tup_upd 009
pg_stat_user_tables n_tup_del 010 pg_stat_user_tables
n_tup_hot_upd 011 pg_stat_user_tables n_live_tup 012
pg_stat_user_tables n_dead_tup 013 pg_stat_user_tables
n_mod_since_analyze 014 pg_stat_user_tables last_vacuum 015
pg_stat_user_tables last_autovacuum 016 pg_stat_user_tables
last_analyze 017 pg_stat_user_tables last_autoanalyze 018
pg_stat_user_tables vacuum_count 019 pg_stat_user_tables
autovacuum_count 020 pg_stat_user_tables analyze_count 021
pg_stat_user_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 indexrelname 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 indexrelname 005
pg_stat_sys_indexes idx_scan 006 pg_stat_sys_indexes idx_tup_read
007 pg_stat_sys_indexes idx_tup_fetch #table pg_stat_user_indexes
000 pg_stat_user_indexes relid 001 pg_stat_user_indexes
indexrelid 002 pg_stat_user_indexes schemaname 003
pg_stat_user_indexes relname 004 pg_stat_user_indexes
indexrelname 005 pg_stat_user_indexes idx_scan 006
pg_stat_user_indexes idx_tup_read 007 pg_stat_user_indexes
idx_tup_fetch #table pg_statio_all_tables 000
pg_statio_all_tables relid 001 pg_statio_all_tables schemaname
002 pg_statio_all_tables relname 003 pg_statio_all_tables
heap_blks_read 004 pg_statio_all_tables heap_blks_hit 005
pg_statio_all_tables idx_blks_read 006 pg_statio_all_tables
idx_blks_hit 007 pg_statio_all_tables toast_blks_read 008
pg_statio_all_tables toast_blks_hit 009 pg_statio_all_tables
tidx_blks_read 010 pg_statio_all_tables tidx_blks_hit #table
pg_statio_sys_tables 000 pg_statio_sys_tables relid 001
pg_statio_sys_tables schemaname 002 pg_statio_sys_tables relname
003 pg_statio_sys_tables heap_blks_read 004 pg_statio_sys_tables
heap_blks_hit 005 pg_statio_sys_tables idx_blks_read 006
pg_statio_sys_tables idx_blks_hit 007 pg_statio_sys_tables
toast_blks_read 008 pg_statio_sys_tables toast_blks_hit 009
pg_statio_sys_tables tidx_blks_read 010 pg_statio_sys_tables
tidx_blks_hit #table pg_statio_user_tables 000
pg_statio_user_tables relid 001 pg_statio_user_tables schemaname
002 pg_statio_user_tables relname 003 pg_statio_user_tables
heap_blks_read 004 pg_statio_user_tables heap_blks_hit 005
pg_statio_user_tables idx_blks_read 006 pg_statio_user_tables
idx_blks_hit 007 pg_statio_user_tables toast_blks_read 008
pg_statio_user_tables toast_blks_hit 009 pg_statio_user_tables
tidx_blks_read 010 pg_statio_user_tables tidx_blks_hit #table
pg_statio_all_indexes 000 pg_statio_all_indexes relid 001
pg_statio_all_indexes indexrelid 002 pg_statio_all_indexes
schemaname 003 pg_statio_all_indexes relname 004
pg_statio_all_indexes indexrelname 005 pg_statio_all_indexes
idx_blks_read 006 pg_statio_all_indexes idx_blks_hit #table
pg_statio_sys_indexes 000 pg_statio_sys_indexes relid 001
pg_statio_sys_indexes indexrelid 002 pg_statio_sys_indexes
schemaname 003 pg_statio_sys_indexes relname 004
pg_statio_sys_indexes indexrelname 005 pg_statio_sys_indexes
idx_blks_read 006 pg_statio_sys_indexes idx_blks_hit #table
pg_statio_user_indexes 000 pg_statio_user_indexes relid 001
pg_statio_user_indexes indexrelid 002 pg_statio_user_indexes
schemaname 003 pg_statio_user_indexes relname 004
pg_statio_user_indexes indexrelname 005 pg_statio_user_indexes
idx_blks_read 006 pg_statio_user_indexes idx_blks_hit #table
pg_statio_all_sequences 000 pg_statio_all_sequences relid 001
pg_statio_all_sequences schemaname 002 pg_statio_all_sequences
relname 003 pg_statio_all_sequences blks_read 004
pg_statio_all_sequences blks_hit #table pg_statio_sys_sequences
000 pg_statio_sys_sequences relid 001 pg_statio_sys_sequences
schemaname 002 pg_statio_sys_sequences relname 003
pg_statio_sys_sequences blks_read 004 pg_statio_sys_sequences
blks_hit #table pg_statio_user_sequences 000
pg_statio_user_sequences relid 001 pg_statio_user_sequences
schemaname 002 pg_statio_user_sequences relname 003
pg_statio_user_sequences blks_read 004 pg_statio_user_sequences
blks_hit #table pg_stat_user_functions 000 pg_stat_user_functions
funcid 001 pg_stat_user_functions schemaname 002
pg_stat_user_functions funcname 003 pg_stat_user_functions calls
004 pg_stat_user_functions total_time 005 pg_stat_user_functions
self_time #table pg_stat_xact_user_functions 000
pg_stat_xact_user_functions funcid 001
pg_stat_xact_user_functions schemaname 002
pg_stat_xact_user_functions funcname 003
pg_stat_xact_user_functions calls 004 pg_stat_xact_user_functions
total_time 005 pg_stat_xact_user_functions self_time #table
pg_stat_xact_all_tables 000 pg_stat_xact_all_tables relid 001
pg_stat_xact_all_tables schemaname 002 pg_stat_xact_all_tables
relname 003 pg_stat_xact_all_tables seq_scan 004
pg_stat_xact_all_tables seq_tup_read 005 pg_stat_xact_all_tables
idx_scan 006 pg_stat_xact_all_tables idx_tup_fetch 007
pg_stat_xact_all_tables n_tup_ins 008 pg_stat_xact_all_tables
n_tup_upd 009 pg_stat_xact_all_tables n_tup_del 010
pg_stat_xact_all_tables n_tup_hot_upd #table
pg_stat_xact_sys_tables 000 pg_stat_xact_sys_tables relid 001
pg_stat_xact_sys_tables schemaname 002 pg_stat_xact_sys_tables
relname 003 pg_stat_xact_sys_tables seq_scan 004
pg_stat_xact_sys_tables seq_tup_read 005 pg_stat_xact_sys_tables
idx_scan 006 pg_stat_xact_sys_tables idx_tup_fetch 007
pg_stat_xact_sys_tables n_tup_ins 008 pg_stat_xact_sys_tables
n_tup_upd 009 pg_stat_xact_sys_tables n_tup_del 010
pg_stat_xact_sys_tables n_tup_hot_upd #table pg_active #table
pg_stat_xact_user_tables 000 pg_stat_xact_user_tables relid 001
pg_stat_xact_user_tables schemaname 002 pg_stat_xact_user_tables
relname 003 pg_stat_xact_user_tables seq_scan 004
pg_stat_xact_user_tables seq_tup_read 005
pg_stat_xact_user_tables idx_scan 006 pg_stat_xact_user_tables
idx_tup_fetch 007 pg_stat_xact_user_tables n_tup_ins 008
pg_stat_xact_user_tables n_tup_upd 009 pg_stat_xact_user_tables
n_tup_del 010 pg_stat_xact_user_tables n_tup_hot_upd