explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 96bv

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

Limit (cost=7,933.55..7,933.55 rows=3 width=399) (actual time=740.216..740.216 rows=0 loops=1)

2. 0.059 740.215 ↓ 0.0 0 1

Sort (cost=7,933.55..7,933.55 rows=3 width=399) (actual time=740.215..740.215 rows=0 loops=1)

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

Nested Loop (cost=5,457.86..7,933.55 rows=3 width=399) (actual time=740.156..740.156 rows=0 loops=1)

4. 0.460 717.289 ↓ 1.3 39 1

Nested Loop (cost=5,457.78..7,806.59 rows=31 width=342) (actual time=518.731..717.289 rows=39 loops=1)

5. 29.210 715.275 ↓ 1.1 42 1

Hash Join (cost=5,457.69..7,651.15 rows=38 width=285) (actual time=518.632..715.275 rows=42 loops=1)

6. 169.419 169.419 ↓ 1.0 50,743 1

Seq Scan on network_route_location__c znrl (cost=0.00..2,156.38 rows=49,360 width=19) (actual time=0.007..169.419 rows=50,743 loops=1)

  • Filter: ((znrl.type__c)::text = 'Z Location'::text)
7. 0.074 516.646 ↓ 1.1 42 1

Hash (cost=5,457.56..5,457.56 rows=38 width=285) (actual time=516.646..516.646 rows=42 loops=1)

8. 33.093 516.572 ↓ 1.1 42 1

Hash Join (cost=3,275.70..5,457.56 rows=38 width=285) (actual time=286.762..516.572 rows=42 loops=1)

9. 198.793 198.793 ↑ 1.0 47,415 1

Seq Scan on network_route_location__c anrl (cost=0.00..2,156.38 rows=48,519 width=19) (actual time=0.011..198.793 rows=47,415 loops=1)

  • Filter: ((anrl.type__c)::text = 'A Location'::text)
10. 0.066 284.686 ↓ 1.1 42 1

Hash (cost=3,275.57..3,275.57 rows=38 width=285) (actual time=284.686..284.686 rows=42 loops=1)

11. 284.620 284.620 ↓ 1.1 42 1

Seq Scan on network_route__c nr (cost=0.00..3,275.57 rows=38 width=285) (actual time=0.346..284.620 rows=42 loops=1)

  • Filter: ((nr.recordtypeid)::text = '01260000000DvWTAA0'::text)
12. 1.554 1.554 ↑ 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.037..0.037 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))
13. 22.815 22.815 ↓ 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.585..0.585 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))