explain.depesz.com

PostgreSQL's explain analyze made readable

Result: f7oX

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 2.757 ↓ 120.0 120 1

Nested Loop (cost=55.28..83.71 rows=1 width=19) (actual time=1.517..2.757 rows=120 loops=1)

2. 0.218 1.798 ↓ 120.0 120 1

Hash Join (cost=55.19..83.61 rows=1 width=57) (actual time=1.503..1.798 rows=120 loops=1)

  • Hash Cond: (((destination.account__c)::text = (component.service_provider__c)::text) AND ((destination.location__c)::text = (component.location_a__c)::text))
3. 0.098 0.098 ↑ 1.0 758 1

Seq Scan on service_provider_destination__c destination (cost=0.00..27.27 rows=758 width=57) (actual time=0.007..0.098 rows=758 loops=1)

4. 0.039 1.482 ↓ 112.0 112 1

Hash (cost=55.19..55.19 rows=1 width=38) (actual time=1.482..1.482 rows=112 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
5. 0.059 1.443 ↓ 114.0 114 1

Nested Loop (cost=0.17..55.19 rows=1 width=38) (actual time=0.042..1.443 rows=114 loops=1)

6. 0.194 0.194 ↓ 119.0 119 1

Index Scan using service__c_account__c_idx on service__c service (cost=0.08..47.99 rows=1 width=19) (actual time=0.026..0.194 rows=119 loops=1)

  • Index Cond: ((account__c)::text = '00160000014IZvAAAW'::text)
  • Filter: ((product_category__c)::text = 'Connect to Cloud (NNI)'::text)
  • Rows Removed by Filter: 5
7. 1.190 1.190 ↑ 3.0 1 119

Index Scan using service_component__c_service__c_idx on service_component__c component (cost=0.08..7.18 rows=3 width=57) (actual time=0.010..0.010 rows=1 loops=119)

  • Index Cond: ((service__c)::text = (service.sfid)::text)
  • Filter: ((status__c)::text = 'Active'::text)
  • Rows Removed by Filter: 0
8. 0.960 0.960 ↑ 1.0 1 120

Index Only Scan using account_temp_later_delete_sfid_key on account (cost=0.08..0.10 rows=1 width=19) (actual time=0.008..0.008 rows=1 loops=120)

  • Index Cond: (sfid = (component.service_provider__c)::text)
  • Heap Fetches: 0
Planning time : 2.108 ms