3 ms·
You can also disable seq_scan and force pg to consider indexes, usually that's enough.
by why-el 6y ago
You can also disable seq_scan and force pg to consider indexes, usually that's enough.
- iracic 6y agoAccess method is just part of the story. Same index may be accessed in different ways, you might also want to combine them. Sometimes you may change table join order to see how it estimates (or executes). Usually there are two parts 1) cost and reasoning for some estimation 2) how it executes (timings, resource usage, locks/contention)