explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BKOB

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 1.287 ↓ 0.0 0 1

Limit (cost=366.68..366.68 rows=10 width=399) (actual time=1.287..1.287 rows=0 loops=1)

2. 0.011 1.286 ↓ 0.0 0 1

Sort (cost=366.68..366.68 rows=10 width=399) (actual time=1.286..1.286 rows=0 loops=1)

  • Sort Key: nr.name, nr.route_tier__c, nr.createddate
  • Sort Method: quicksort Memory: 25kB
3. 0.001 1.275 ↓ 0.0 0 1

Nested Loop (cost=0.42..366.64 rows=10 width=399) (actual time=1.275..1.275 rows=0 loops=1)

4. 0.000 1.274 ↓ 0.0 0 1

Nested Loop (cost=0.34..366.42 rows=1 width=418) (actual time=1.274..1.274 rows=0 loops=1)

5. 0.004 1.274 ↓ 0.0 0 1

Nested Loop (cost=0.25..351.40 rows=1 width=399) (actual time=1.274..1.274 rows=0 loops=1)

6. 0.047 0.685 ↓ 1.3 39 1

Nested Loop (cost=0.17..228.53 rows=30 width=342) (actual time=0.056..0.685 rows=39 loops=1)

7. 0.050 0.050 ↓ 1.1 42 1

Index Scan using hc_idx_network_route__c_recordtypeid on network_route__c nr (cost=0.08..73.09 rows=38 width=285) (actual time=0.023..0.050 rows=42 loops=1)

  • Index Cond: ((nr.recordtypeid)::text = '01260000000DvWTAA0'::text)
8. 0.588 0.588 ↑ 1.0 1 42

Index Scan using hcu_idx_building__c_sfid on building__c ab (cost=0.08..4.09 rows=1 width=76) (actual time=0.014..0.014 rows=1 loops=42)

  • Index Cond: ((ab.sfid)::text = (nr.a_building__c)::text)
  • Filter: (((ab.country__c)::text = 'USA'::text) OR ((ab.country__c)::text = 'Mexico'::text))
9. 0.585 0.585 ↓ 0.0 0 39

Index Scan using hcu_idx_building__c_sfid on building__c zb (cost=0.08..4.09 rows=1 width=76) (actual time=0.015..0.015 rows=0 loops=39)

  • Index Cond: ((zb.sfid)::text = (nr.z_building__c)::text)
  • Filter: (((zb.country__c)::text = 'Mexico'::text) OR ((zb.country__c)::text = 'USA'::text))
10. 0.000 0.000 ↓ 0.0 0 0

Index Scan using hc_idx_network_route_location__c_network_route__c on network_route_location__c znrl (cost=0.08..15.01 rows=3 width=19) (never executed)

  • Index Cond: ((znrl.network_route__c)::text = (nr.sfid)::text)
  • Filter: ((znrl.type__c)::text = 'Z Location'::text)
11. 0.000 0.000 ↓ 0.0 0 0

Index Scan using hc_idx_network_route_location__c_network_route__c on network_route_location__c anrl (cost=0.08..0.21 rows=3 width=19) (never executed)

  • Index Cond: ((anrl.network_route__c)::text = (znrl.network_route__c)::text)
  • Filter: ((anrl.type__c)::text = 'A Location'::text)