explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wb5W : Optimization for: plan #SD18

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.015 0.066 ↑ 1.0 76 1

Hash Join (cost=28.18..30.63 rows=76 width=189) (actual time=0.037..0.066 rows=76 loops=1)

  • Hash Cond: (wifiaeroscouttagspositionhistory.watph_wap_basemac = wifiaccesspoints.wap_basemac)
2. 0.013 0.041 ↑ 1.0 76 1

Hash Left Join (cost=27.05..29.16 rows=76 width=180) (actual time=0.023..0.041 rows=76 loops=1)

  • Hash Cond: (wifiaeroscouttagspositionhistory.watph_wap_basemac = wifiaccesspointsassignmenthistory.wapah_basemac)
3. 0.012 0.012 ↑ 1.0 76 1

Seq Scan on wifiaeroscouttagspositionhistory (cost=0.00..1.82 rows=76 width=22) (actual time=0.005..0.012 rows=76 loops=1)

  • Filter: (watph_wap_basemac IS NOT NULL)
  • Rows Removed by Filter: 8
4. 0.000 0.016 ↑ 8.0 1 1

Hash (cost=26.95..26.95 rows=8 width=164) (actual time=0.016..0.016 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
5. 0.007 0.016 ↑ 8.0 1 1

Hash Right Join (cost=14.42..26.95 rows=8 width=164) (actual time=0.012..0.016 rows=1 loops=1)

  • Hash Cond: (nodeslogical.nl_id = wifiaccesspointsassignmenthistory.wapah_nl_id)
6. 0.003 0.003 ↑ 50.0 4 1

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

7. 0.001 0.006 ↑ 8.0 1 1

Hash (cost=14.32..14.32 rows=8 width=10) (actual time=0.006..0.006 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
8. 0.002 0.005 ↑ 8.0 1 1

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

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

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

10. 0.003 0.010 ↑ 1.0 6 1

Hash (cost=1.06..1.06 rows=6 width=15) (actual time=0.010..0.010 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
11. 0.007 0.007 ↑ 1.0 6 1

Seq Scan on wifiaccesspoints (cost=0.00..1.06 rows=6 width=15) (actual time=0.006..0.007 rows=6 loops=1)