explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eV0

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 2,988.346 ↓ 20.0 20 1

Limit (cost=3,381.16..3,381.17 rows=1 width=581) (actual time=2,988.340..2,988.346 rows=20 loops=1)

2. 0.365 2,988.339 ↓ 20.0 20 1

Sort (cost=3,381.16..3,381.17 rows=1 width=581) (actual time=2,988.338..2,988.339 rows=20 loops=1)

  • Sort Key: qa.qa_form_created_date__c DESC, qa.id DESC
  • Sort Method: top-N heapsort Memory: 45kB
3. 1.814 2,987.974 ↓ 440.0 440 1

WindowAgg (cost=1,522.32..3,381.15 rows=1 width=581) (actual time=2,986.931..2,987.974 rows=440 loops=1)

4. 0.174 2,986.160 ↓ 440.0 440 1

Nested Loop (cost=1,522.32..3,381.11 rows=1 width=329) (actual time=2,581.149..2,986.160 rows=440 loops=1)

  • Join Filter: ((qa.property_consultant__c)::text = (ip.contact__c)::text)
5. 0.320 2,972.786 ↓ 440.0 440 1

Nested Loop Left Join (cost=1,522.04..3,373.90 rows=1 width=367) (actual time=2,571.010..2,972.786 rows=440 loops=1)

  • Filter: (((ipq.employment_status__c)::text = 'Active'::text) OR ((COALESCE(ipq.employment_status__c, ''::character varying))::text = ''::text))
6. 0.714 2,972.026 ↓ 440.0 440 1

Nested Loop Left Join (cost=1,521.77..3,366.69 rows=1 width=386) (actual time=2,570.988..2,972.026 rows=440 loops=1)

7. 0.499 2,959.432 ↓ 440.0 440 1

Nested Loop Left Join (cost=1,521.34..3,358.34 rows=1 width=329) (actual time=2,570.975..2,959.432 rows=440 loops=1)

8. 0.474 2,949.693 ↓ 440.0 440 1

Nested Loop Left Join (cost=1,520.78..3,349.78 rows=1 width=303) (actual time=2,562.543..2,949.693 rows=440 loops=1)

9. 0.706 2,796.979 ↓ 440.0 440 1

Nested Loop (cost=1,520.36..3,341.72 rows=1 width=297) (actual time=2,562.503..2,796.979 rows=440 loops=1)

10. 0.982 2,768.553 ↓ 440.0 440 1

Nested Loop Left Join (cost=1,520.08..3,334.29 rows=1 width=293) (actual time=2,553.306..2,768.553 rows=440 loops=1)

11. 0.905 2,647.891 ↓ 440.0 440 1

Hash Join (cost=1,519.52..3,325.73 rows=1 width=227) (actual time=2,553.248..2,647.891 rows=440 loops=1)

  • Hash Cond: ((qa.property_consultant__c)::text = (cp.sfid)::text)
12. 103.723 106.452 ↑ 1.3 440 1

Bitmap Heap Scan on qa_form__c qa (cost=416.06..2,220.75 rows=580 width=193) (actual time=12.686..106.452 rows=440 loops=1)

  • Recheck Cond: (((shop_status__c)::text = ANY ('{Queued,"In Progress"}'::text[])) AND (qa_form_created_date__c >= '2019-04-10 17:27:13'::timestamp without time zone) AND (qa_form_created_da (...)
  • Heap Blocks: exact=85
13. 0.129 2.729 ↓ 0.0 0 1

BitmapAnd (cost=416.06..416.06 rows=580 width=0) (actual time=2.729..2.729 rows=0 loops=1)

14. 0.549 0.549 ↓ 1.0 2,330 1

Bitmap Index Scan on hc_idx_qa_form__c_shop_status__c (cost=0.00..58.25 rows=2,322 width=0) (actual time=0.549..0.549 rows=2,330 loops=1)

  • Index Cond: ((shop_status__c)::text = ANY ('{Queued,"In Progress"}'::text[]))
15. 2.051 2.051 ↑ 1.0 16,816 1

Bitmap Index Scan on hc_idx_qa_form__c_qa_form_created_date__c (cost=0.00..357.27 rows=16,898 width=0) (actual time=2.051..2.051 rows=16,816 loops=1)

  • Index Cond: ((qa_form_created_date__c >= '2019-04-10 17:27:13'::timestamp without time zone) AND (qa_form_created_date__c < '2019-05-10 17:27:13'::timestamp without time zone))
16. 2.550 2,540.534 ↑ 7.7 684 1

Hash (cost=1,037.44..1,037.44 rows=5,281 width=34) (actual time=2,540.534..2,540.534 rows=684 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 108kB
17. 2,537.984 2,537.984 ↑ 7.7 684 1

Index Scan using hc_idx_contact_recordtypeid on contact cp (cost=0.56..1,037.44 rows=5,281 width=34) (actual time=9.039..2,537.984 rows=684 loops=1)

  • Index Cond: ((recordtypeid)::text = '0120H000001O7IWQA0'::text)
18. 119.680 119.680 ↑ 1.0 1 440

Index Scan using hcu_idx_case_sfid on "case" c (cost=0.56..8.56 rows=1 width=66) (actual time=0.272..0.272 rows=1 loops=440)

  • Index Cond: ((qa.case__c)::text = (sfid)::text)
19. 27.720 27.720 ↑ 1.0 1 440

Index Scan using account_idx_sfid on account acc (cost=0.28..7.43 rows=1 width=42) (actual time=0.063..0.063 rows=1 loops=440)

  • Index Cond: ((sfid)::text = (qa.case_account__c)::text)
20. 152.240 152.240 ↑ 1.0 1 440

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

  • Index Cond: ((qa.case_property__c)::text = (sfid)::text)
21. 9.240 9.240 ↓ 0.0 0 440

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

  • Index Cond: ((qa.qa_reviewer__c)::text = (sfid)::text)
  • Filter: ((recordtypeid)::text = '0120H000001O7IWQA0'::text)
22. 11.880 11.880 ↓ 0.0 0 440

Index Scan using service_request1__c_idx_sfid on service_request1__c sr (cost=0.43..8.34 rows=1 width=57) (actual time=0.027..0.027 rows=0 loops=440)

  • Index Cond: ((qa.service_request_pop__c)::text = (sfid)::text)
23. 0.440 0.440 ↓ 0.0 0 440

Index Scan using hc_idx_internal_app_permissions__c_contact__c on internal_app_permissions__c ipq (cost=0.28..7.19 rows=1 width=26) (actual time=0.001..0.001 rows=0 loops=440)

  • Index Cond: ((contact__c)::text = (cq.sfid)::text)
24. 13.200 13.200 ↑ 1.0 1 440

Index Scan using hc_idx_internal_app_permissions__c_contact__c on internal_app_permissions__c ip (cost=0.28..7.20 rows=1 width=19) (actual time=0.029..0.030 rows=1 loops=440)

  • Index Cond: ((contact__c)::text = (cp.sfid)::text)
  • Filter: ((employment_status__c)::text = 'Active'::text)
Planning time : 61.578 ms
Execution time : 2,988.894 ms