Skip to content

Instantly share code, notes, and snippets.

@dfcarpenter
Created July 10, 2019 18:12
Show Gist options
  • Save dfcarpenter/faf15ead9dbedbbcc0308fdfb9a7f2b5 to your computer and use it in GitHub Desktop.
Save dfcarpenter/faf15ead9dbedbbcc0308fdfb9a7f2b5 to your computer and use it in GitHub Desktop.
See if DDL causes a relation to be rewritten
SELECT
relname,
relfilenode
FROM pg_catalog.pg_class
WHERE relname in (
'<table>',
'<index>'
)
-- Order by oid for convenience if you're checking multiple relations.
ORDER BY oid;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment