Capncavedan/find.sql

Created March 27, 2018 16:06

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/Capncavedan/34cb8938ee1e2ec5e6cd0f7b02b51db5.js"></script>
Save Capncavedan/34cb8938ee1e2ec5e6cd0f7b02b51db5 to your computer and use it in GitHub Desktop.

Download ZIP

Find corrupt/invalid Postgresql indexes

Raw

	SELECT pg_class.relname
	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