Skip to content

Instantly share code, notes, and snippets.

@kawakami-o3

kawakami-o3/live_dead.sql

Last active August 29, 2015 14:27
Show Gist options
  • Save kawakami-o3/5803dbc7bbcd4cd42252 to your computer and use it in GitHub Desktop.
Save kawakami-o3/5803dbc7bbcd4cd42252 to your computer and use it in GitHub Desktop.
Download ZIP
live and dead
Raw
live_dead.sql
select relname,n_live_tup,n_dead_tup,last_vacuum,last_autovacuum from pg_stat_all_tables order by n_dead_tup desc limit 20;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment