explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6iil : Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: plan #SD18; plan #wb5W; plan #QfXa; plan #Z4Wx; plan #qSC9; plan #7cNA; plan #YOug

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.002 0.034 ↑ 1.0 1 1

Limit (cost=0.42..8.98 rows=1 width=189) (actual time=0.033..0.034 rows=1 loops=1)

2. 0.001 0.032 ↑ 21.0 1 1

Nested Loop Left Join (cost=0.42..180.12 rows=21 width=189) (actual time=0.032..0.032 rows=1 loops=1)

  • Join Filter: (nodeslogical.nl_id = wifiaccesspointsassignmenthistory.wapah_nl_id)
  • Rows Removed by Join Filter: 4
3. 0.001 0.026 ↑ 21.0 1 1

Nested Loop Left Join (cost=0.42..104.62 rows=21 width=35) (actual time=0.026..0.026 rows=1 loops=1)

4. 0.001 0.023 ↑ 21.0 1 1

Nested Loop (cost=0.28..52.70 rows=21 width=37) (actual time=0.023..0.023 rows=1 loops=1)

  • Join Filter: (wifiaccesspoints.wap_basemac = wifiaeroscouttagspositionhistory.watph_wap_basemac)
  • Rows Removed by Join Filter: 2
5. 0.016 0.016 ↑ 21.0 1 1

Index Only Scan using watph_wat_mac_index on wifiaeroscouttagspositionhistory (cost=0.28..49.86 rows=21 width=22) (actual time=0.016..0.016 rows=1 loops=1)

  • Index Cond: ((watph_wat_mac = '00:0c:cc:49:17:64'::macaddr) AND (watph_wap_basemac IS NOT NULL))
  • Heap Fetches: 1
6. 0.002 0.006 ↑ 2.0 3 1

Materialize (cost=0.00..1.09 rows=6 width=15) (actual time=0.005..0.006 rows=3 loops=1)

7. 0.004 0.004 ↑ 2.0 3 1

Seq Scan on wifiaccesspoints (cost=0.00..1.06 rows=6 width=15) (actual time=0.003..0.004 rows=3 loops=1)

8. 0.002 0.002 ↓ 0.0 0 1

Index Scan using wapah_unique_active_mac on wifiaccesspointsassignmenthistory (cost=0.14..2.45 rows=1 width=10) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (wapah_basemac = wifiaeroscouttagspositionhistory.watph_wap_basemac)
9. 0.001 0.005 ↑ 50.0 4 1

Materialize (cost=0.00..13.00 rows=200 width=158) (actual time=0.003..0.005 rows=4 loops=1)

10. 0.004 0.004 ↑ 50.0 4 1

Seq Scan on nodeslogical (cost=0.00..12.00 rows=200 width=158) (actual time=0.003..0.004 rows=4 loops=1)