explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9NZc

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 554.669 ↓ 2.0 2 1

Limit (cost=5,781.75..5,781.75 rows=1 width=258) (actual time=554.667..554.669 rows=2 loops=1)

2. 0.016 554.666 ↓ 2.0 2 1

Sort (cost=5,781.75..5,781.75 rows=1 width=258) (actual time=554.665..554.666 rows=2 loops=1)

  • Sort Key: ca.date_and_time_requested_for_contact__c
  • Sort Method: quicksort Memory: 25kB
3. 0.063 554.650 ↓ 2.0 2 1

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

4. 0.003 554.587 ↓ 2.0 2 1

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

5. 0.004 554.582 ↓ 2.0 2 1

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

6. 0.008 554.574 ↓ 2.0 2 1

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

7. 0.008 554.476 ↓ 2.0 2 1

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

8. 434.963 554.388 ↓ 2.0 2 1

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

  • 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))
  • Rows Removed by Index Recheck: 1525
  • 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 (...)
  • Rows Removed by Filter: 25
  • Heap Blocks: exact=1154
9. 0.906 119.425 ↓ 0.0 0 1

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

10. 75.302 75.302 ↓ 7.1 20,953 1

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

  • Index Cond: (((accountid)::text = '001i000000kZfCVAA0'::text) AND ((recordtypeid)::text = '012i0000000DVbcAAG'::text) AND ((guest_card_status__c)::text = 'In Progress'::text))
11. 43.217 43.217 ↑ 1.0 225,499 1

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

  • Index Cond: ((origin)::text = 'Web'::text)
12. 0.080 0.080 ↑ 1.0 1 2

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

  • Index Cond: ((sfid)::text = '001i000000kZfCVAA0'::text)
13. 0.090 0.090 ↑ 1.0 1 2

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

  • Index Cond: ((sfid)::text = (ca.property_of_interest__c)::text)
14. 0.004 0.004 ↓ 0.0 0 2

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

  • Index Cond: ((sfid)::text = (ca.property_consultant__c)::text)
15. 0.002 0.002 ↓ 0.0 0 2

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

  • Index Cond: ((sfid)::text = (ca.contactid)::text)
Planning time : 2.689 ms
Execution time : 555.261 ms