explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7fBh

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1.590 ↓ 0.0 0 1

Limit (cost=401.08..401.09 rows=10 width=399) (actual time=1.590..1.590 rows=0 loops=1)

2. 0.016 1.590 ↓ 0.0 0 1

Sort (cost=401.08..401.09 rows=19 width=399) (actual time=1.590..1.590 rows=0 loops=1)

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

Nested Loop (cost=0.42..401.00 rows=19 width=399) (actual time=1.574..1.574 rows=0 loops=1)

4. 0.001 1.574 ↓ 0.0 0 1

Nested Loop (cost=0.34..400.56 rows=2 width=418) (actual time=1.574..1.574 rows=0 loops=1)

5. 0.015 1.573 ↓ 0.0 0 1

Nested Loop (cost=0.25..355.49 rows=3 width=399) (actual time=1.573..1.573 rows=0 loops=1)

6. 0.048 0.856 ↓ 1.3 39 1

Nested Loop (cost=0.17..228.53 rows=31 width=342) (actual time=0.121..0.856 rows=39 loops=1)

7. 0.136 0.136 ↓ 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.074..0.136 rows=42 loops=1)

  • Index Cond: ((nr.recordtypeid)::text = '01260000000DvWTAA0'::text)
8. 0.672 0.672 ↑ 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.016..0.016 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 = 'Canada'::text))
9. 0.702 0.702 ↓ 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.018..0.018 rows=0 loops=39)

  • Index Cond: ((zb.sfid)::text = (nr.z_building__c)::text)
  • Filter: (((zb.country__c)::text = 'Canada'::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)