explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4yvu

Settings
# exclusive inclusive rows x rows loops node
1. 2.752 60.311 ↓ 37.4 1,608 1

Nested Loop (cost=94.13..595.04 rows=43 width=481) (actual time=1.929..60.311 rows=1,608 loops=1)

2.          

CTE evc_destinations

3. 0.209 1.760 ↓ 120.0 120 1

Hash Join (cost=55.19..83.61 rows=1 width=19) (actual time=1.474..1.760 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))
4. 0.091 0.091 ↑ 1.0 757 1

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

5. 0.033 1.460 ↓ 112.0 112 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
6. 0.039 1.427 ↓ 114.0 114 1

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

7. 0.198 0.198 ↓ 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.021..0.198 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
8. 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
9. 0.646 44.511 ↓ 37.4 1,608 1

Nested Loop (cost=10.44..341.30 rows=43 width=839) (actual time=0.075..44.511 rows=1,608 loops=1)

10. 1.132 29.393 ↓ 37.4 1,608 1

Nested Loop (cost=10.35..332.70 rows=43 width=800) (actual time=0.058..29.393 rows=1,608 loops=1)

11. 1.894 13.789 ↓ 37.4 1,608 1

Nested Loop (cost=10.26..157.40 rows=43 width=768) (actual time=0.041..13.789 rows=1,608 loops=1)

12. 1.535 2.035 ↓ 22.2 2,465 1

Hash Join (cost=10.21..148.56 rows=111 width=699) (actual time=0.027..2.035 rows=2,465 loops=1)

  • Hash Cond: (((cap.tranzact_product_category__c)::text = (p.product_category)::text) AND ((cap.tranzact_product__c)::text = (p.product)::text))
13. 0.487 0.487 ↓ 1.0 3,337 1

Seq Scan on capabilities__c cap (cost=0.00..133.01 rows=3,336 width=183) (actual time=0.006..0.487 rows=3,337 loops=1)

14. 0.006 0.013 ↑ 3.8 8 1

Hash (cost=10.09..10.09 rows=30 width=1,548) (actual time=0.013..0.013 rows=8 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
15. 0.007 0.007 ↑ 3.8 8 1

Seq Scan on products p (cost=0.00..10.09 rows=30 width=1,548) (actual time=0.005..0.007 rows=8 loops=1)

16. 9.860 9.860 ↑ 1.0 1 2,465

Index Scan using service_provider_destination__c_sfid_key on service_provider_destination__c spd (cost=0.06..0.08 rows=1 width=88) (actual time=0.004..0.004 rows=1 loops=2,465)

  • Index Cond: ((sfid)::text = (cap.destination__c)::text)
  • Filter: ((tranzact_search_priority__c IS NOT NULL) AND ((status__c)::text = 'Active'::text) AND ((destination_type__c)::text = 'Cloud'::text))
  • Rows Removed by Filter: 0
17. 14.472 14.472 ↑ 1.0 1 1,608

Index Scan using location__c_sfid_key on location__c loc (cost=0.09..4.08 rows=1 width=51) (actual time=0.009..0.009 rows=1 loops=1,608)

  • Index Cond: ((sfid)::text = (spd.location__c)::text)
18. 14.472 14.472 ↑ 1.0 1 1,608

Index Scan using building__c_sfid_key on building__c b (cost=0.09..0.20 rows=1 width=58) (actual time=0.009..0.009 rows=1 loops=1,608)

  • Index Cond: ((sfid)::text = (loc.building__c)::text)
19. 11.256 11.256 ↑ 1.0 1 1,608

Index Scan using account_temp_later_delete_sfid_key on account a (cost=0.08..3.95 rows=1 width=41) (actual time=0.007..0.007 rows=1 loops=1,608)

  • Index Cond: ((sfid)::text = (spd.account__c)::text)
20.          

SubPlan (for Nested Loop)

21. 1.792 1.792 ↓ 120.0 120 1

CTE Scan on evc_destinations (cost=0.00..0.01 rows=1 width=54) (actual time=1.476..1.792 rows=120 loops=1)

Planning time : 3.509 ms