Post archive

Finding Missing Indexes That Django Wants (Postgres)

2009 November 18

On Monday at work, our sites started to slow to a crawl. We looked to diagnose the problem, and found that the database server had a load of 10, and was struggling to keep up with the morning rush of traffic. After EXPLAINing the slow queries from the slow query ...