Timeline for Why index scan can be slow in Postgres?
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 18, 2023 at 2:14 | vote | accept | Nikita Glukhov | ||
| Dec 16, 2023 at 13:51 | comment | added | jjanes | "If I multiply actual total time by loops counter to get actual time I get near 40 sec, when the query completes within 7 sec." You have 8 parallel processes. It only takes 5 seconds of clock time for them to spend 40 seconds doing something. | |
| Dec 16, 2023 at 13:45 | comment | added | jjanes | Having random_page_cost set to lower than seq_page_cost is totally insane. Of course it will lead to demented plans. | |
| Dec 16, 2023 at 10:10 | answer | added | Laurenz Albe | timeline score: 3 | |
| Dec 16, 2023 at 8:58 | comment | added | bobflux | Can you please show exact index definitions? Also post EXPLAIN ANALYZE for: SELECT DISTINCT shipment_id FROM shipment s WHERE s.store_sender_id = ANY(your big list) | |
| Dec 16, 2023 at 8:35 | comment | added | bobflux | Here's the more readable explain analyze on depesz | |
| Dec 16, 2023 at 1:19 | history | asked | Nikita Glukhov | CC BY-SA 4.0 |