explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5hj6

Settings
# exclusive inclusive rows x rows loops node
1. 3.273 66.890 ↓ 37.4 1,608 1

Nested Loop (cost=65.78..566.67 rows=43 width=481) (actual time=3.407..66.890 rows=1,608 loops=1)

2.          

CTE evc_destinations

3. 0.036 3.152 ↓ 120.0 120 1

Nested Loop (cost=0.22..55.26 rows=1 width=19) (actual time=0.070..3.152 rows=120 loops=1)

4. 0.116 1.976 ↓ 114.0 114 1

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

5. 0.551 0.551 ↓ 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.033..0.551 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.309 1.309 ↑ 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.011..0.011 rows=1 loops=119)

  • Index Cond: ((service__c)::text = (service.sfid)::text)
  • Filter: ((status__c)::text = 'Active'::text)
  • Rows Removed by Filter: 0
7. 1.140 1.140 ↑ 1.0 1 114

Index Scan using destinations_location_idx on service_provider_destination__c destination (cost=0.06..0.07 rows=1 width=57) (actual time=0.006..0.010 rows=1 loops=114)

  • Index Cond: ((location__c)::text = (component.location_a__c)::text)
  • Filter: ((component.service_provider__c)::text = (account__c)::text)
  • Rows Removed by Filter: 5
8. 0.777 49.161 ↓ 37.4 1,608 1

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

9. 1.570 32.304 ↓ 37.4 1,608 1

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

10. 0.209 14.654 ↓ 37.4 1,608 1

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

11. 1.598 2.120 ↓ 22.2 2,465 1

Hash Join (cost=10.21..148.56 rows=111 width=699) (actual time=0.036..2.120 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))
12. 0.504 0.504 ↑ 1.0 3,337 1

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

13. 0.005 0.018 ↑ 3.8 8 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
14. 0.013 0.013 ↑ 3.8 8 1

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

15. 12.325 12.325 ↑ 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.005..0.005 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
16. 16.080 16.080 ↑ 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.010..0.010 rows=1 loops=1,608)

  • Index Cond: ((sfid)::text = (spd.location__c)::text)
17. 16.080 16.080 ↑ 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.010..0.010 rows=1 loops=1,608)

  • Index Cond: ((sfid)::text = (loc.building__c)::text)
18. 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)
19.          

SubPlan (for Nested Loop)

20. 3.200 3.200 ↓ 120.0 120 1

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

Planning time : 15.099 ms