explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DrUF

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 0.183 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.11..42.22 rows=1 width=911) (actual time=0.180..0.183 rows=1 loops=1)

2. 0.010 0.150 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.69..33.78 rows=1 width=405) (actual time=0.148..0.150 rows=1 loops=1)

3. 0.005 0.122 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.41..25.48 rows=1 width=315) (actual time=0.120..0.122 rows=1 loops=1)

4. 0.010 0.076 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.99..17.03 rows=1 width=264) (actual time=0.074..0.076 rows=1 loops=1)

5. 0.024 0.024 ↑ 1.0 1 1

Index Scan using service_request1__c_pkey on service_request1__c sr (cost=0.43..8.45 rows=1 width=249) (actual time=0.022..0.024 rows=1 loops=1)

  • Index Cond: (id = 2827522)
6. 0.042 0.042 ↑ 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.042..0.042 rows=1 loops=1)

  • Index Cond: ((sfid)::text = (sr.property_consultant__c)::text)
  • Filter: ((recordtypeid)::text = '0120H000001O7IWQA0'::text)
7. 0.041 0.041 ↑ 1.0 1 1

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

  • Index Cond: ((sfid)::text = (sr.property_of_interest__c)::text)
  • Filter: ((account__c)::text = (sr.account_name__c)::text)
8. 0.018 0.018 ↑ 1.0 1 1

Index Scan using account_idx_sfid on account ac (cost=0.28..8.30 rows=1 width=109) (actual time=0.018..0.018 rows=1 loops=1)

  • Index Cond: ((sr.account_name__c)::text = (sfid)::text)
9. 0.023 0.023 ↑ 1.0 1 1

Index Scan using source__c_idx_sfid on source__c s (cost=0.42..8.44 rows=1 width=142) (actual time=0.023..0.023 rows=1 loops=1)

  • Index Cond: ((sfid)::text = (sr.source__c)::text)
Planning time : 4.097 ms
Execution time : 0.704 ms