Skip to content

Instantly share code, notes, and snippets.

@flebel

flebel/snippet.sql

Created December 24, 2018 14:24
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 flebel/fe3eae27b86b0da74c1fac24aacbc982 to your computer and use it in GitHub Desktop.
Save flebel/fe3eae27b86b0da74c1fac24aacbc982 to your computer and use it in GitHub Desktop.
Download ZIP
list last analyze and vacuum operations on a postgres db
Raw
snippet.sql
SELECT relname, last_vacuum, last_autovacuum, last_analyze, last_autoanalyze
FROM pg_stat_all_tables
WHERE schemaname = 'public';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment