Shane Borden shares some queries:
In the spirit of the holiday season, I thought I would write a quick post regarding some of my favorite queries that I use on a day to day basis working on Postgres. Some of these queries I have developed and others were found on the internet (hat tip to those who have previously posted) and further refined.
Click through for several useful queries, as well as a link to a GitHub repo that Shane maintains, containing plenty more.