explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7PWW

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 1,730.216 ↓ 0.0 0 1

Limit (cost=487,648.73..487,648.73 rows=1 width=258) (actual time=1,730.216..1,730.216 rows=0 loops=1)

2. 0.006 1,730.215 ↓ 0.0 0 1

Sort (cost=487,648.73..487,648.73 rows=1 width=258) (actual time=1,730.215..1,730.215 rows=0 loops=1)

  • Sort Key: ca.date_and_time_requested_for_contact__c
  • Sort Method: quicksort Memory: 25kB
3. 0.001 1,730.209 ↓ 0.0 0 1

WindowAgg (cost=123,478.18..487,648.72 rows=1 width=258) (actual time=1,730.209..1,730.209 rows=0 loops=1)

4. 0.001 1,730.208 ↓ 0.0 0 1

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

5. 0.000 1,730.207 ↓ 0.0 0 1

Nested Loop Left Join (cost=123,477.62..487,640.12 rows=1 width=151) (actual time=1,730.207..1,730.207 rows=0 loops=1)

6. 0.004 1,730.207 ↓ 0.0 0 1

Nested Loop (cost=123,477.20..487,631.68 rows=1 width=145) (actual time=1,730.207..1,730.207 rows=0 loops=1)

7. 2.283 1,730.199 ↓ 2.0 2 1

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

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

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

  • Recheck Cond: (((origin)::text = 'Web'::text) AND ((status)::text = ANY ('{Inquiry,"Showing Set"}'::text[])))
  • Rows Removed by Index Recheck: 727006
  • 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: 132776
  • Heap Blocks: exact=25181 lossy=166068
9. 8.438 650.262 ↓ 0.0 0 1

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

10. 49.324 49.324 ↑ 1.0 225,512 1

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

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

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

  • Index Cond: ((status)::text = ANY ('{Inquiry,"Showing Set"}'::text[]))
12. 1.600 1.600 ↑ 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.800 rows=2,661 loops=2)

13. 0.004 0.004 ↓ 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.002..0.002 rows=0 loops=2)

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

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

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

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

  • Index Cond: ((sfid)::text = (ca.property_consultant__c)::text)
Planning time : 3.978 ms
Execution time : 1,730.913 ms