explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DOEc

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.688 ↑ 1.0 1 1

Limit (cost=73.67..73.68 rows=1 width=252) (actual time=0.687..0.688 rows=1 loops=1)

2. 0.022 0.685 ↑ 1.0 1 1

Sort (cost=73.67..73.68 rows=1 width=252) (actual time=0.685..0.685 rows=1 loops=1)

  • Sort Key: sr.createddate DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.050 0.663 ↑ 1.0 1 1

WindowAgg (cost=29.30..73.66 rows=1 width=252) (actual time=0.661..0.663 rows=1 loops=1)

4. 0.008 0.613 ↑ 1.0 1 1

Nested Loop Left Join (cost=29.30..73.65 rows=1 width=193) (actual time=0.610..0.613 rows=1 loops=1)

5. 0.003 0.571 ↑ 1.0 1 1

Nested Loop Left Join (cost=28.74..65.07 rows=1 width=197) (actual time=0.569..0.571 rows=1 loops=1)

6. 0.002 0.540 ↑ 1.0 1 1

Nested Loop Left Join (cost=28.31..56.62 rows=1 width=205) (actual time=0.538..0.540 rows=1 loops=1)

7. 0.003 0.537 ↑ 1.0 1 1

Nested Loop (cost=27.89..48.17 rows=1 width=194) (actual time=0.535..0.537 rows=1 loops=1)

8. 0.011 0.497 ↑ 1.0 1 1

Nested Loop (cost=27.47..39.51 rows=1 width=205) (actual time=0.496..0.497 rows=1 loops=1)

9. 0.016 0.454 ↓ 2.0 2 1

Bitmap Heap Scan on service_request1__c sr (cost=27.05..31.08 rows=1 width=174) (actual time=0.450..0.454 rows=2 loops=1)

  • Recheck Cond: (((contact_name__c)::text = '003i000003Zn7MwAAJ'::text) AND ((account_name__c)::text = '001i000000kZfCVAA0'::text) AND (createddate > (CURRENT_DATE - '6 mons'::interval)))
  • Heap Blocks: exact=2
10. 0.006 0.438 ↓ 0.0 0 1

BitmapAnd (cost=27.05..27.05 rows=1 width=0) (actual time=0.438..0.438 rows=0 loops=1)

11. 0.055 0.055 ↓ 3.7 33 1

Bitmap Index Scan on service_request1__c_idx_contact_name__c (cost=0.00..4.50 rows=9 width=0) (actual time=0.054..0.055 rows=33 loops=1)

  • Index Cond: ((contact_name__c)::text = '003i000003Zn7MwAAJ'::text)
12. 0.377 0.377 ↓ 1.3 759 1

Bitmap Index Scan on ah_idx_service_request1__c_accountid_createddate (cost=0.00..22.30 rows=587 width=0) (actual time=0.377..0.377 rows=759 loops=1)

  • Index Cond: (((account_name__c)::text = '001i000000kZfCVAA0'::text) AND (createddate > (CURRENT_DATE - '6 mons'::interval)))
13. 0.032 0.032 ↓ 0.0 0 2

Index Scan using service_request_type__c_idx_sfid on service_request_type__c srt (cost=0.42..8.44 rows=1 width=68) (actual time=0.016..0.016 rows=0 loops=2)

  • Index Cond: ((sfid)::text = (sr.service_request_type__c)::text)
  • Filter: ((request_classification__c)::text = ANY ('{Emergency,Standard}'::text[]))
14. 0.037 0.037 ↑ 1.0 1 1

Index Scan using property__c_idx_sfid on property__c p (cost=0.42..8.44 rows=1 width=63) (actual time=0.037..0.037 rows=1 loops=1)

  • Index Cond: ((sfid)::text = (sr.property_of_interest__c)::text)
  • Filter: ((account__c)::text = '001i000000kZfCVAA0'::text)
15. 0.001 0.001 ↓ 0.0 0 1

Index Scan using hc_idx_emergency_dispatch__c_service_request__c on emergency_dispatch__c ed (cost=0.42..8.44 rows=1 width=30) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ((service_request__c)::text = (sr.sfid)::text)
16. 0.028 0.028 ↑ 1.0 1 1

Index Scan using unit__c_idx_sfid on unit__c u (cost=0.43..8.45 rows=1 width=28) (actual time=0.028..0.028 rows=1 loops=1)

  • Index Cond: ((sfid)::text = (sr.unit_needing_service__c)::text)
17. 0.034 0.034 ↑ 1.0 1 1

Index Scan using contact_idx_sfid on contact c (cost=0.56..8.58 rows=1 width=34) (actual time=0.034..0.034 rows=1 loops=1)

  • Index Cond: ((sfid)::text = (sr.property_consultant__c)::text)