Skip to content

Instantly share code, notes, and snippets.

@qdw

qdw/users_table_stats--after.txt

Created September 3, 2015 00:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save qdw/b4d0077af947767e14cd to your computer and use it in GitHub Desktop.
Save qdw/b4d0077af947767e14cd to your computer and use it in GitHub Desktop.
Download ZIP
Raw
users_table_stats--after.txt
ser_tracking_production=> select * from pg_stat_user_tables where relname = 'users';
-[ RECORD 1 ]-----+------------------------------
relid | 16489
schemaname | public
relname | users
seq_scan | 25
seq_tup_read | 1547981705
idx_scan | 1643649151
idx_tup_fetch | 2093475016
n_tup_ins | 84162208
n_tup_upd | 442163502
n_tup_del | 0
n_tup_hot_upd | 302389903
n_live_tup | 149679307
n_dead_tup | 31283647
last_vacuum |
last_autovacuum | 2015-08-30 00:11:57.35496+00
last_analyze |
last_autoanalyze | 2015-08-31 16:43:17.666061+00
vacuum_count | 0
autovacuum_count | 8
analyze_count | 0
autoanalyze_count | 41
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment