Skip to content

Instantly share code, notes, and snippets.

@areguig

areguig/show_last_autovacuum.sql

Created March 23, 2017 13:57
Show Gist options
  • Save areguig/e05223704c9e1c14a84aaf7beb569f61 to your computer and use it in GitHub Desktop.
Save areguig/e05223704c9e1c14a84aaf7beb569f61 to your computer and use it in GitHub Desktop.
Download ZIP
show last autovacuum
Raw
show_last_autovacuum.sql
select relname,last_vacuum, last_autovacuum, last_analyze, last_autoanalyze
from pg_stat_user_tables;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment