explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lQ2P

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 26.884 ↓ 2.0 2 1

Limit (cost=10,984.34..10,984.34 rows=1 width=258) (actual time=26.883..26.884 rows=2 loops=1)

2. 0.006 26.882 ↓ 2.0 2 1

Sort (cost=10,984.34..10,984.34 rows=1 width=258) (actual time=26.882..26.882 rows=2 loops=1)

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

WindowAgg (cost=6,347.43..10,984.33 rows=1 width=258) (actual time=26.874..26.876 rows=2 loops=1)

4. 0.003 26.855 ↓ 2.0 2 1

Nested Loop Left Join (cost=6,347.43..10,984.31 rows=1 width=147) (actual time=26.838..26.855 rows=2 loops=1)

5. 0.001 26.852 ↓ 2.0 2 1

Nested Loop Left Join (cost=6,346.87..10,975.73 rows=1 width=117) (actual time=26.836..26.852 rows=2 loops=1)

6. 0.001 26.849 ↓ 2.0 2 1

Nested Loop Left Join (cost=6,346.31..10,967.15 rows=1 width=121) (actual time=26.834..26.849 rows=2 loops=1)

7. 0.004 26.828 ↓ 2.0 2 1

Nested Loop (cost=6,345.89..10,958.71 rows=1 width=115) (actual time=26.820..26.828 rows=2 loops=1)

8. 0.019 26.810 ↓ 2.0 2 1

Bitmap Heap Scan on "case" ca (cost=6,345.61..10,950.41 rows=1 width=111) (actual time=26.806..26.810 rows=2 loops=1)

  • Recheck Cond: ((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 without time zone) AND (...)
  • Filter: (created_via_concierge__c AND ((status)::text = ANY ('{Inquiry,"Showing Set"}'::text[])) AND ((_outbound_call_attempt = ANY ('{0,1}'::integer[])) OR (_outbound_call_attempt IS NULL)) AND ((recordtypeid):: (...)
  • Heap Blocks: exact=2
9. 0.332 26.791 ↓ 0.0 0 1

BitmapAnd (cost=6,345.61..6,345.61 rows=1,159 width=0) (actual time=26.791..26.791 rows=0 loops=1)

10. 0.007 0.007 ↑ 33,241.0 2 1

Bitmap Index Scan on hc_idx_case_date_and_time_requested_for_contact__c (cost=0.00..1,729.67 rows=66,482 width=0) (actual time=0.007..0.007 rows=2 loops=1)

  • Index Cond: ((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 without time (...)
11. 26.452 26.452 ↑ 1.0 225,506 1

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

  • Index Cond: ((origin)::text = 'Web'::text)
12. 0.014 0.014 ↑ 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.007..0.007 rows=1 loops=2)

  • Index Cond: ((sfid)::text = (ca.accountid)::text)
13. 0.020 0.020 ↑ 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.010..0.010 rows=1 loops=2)

  • Index Cond: ((sfid)::text = (ca.property_of_interest__c)::text)
14. 0.002 0.002 ↓ 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.001..0.001 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 : 1.419 ms
Execution time : 27.051 ms