| From: | Dave Cramer <davecramer(at)gmail(dot)com> |
|---|---|
| To: | pgsql-performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | why does this query not use a parallel query |
| Date: | 2018-03-02 16:29:29 |
| Message-ID: | CADK3HHKCxitL24RVc8YwBOdeE8c0oXzonw6jBeCi_TPwewShsg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Have a query:
explain analyze SELECT minion_id FROM mob_player_mob_118 WHERE player_id =
55351078;
QUERY PLAN
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
Index Only Scan using mob_player_mob_118_pkey on mob_player_mob_118
(cost=0.44..117887.06 rows=4623076 width=4) (actual time=0.062..3716.105
rows=4625123 loops=1)
Index Cond: (player_id = 55351078)
Heap Fetches: 1152408
Planning time: 0.241 ms
Execution time: 5272.171 ms
If I just get the count it will use a parallel query
explain analyze SELECT count(minion_id) FROM mob_player_mob_118 WHERE
player_id = 55351078;
Thanks
Dave Cramer
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2018-03-02 16:44:40 | Re: why does this query not use a parallel query |
| Previous Message | Pavel Stehule | 2018-03-02 14:32:36 | Re: Performance degrade in Planning Time to find appropriate Partial Index |