Skip to content

Instantly share code, notes, and snippets.

@endenis

endenis/postgresql_invalid_indexes.sql

Created August 6, 2019 10:16
Show Gist options
  • Save endenis/1e8372f878c7f8979a13ac80faa616e1 to your computer and use it in GitHub Desktop.
Save endenis/1e8372f878c7f8979a13ac80faa616e1 to your computer and use it in GitHub Desktop.
Download ZIP
postgresql display invalid indexes
Raw
postgresql_invalid_indexes.sql
SELECT * FROM pg_class, pg_index WHERE pg_index.indisvalid = false AND pg_index.indexrelid = pg_class.oid;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment