explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QQT0

Settings
# exclusive inclusive rows x rows loops node
1. 3.246 68.169 ↓ 37.4 1,608 1

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

2.          

CTE evc_destinations

3. 0.120 2.456 ↓ 120.0 120 1

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

4. 0.116 1.538 ↓ 114.0 114 1

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

5. 0.232 0.232 ↓ 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.020..0.232 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.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
7. 0.798 0.798 ↑ 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.007 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. 1.266 51.164 ↓ 37.4 1,608 1

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

9. 4.788 33.818 ↓ 37.4 1,608 1

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

10. 0.145 14.558 ↓ 37.4 1,608 1

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

11. 1.565 2.088 ↓ 22.2 2,465 1

Hash Join (cost=10.21..148.56 rows=111 width=699) (actual time=0.029..2.088 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.510 0.510 ↓ 1.0 3,337 1

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

13. 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
14. 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)

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. 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)
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 (forNested Loop)

20. 2.503 2.503 ↓ 120.0 120 1

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

Planning time : 3.653 ms