When writing SQL isn't enough: debugging PostgreSQL in production

While writing efficient SQL queries is essential, it is not enough to operate a database at scale. I will illustrate this using 3 issues