explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RVGA : Optimization for: Optimization for: plan #sg35; plan #TfYh

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.001 0.059 ↑ 1.0 1 1

Limit (cost=5.02..11.51 rows=1 width=189) (actual time=0.058..0.059 rows=1 loops=1)

2. 0.002 0.058 ↑ 26.0 1 1

Nested Loop (cost=5.02..173.68 rows=26 width=189) (actual time=0.057..0.058 rows=1 loops=1)

3. 0.001 0.045 ↑ 26.0 1 1

Nested Loop Left Join (cost=4.74..130.07 rows=26 width=180) (actual time=0.045..0.045 rows=1 loops=1)

  • Join Filter: (wifiaccesspointsassignmenthistory.wapah_basemac = wifiaeroscouttagspositionhistory.watph_wap_basemac)
  • Rows Removed by Join Filter: 1
4. 0.016 0.016 ↑ 26.0 1 1

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

  • Index Cond: (watph_wat_mac = '00:0c:cc:49:17:64'::macaddr)
  • Heap Fetches: 1
5. 0.002 0.028 ↑ 8.0 1 1

Materialize (cost=4.47..80.77 rows=8 width=164) (actual time=0.028..0.028 rows=1 loops=1)

6. 0.003 0.026 ↑ 8.0 1 1

Nested Loop Left Join (cost=4.47..80.73 rows=8 width=164) (actual time=0.026..0.026 rows=1 loops=1)

7. 0.002 0.004 ↑ 8.0 1 1

Bitmap Heap Scan on wifiaccesspointsassignmenthistory (cost=4.19..14.32 rows=8 width=10) (actual time=0.004..0.004 rows=1 loops=1)

  • Recheck Cond: (wapah_end IS NULL)
  • Heap Blocks: exact=1
8. 0.002 0.002 ↑ 8.0 1 1

Bitmap Index Scan on wapah_unique_active_logical (cost=0.00..4.18 rows=8 width=0) (actual time=0.002..0.002 rows=1 loops=1)

9. 0.019 0.019 ↑ 1.0 1 1

Index Scan using nodeslogical_pkey on nodeslogical (cost=0.28..8.30 rows=1 width=158) (actual time=0.019..0.019 rows=1 loops=1)

  • Index Cond: (nl_id = wifiaccesspointsassignmenthistory.wapah_nl_id)
10. 0.011 0.011 ↑ 1.0 1 1

Index Scan using wifiaccesspoints_pkey on wifiaccesspoints (cost=0.28..1.68 rows=1 width=15) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: (wap_basemac = wifiaeroscouttagspositionhistory.watph_wap_basemac)