Re: BUG #18588: Cannot force/let database use parallel execution in simple case.
Andrei Lepikhov <lepihov@gmail.com>
From: Andrei Lepikhov <lepihov@gmail.com>
To: pgsql-bugs@lists.postgresql.org
Date: 2024-08-22T17:00:37Z
Lists: pgsql-bugs
On 22/8/2024 14:58, PG Bug reporting form wrote: > Index Scan using negotiation_topic_archive_p005_employer_id_resume_id_idx > on negotiation_topic_archive_p005 this_ (cost=0.11..2501972.13 rows=505757 > width=8) (actual time=0.020..699.322 rows=510040 loops=1) > Index Cond: (employer_id = 816144) > Planning Time: 0.132 ms > Execution Time: 717.005 ms Can you disable IndexScan and Bitmapscan step-by-step and show explain analyze verbose with costs? -- regards, Andrei Lepikhov