explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lCmk

Settings
# exclusive inclusive rows x rows loops node
1. 1.058 36.712 ↑ 1.0 20 1

Limit (cost=10,498.22..10,498.27 rows=20 width=645) (actual time=35.654..36.712 rows=20 loops=1)

2. 0.067 35.654 ↑ 3.9 20 1

Sort (cost=10,498.22..10,498.41 rows=77 width=645) (actual time=35.652..35.654 rows=20 loops=1)

  • Sort Key: qa.qa_form_created_date__c DESC, qa.id DESC
  • Sort Method: top-N heapsort Memory: 41kB
3. 0.000 35.587 ↑ 1.8 44 1

WindowAgg (cost=1,892.71..10,496.17 rows=77 width=645) (actual time=35.350..35.587 rows=44 loops=1)

4. 31.454 36.271 ↑ 1.8 44 1

Gather (cost=1,892.71..10,492.51 rows=77 width=360) (actual time=20.776..36.271 rows=44 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 0.116 4.817 ↑ 2.1 15 3

Nested Loop Left Join (cost=892.71..9,484.81 rows=32 width=360) (actual time=2.512..4.817 rows=15 loops=3)

6. 0.315 4.695 ↑ 2.1 15 3

Nested Loop Left Join (cost=892.28..9,214.49 rows=32 width=309) (actual time=2.510..4.695 rows=15 loops=3)

7. 0.310 4.360 ↑ 2.1 15 3

Nested Loop Left Join (cost=891.72..8,940.01 rows=32 width=313) (actual time=2.501..4.360 rows=15 loops=3)

8. 0.313 4.029 ↑ 2.1 15 3

Nested Loop Left Join (cost=891.16..8,665.45 rows=32 width=317) (actual time=2.492..4.029 rows=15 loops=3)

9. 0.315 3.695 ↑ 2.1 15 3

Nested Loop Left Join (cost=890.60..8,390.88 rows=32 width=310) (actual time=2.480..3.695 rows=15 loops=3)

10. 0.162 3.358 ↑ 2.1 15 3

Nested Loop Left Join (cost=890.18..8,125.87 rows=32 width=304) (actual time=2.470..3.358 rows=15 loops=3)

11. 0.290 3.186 ↑ 2.1 15 3

Nested Loop Left Join (cost=889.90..7,881.96 rows=32 width=300) (actual time=2.463..3.186 rows=15 loops=3)

12. 0.000 2.880 ↑ 2.1 15 3

Parallel Bitmap Heap Scan on qa_form__c qa (cost=889.34..7,607.48 rows=32 width=242) (actual time=2.449..2.880 rows=15 loops=3)

  • Recheck Cond: ((qa_form_created_date__c >= '2019-04-15 16:37:27'::timestamp without time zone) AND (qa_form_created_date__c < '2019-05-15 16:37:27'::timestamp without time zone) AND ((shop (...)
  • Filter: ((NOT dismiss_from_qa__c) AND ((shop_category__c)::text = 'PoP'::text))
  • Rows Removed by Filter: 161
  • Heap Blocks: exact=286
13. 0.235 7.172 ↓ 0.0 0 1

BitmapAnd (cost=889.34..889.34 rows=3,963 width=0) (actual time=7.172..7.172 rows=0 loops=1)

14. 1.684 1.684 ↑ 1.0 8,355 1

Bitmap Index Scan on hc_idx_qa_form__c_qa_form_created_date__c (cost=0.00..179.93 rows=8,364 width=0) (actual time=1.684..1.684 rows=8,355 loops=1)

  • Index Cond: ((qa_form_created_date__c >= '2019-04-15 16:37:27'::timestamp without time zone) AND (qa_form_created_date__c < '2019-05-15 16:37:27'::timestamp without time zone))
15. 5.253 5.253 ↓ 1.0 32,299 1

Bitmap Index Scan on hc_idx_qa_form__c_shop_status__c (cost=0.00..709.12 rows=32,038 width=0) (actual time=5.253..5.253 rows=32,299 loops=1)

  • Index Cond: ((shop_status__c)::text = ANY ('{"In Progress",Completed}'::text[]))
16. 0.016 0.016 ↑ 1.0 1 44

Index Scan using hcu_idx_case_sfid on "case" c (cost=0.56..8.58 rows=1 width=58) (actual time=0.016..0.016 rows=1 loops=44)

  • Index Cond: ((qa.case__c)::text = (sfid)::text)
17. 0.010 0.010 ↑ 1.0 1 44

Index Scan using account_idx_sfid on account acc (cost=0.28..7.62 rows=1 width=42) (actual time=0.010..0.010 rows=1 loops=44)

  • Index Cond: ((qa.case_account__c)::text = (sfid)::text)
18. 0.022 0.022 ↑ 1.0 1 44

Index Scan using property__c_idx_sfid on property__c pr (cost=0.42..8.28 rows=1 width=44) (actual time=0.022..0.022 rows=1 loops=44)

  • Index Cond: ((qa.case_property__c)::text = (sfid)::text)
19. 0.021 0.021 ↑ 1.0 1 44

Index Scan using contact_idx_sfid on contact cq (cost=0.56..8.58 rows=1 width=26) (actual time=0.021..0.021 rows=1 loops=44)

  • Index Cond: ((qa.qa_reviewer__c)::text = (sfid)::text)
  • Filter: ((recordtypeid)::text = '0120H000001O7IWQA0'::text)
20. 0.021 0.021 ↑ 1.0 1 44

Index Scan using contact_idx_sfid on contact co (cost=0.56..8.58 rows=1 width=34) (actual time=0.021..0.021 rows=1 loops=44)

  • Index Cond: ((qa.pop_user__c)::text = (sfid)::text)
  • Filter: ((recordtypeid)::text = '0120H000001O7IWQA0'::text)
21. 0.020 0.020 ↑ 1.0 1 44

Index Scan using contact_idx_sfid on contact cp (cost=0.56..8.58 rows=1 width=34) (actual time=0.020..0.020 rows=1 loops=44)

  • Index Cond: ((qa.property_consultant__c)::text = (sfid)::text)
22. 0.006 0.006 ↓ 0.0 0 44

Index Scan using service_request1__c_idx_sfid on service_request1__c sr (cost=0.43..8.45 rows=1 width=51) (actual time=0.006..0.006 rows=0 loops=44)

  • Index Cond: ((qa.service_request_pop__c)::text = (sfid)::text)