explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SD18

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.003 0.016 ↓ 0.0 0 1

Sort (cost=15.18..15.19 rows=1 width=189) (actual time=0.016..0.016 rows=0 loops=1)

  • Sort Key: wifiaeroscouttagspositionhistory.watph_from DESC
  • Sort Method: quicksort Memory: 25kB
2. 0.000 0.013 ↓ 0.0 0 1

Nested Loop (cost=0.29..15.17 rows=1 width=189) (actual time=0.013..0.013 rows=0 loops=1)

  • Join Filter: (wifiaeroscouttagspositionhistory.watph_wap_basemac = wifiaccesspoints.wap_basemac)
3. 0.001 0.013 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.29..14.04 rows=1 width=180) (actual time=0.013..0.013 rows=0 loops=1)

4. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on wifiaeroscouttagspositionhistory (cost=0.00..1.66 rows=1 width=22) (actual time=0.012..0.012 rows=0 loops=1)

  • Filter: ((watph_wap_basemac IS NOT NULL) AND (watph_wat_mac = '70:70:8b:81:91:00'::macaddr))
  • Rows Removed by Filter: 61
5. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.29..12.36 rows=1 width=164) (never executed)

6. 0.000 0.000 ↓ 0.0 0

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

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

Index Scan using nodeslogical_pkey on nodeslogical (cost=0.14..4.16 rows=1 width=158) (never executed)

  • Index Cond: (nl_id = wifiaccesspointsassignmenthistory.wapah_nl_id)
8. 0.000 0.000 ↓ 0.0 0

Seq Scan on wifiaccesspoints (cost=0.00..1.06 rows=6 width=15) (never executed)