Why Does Your Query Take 8 Seconds? Getting to 8 Milliseconds With a Database Index
Was your app fast at first, then slower as data grew? Usually the culprit is a missing index. How database indexes work, how to diagnose with EXPLAIN and the most common mistakes, with PostgreSQL examples.
Read