explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lf4Z

Settings
# exclusive inclusive rows x rows loops node
1. 0.216 1.800 ↓ 120.0 120 1

Hash Join (cost=55.19..83.61 rows=1 width=19) (actual time=1.486..1.800 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))
2. 0.120 0.120 ↑ 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.120 rows=758 loops=1)

3. 0.037 1.464 ↓ 112.0 112 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
4. 0.035 1.427 ↓ 114.0 114 1

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

5. 0.202 0.202 ↓ 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.025..0.202 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
6. 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.009..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
Planning time : 1.702 ms