Apps

• Postico client for mac
• pgcli - Postgres CLI with autocompletion and syntax highlighting
• pghero - Server and query performance dashboard

Tools

• PostgreSQL's explain analyze made readable

Tutorials and Guides

• PG Exercises

Articles

• Anything by Craig Kerstiens, Postgres guide by Craig
• Unique partial indexes used for a toggle button
• The FILTER clause
• Citus Data's blog is full of gold
• Hash rocket's postgresql section is golden
• Bones Moses

More as I find things…