Skip to content

Instantly share code, notes, and snippets.

@drsnyder
Created August 21, 2013 16:19
Show Gist options
  • Save drsnyder/6296632 to your computer and use it in GitHub Desktop.
Save drsnyder/6296632 to your computer and use it in GitHub Desktop.
what tables are approaching the need for a freeze vacuum? below 70% should be safe
SELECT
freez::int,age(relfrozenxid) as txns,
ROUND(100*(age(relfrozenxid)::bigint/freez::float)) AS perc,
n.nspname as "schema"
, relname::text as "name"
FROM
pg_class c
LEFT JOIN pg_namespace n on n.oid = c.relnamespace
JOIN (SELECT setting AS freez FROM pg_settings WHERE name = 'autovacuum_freeze_max_age') AS foo
ON (true) WHERE relkind='r' order by perc ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment