explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kgGP

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

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

2. 0.008 34.246 ↓ 2.0 2 1

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

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

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

4. 0.002 34.215 ↓ 2.0 2 1

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

5. 0.002 34.213 ↓ 2.0 2 1

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

6. 0.003 34.209 ↓ 2.0 2 1

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

7. 0.006 34.184 ↓ 2.0 2 1

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

8. 0.020 34.162 ↓ 2.0 2 1

Bitmap Heap Scan on "case" ca (cost=6,345.61..10,950.41 rows=1 width=111) (actual time=34.158..34.162 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.380 34.142 ↓ 0.0 0 1

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

10. 0.009 0.009 ↑ 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.009..0.009 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. 33.753 33.753 ↑ 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=33.753..33.753 rows=225,506 loops=1)

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

  • Index Cond: ((sfid)::text = (ca.accountid)::text)
13. 0.022 0.022 ↑ 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.011..0.011 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 : 2.967 ms
Execution time : 34.413 ms