explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ep7E

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 3.089 ↓ 6.0 6 1

Limit (cost=2,365.41..2,365.42 rows=1 width=252) (actual time=3.089..3.089 rows=6 loops=1)

2. 0.009 3.088 ↓ 6.0 6 1

Sort (cost=2,365.41..2,365.42 rows=1 width=252) (actual time=3.088..3.088 rows=6 loops=1)

  • Sort Key: sr.createddate DESC
  • Sort Method: quicksort Memory: 26kB
3. 0.031 3.079 ↓ 6.0 6 1

WindowAgg (cost=24.55..2,365.40 rows=1 width=252) (actual time=3.072..3.079 rows=6 loops=1)

4. 0.011 3.048 ↓ 6.0 6 1

Nested Loop Left Join (cost=24.55..2,365.38 rows=1 width=193) (actual time=0.496..3.048 rows=6 loops=1)

5. 0.009 2.977 ↓ 6.0 6 1

Nested Loop Left Join (cost=23.99..2,356.81 rows=1 width=197) (actual time=0.475..2.977 rows=6 loops=1)

  • Join Filter: ((u.sfid)::text = (sr.unit_needing_service__c)::text)
6. 0.002 2.920 ↓ 6.0 6 1

Nested Loop Left Join (cost=23.57..2,348.35 rows=1 width=205) (actual time=0.454..2.920 rows=6 loops=1)

7. 0.007 2.852 ↓ 6.0 6 1

Nested Loop (cost=23.14..2,339.90 rows=1 width=194) (actual time=0.453..2.852 rows=6 loops=1)

8. 0.007 2.797 ↓ 6.0 6 1

Nested Loop (cost=22.72..2,331.24 rows=1 width=205) (actual time=0.441..2.797 rows=6 loops=1)

9. 2.622 2.736 ↓ 9.0 9 1

Bitmap Heap Scan on service_request1__c sr (cost=22.31..2,322.80 rows=1 width=174) (actual time=0.177..2.736 rows=9 loops=1)

  • Recheck Cond: (((account_name__c)::text = '001i000000kZfCVAA0'::text) AND (createddate > (CURRENT_DATE - '6 mons'::interval)))
  • Filter: ((unit_needing_service__c)::text = 'a1Ji000000Pd87KEAR'::text)
  • Rows Removed by Filter: 585
  • Heap Blocks: exact=571
10. 0.114 0.114 ↓ 1.3 761 1

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

  • Index Cond: (((account_name__c)::text = '001i000000kZfCVAA0'::text) AND (createddate > (CURRENT_DATE - '6 mons'::interval)))
11. 0.054 0.054 ↑ 1.0 1 9

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.006..0.006 rows=1 loops=9)

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

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

  • Index Cond: ((sfid)::text = (sr.property_of_interest__c)::text)
  • Filter: ((account__c)::text = '001i000000kZfCVAA0'::text)
13. 0.066 0.066 ↓ 0.0 0 6

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.011..0.011 rows=0 loops=6)

  • Index Cond: ((service_request__c)::text = (sr.sfid)::text)
14. 0.048 0.048 ↑ 1.0 1 6

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

  • Index Cond: ((sfid)::text = 'a1Ji000000Pd87KEAR'::text)
15. 0.060 0.060 ↑ 1.0 1 6

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

  • Index Cond: ((sfid)::text = (sr.property_consultant__c)::text)
Planning time : 2.631 ms
Execution time : 3.229 ms