garethrees/indexes.sql

Last active February 16, 2020 17:34

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/garethrees/42ca8dd64182515d6aa90000463ebfe1.js"></script>
Save garethrees/42ca8dd64182515d6aa90000463ebfe1 to your computer and use it in GitHub Desktop.

Download ZIP

List all indexes in postgres database

Raw

indexes.sql

SELECT indexname FROM pg_indexes;

Author

garethrees commented Feb 16, 2020

Wow, didn't realise this was getting so much attention. I don't think I'd been getting emails about gists until this week – perhaps its a new GitHub thing. Anyway, fixed :)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment