explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yPR

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 1,553.214 ↓ 2.0 2 1

Limit (cost=487,648.73..487,648.73 rows=1 width=258) (actual time=1,553.213..1,553.214 rows=2 loops=1)

2. 0.007 1,553.213 ↓ 2.0 2 1

Sort (cost=487,648.73..487,648.73 rows=1 width=258) (actual time=1,553.212..1,553.213 rows=2 loops=1)

  • Sort Key: ca.date_and_time_requested_for_contact__c
  • Sort Method: quicksort Memory: 25kB
3. 0.022 1,553.206 ↓ 2.0 2 1

WindowAgg (cost=123,478.18..487,648.72 rows=1 width=258) (actual time=1,553.203..1,553.206 rows=2 loops=1)

4. 0.004 1,553.184 ↓ 2.0 2 1

Nested Loop Left Join (cost=123,478.18..487,648.69 rows=1 width=147) (actual time=1,551.633..1,553.184 rows=2 loops=1)

5. 0.003 1,553.180 ↓ 2.0 2 1

Nested Loop Left Join (cost=123,477.62..487,640.12 rows=1 width=117) (actual time=1,551.631..1,553.180 rows=2 loops=1)

6. 0.006 1,553.177 ↓ 2.0 2 1

Nested Loop Left Join (cost=123,477.06..487,631.54 rows=1 width=121) (actual time=1,551.629..1,553.177 rows=2 loops=1)

7. 2.309 1,553.133 ↓ 2.0 2 1

Nested Loop (cost=123,476.64..487,623.10 rows=1 width=115) (actual time=1,551.597..1,553.133 rows=2 loops=1)

  • Join Filter: ((ca.accountid)::text = (ac.sfid)::text)
  • Rows Removed by Join Filter: 5320
8. 1,056.014 1,549.238 ↓ 2.0 2 1

Bitmap Heap Scan on "case" ca (cost=123,476.64..487,057.98 rows=1 width=111) (actual time=1,549.179..1,549.238 rows=2 loops=1)

  • Recheck Cond: (((origin)::text = 'Web'::text) AND ((status)::text = ANY ('{Inquiry,"Showing Set"}'::text[])))
  • Rows Removed by Index Recheck: 727004
  • Filter: (created_via_concierge__c AND (date_and_time_requested_for_contact__c >= '2019-08-06 18:02:51'::timestamp without time zone) AND (date_and_time_requested_for_contact__c < '2019-08-08 18:02:51'::timestamp (...)
  • Rows Removed by Filter: 132774
  • Heap Blocks: exact=25181 lossy=166068
9. 5.842 493.224 ↓ 0.0 0 1

BitmapAnd (cost=123,476.64..123,476.64 rows=107,631 width=0) (actual time=493.224..493.224 rows=0 loops=1)

10. 33.683 33.683 ↑ 1.0 225,510 1

Bitmap Index Scan on hc_idx_case_origin (cost=0.00..4,615.69 rows=232,967 width=0) (actual time=33.683..33.683 rows=225,510 loops=1)

  • Index Cond: ((origin)::text = 'Web'::text)
11. 453.699 453.699 ↑ 1.0 6,106,546 1

Bitmap Index Scan on hc_idx_case_status (cost=0.00..118,860.70 rows=6,173,844 width=0) (actual time=453.699..453.699 rows=6,106,546 loops=1)

  • Index Cond: ((status)::text = ANY ('{Inquiry,"Showing Set"}'::text[]))
12. 1.586 1.586 ↑ 1.0 2,661 2

Seq Scan on account ac (cost=0.00..531.72 rows=2,672 width=42) (actual time=0.004..0.793 rows=2,661 loops=2)

13. 0.038 0.038 ↑ 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.019..0.019 rows=1 loops=2)

  • Index Cond: ((sfid)::text = (ca.property_of_interest__c)::text)
14. 0.000 0.000 ↓ 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.000..0.000 rows=0 loops=2)

  • Index Cond: ((sfid)::text = (ca.property_consultant__c)::text)
15. 0.000 0.000 ↓ 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.000..0.000 rows=0 loops=2)

  • Index Cond: ((sfid)::text = (ca.contactid)::text)
Planning time : 2.746 ms
Execution time : 1,553.782 ms