explain.depesz.com

PostgreSQL's explain analyze made readable

Result: a8U8 : Optimization for: Optimization for: plan #nFvu; plan #oF5R

Settings

Optimization path:

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

Limit (cost=0.81..3,416.75 rows=1 width=189) (actual time=169.853..169.853 rows=0 loops=1)

2. 0.000 169.852 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.81..10,804,621.44 rows=3,163 width=189) (actual time=169.852..169.852 rows=0 loops=1)

  • Join Filter: (nodeslogical.nl_id = wifiaccesspointsassignmenthistory.wapah_nl_id)
3. 0.001 169.852 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.81..10,795,125.88 rows=3,163 width=35) (actual time=169.852..169.852 rows=0 loops=1)

4. 0.001 169.851 ↓ 0.0 0 1

Nested Loop (cost=0.68..10,794,631.20 rows=3,163 width=37) (actual time=169.851..169.851 rows=0 loops=1)

  • Join Filter: (wifiaccesspoints.wap_basemac = wifiaeroscouttagspositionhistory.watph_wap_basemac)
5. 169.850 169.850 ↓ 0.0 0 1

Index Only Scan using watph_known_position_index on wifiaeroscouttagspositionhistory (cost=0.68..10,746,876.72 rows=3,163 width=22) (actual time=169.850..169.850 rows=0 loops=1)

  • Index Cond: (watph_wat_mac = '22:22:22:22:22:22'::macaddr)
  • Heap Fetches: 0
6. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..25.11 rows=1,007 width=15) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Seq Scan on wifiaccesspoints (cost=0.00..20.07 rows=1,007 width=15) (never executed)

8. 0.000 0.000 ↓ 0.0 0

Index Scan using wapah_unique_active_mac on wifiaccesspointsassignmenthistory (cost=0.12..0.16 rows=1 width=10) (never executed)

  • Index Cond: (wapah_basemac = wifiaeroscouttagspositionhistory.watph_wap_basemac)
9. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..13.00 rows=200 width=158) (never executed)

10. 0.000 0.000 ↓ 0.0 0

Seq Scan on nodeslogical (cost=0.00..12.00 rows=200 width=158) (never executed)