Measure first: a field guide to profiling
Your guess about where the time goes is wrong. A profiler tells you in ten minutes.
Bengaluru
Priya Nair
Performance engineer. Opens the profiler before the editor.
Reading EXPLAIN ANALYZE like a story Paid
Each line is a step, the steps nest and the numbers say where the time went.
Postgres indexes: the five you actually need
B-tree, multi-column, partial, covering and expression indexes, and how to check that each one works.