The Postgres Performance Tuning Manual: Indexes
https://blog.gojekengineering.com/the-postgres-performance-tuning-manual-indexes-19a1bdfe28ba
gojek.jobsIn a previous post, we discussed how we can use query plans to analyse the run time of queries. In case you missed it, you can read it here:
In this post, we look at how to overcome slow queries by analysing them with Explain and Analyze, and using indexes to modify and enhance the query timings.