Skip to content

Instantly share code, notes, and snippets.

@pmargreff

pmargreff/postgres.sql

Last active November 22, 2018 18:41
Show Gist options
  • Save pmargreff/2fcc320596b152b88528d13ebceb80cd to your computer and use it in GitHub Desktop.
Save pmargreff/2fcc320596b152b88528d13ebceb80cd to your computer and use it in GitHub Desktop.
Download ZIP
postgres utils
Raw
postgres.sql
# list last vacuum e autovacuum time on each table
SELECT relname, last_vacuum, last_autovacuum FROM pg_stat_user_tables;
# Tools
# Explain explained
# https://explain.depesz.com/
# Articles
# How analyze works:
# https://www.depesz.com/2013/04/16/explaining-the-unexplainable/
# https://www.depesz.com/2013/04/27/explaining-the-unexplainable-part-2/
# https://www.depesz.com/2013/05/09/explaining-the-unexplainable-part-3/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment