explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hTx3

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=5,781.75..5,781.75 rows=1 width=258) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=5,781.75..5,781.75 rows=1 width=258) (actual rows= loops=)

  • Sort Key: ca.date_and_time_requested_for_contact__c
3. 0.000 0.000 ↓ 0.0

WindowAgg (cost=5,544.38..5,781.74 rows=1 width=258) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=5,544.38..5,781.71 rows=1 width=147) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=5,543.82..5,773.14 rows=1 width=117) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=5,543.26..5,764.56 rows=1 width=121) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=5,542.84..5,756.12 rows=1 width=115) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "case" ca (cost=5,542.56..5,747.81 rows=1 width=111) (actual rows= loops=)

  • Recheck Cond: (((accountid)::text = '001i000000kZfCVAA0'::text) AND ((recordtypeid)::text = '012i0000000DVbcAAG'::text) AND ((guest_card_status__c)::text = 'In Progress'::text) AND ((origin)::text = 'Web'::text))
  • Filter: (created_via_concierge__c AND (date_and_time_requested_for_contact__c IS NOT NULL) AND (date_and_time_requested_for_contact__c >= '2019-08-06 16:35:00'::timestamp without time zone) AND (date_and_time_req (...)
9. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=5,542.56..5,542.56 rows=51 width=0) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ah_idx_case_multicol (cost=0.00..926.68 rows=2,951 width=0) (actual rows= loops=)

  • Index Cond: (((accountid)::text = '001i000000kZfCVAA0'::text) AND ((recordtypeid)::text = '012i0000000DVbcAAG'::text) AND ((guest_card_status__c)::text = 'In Progress'::text))
11. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on hc_idx_case_origin (cost=0.00..4,615.63 rows=232,959 width=0) (actual rows= loops=)

  • Index Cond: ((origin)::text = 'Web'::text)
12. 0.000 0.000 ↓ 0.0

Index Scan using account_idx_sfid on account ac (cost=0.28..8.30 rows=1 width=42) (actual rows= loops=)

  • Index Cond: ((sfid)::text = '001i000000kZfCVAA0'::text)
13. 0.000 0.000 ↓ 0.0

Index Scan using property__c_idx_sfid on property__c pro (cost=0.42..8.44 rows=1 width=44) (actual rows= loops=)

  • Index Cond: ((sfid)::text = (ca.property_of_interest__c)::text)
14. 0.000 0.000 ↓ 0.0

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

  • Index Cond: ((sfid)::text = (ca.property_consultant__c)::text)
15. 0.000 0.000 ↓ 0.0

Index Scan using contact_idx_sfid on contact con (cost=0.56..8.58 rows=1 width=68) (actual rows= loops=)

  • Index Cond: ((sfid)::text = (ca.contactid)::text)