explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XNIE

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

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

2. 0.038 2.032 ↓ 0.0 0 1

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

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

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

4. 0.001 1.994 ↓ 0.0 0 1

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

5. 0.026 1.993 ↓ 0.0 0 1

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

6. 0.052 1.148 ↓ 1.3 39 1

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

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

  • Index Cond: ((nr.recordtypeid)::text = '01260000000DvWTAA0'::text)
8. 0.840 0.840 ↑ 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.020..0.020 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.819 0.819 ↓ 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.021..0.021 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)