explain.depesz.com

PostgreSQL's explain analyze made readable

Result: K5e

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.006 0.055 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.71..36.69 rows=1 width=445) (actual time=0.049..0.055 rows=1 loops=1)

  • Join Filter: (wifiactivetagsassignmenthistory.watah_mac = wifiactivetags.wat_mac)
2. 0.002 0.029 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.27..19.84 rows=1 width=207) (actual time=0.024..0.029 rows=1 loops=1)

3. 0.013 0.013 ↑ 1.0 1 1

Seq Scan on wifiactivetags (cost=0.00..2.38 rows=1 width=43) (actual time=0.010..0.013 rows=1 loops=1)

  • Filter: (wat_mac = '00:0c:cc:13:99:2f'::macaddr)
  • Rows Removed by Filter: 29
4. 0.002 0.014 ↑ 2.0 1 1

Nested Loop Left Join (cost=0.27..17.44 rows=2 width=192) (actual time=0.013..0.014 rows=1 loops=1)

5. 0.004 0.004 ↑ 1.0 1 1

Seq Scan on wifiaccesspoints (cost=0.00..1.05 rows=1 width=18) (actual time=0.003..0.004 rows=1 loops=1)

  • Filter: (wap_basemac = COALESCE(wifiactivetags.wat_wap_basemac, wifiactivetags.wat_wap_basemac_previous))
  • Rows Removed by Filter: 3
6. 0.001 0.008 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.27..16.38 rows=1 width=164) (actual time=0.008..0.008 rows=0 loops=1)

7. 0.007 0.007 ↓ 0.0 0 1

Index Scan using wapah_unique_active_mac on wifiaccesspointsassignmenthistory (cost=0.12..8.14 rows=1 width=10) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (wapah_basemac = wifiaccesspoints.wap_basemac)
8. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (nl_id = wifiaccesspointsassignmenthistory.wapah_nl_id)
9. 0.001 0.020 ↑ 1.0 1 1

Nested Loop (cost=0.44..16.81 rows=1 width=114) (actual time=0.019..0.020 rows=1 loops=1)

10. 0.001 0.014 ↑ 1.0 1 1

Nested Loop (cost=0.29..16.40 rows=1 width=86) (actual time=0.013..0.014 rows=1 loops=1)

11. 0.007 0.007 ↑ 1.0 1 1

Index Scan using watah_unique_active_mac on wifiactivetagsassignmenthistory (cost=0.14..8.16 rows=1 width=18) (actual time=0.006..0.007 rows=1 loops=1)

  • Index Cond: (watah_mac = '00:0c:cc:13:99:2f'::macaddr)
12. 0.006 0.006 ↑ 1.0 1 1

Index Scan using nodeslogical_pkey on nodeslogical (cost=0.14..8.16 rows=1 width=72) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: (nl_id = wifiactivetagsassignmenthistory.watah_nl_id)
13. 0.005 0.005 ↑ 1.0 1 1

Index Scan using entities_pkey on entities (cost=0.15..0.41 rows=1 width=36) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (e_id = nodeslogical.nl_e_id)
Planning time : 0.629 ms