explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8LId : Optimization for: plan #K5e

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.010 0.116 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.00..41.36 rows=1 width=445) (actual time=0.106..0.116 rows=1 loops=1)

2. 0.002 0.091 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.73..23.87 rows=1 width=151) (actual time=0.082..0.091 rows=1 loops=1)

  • Join Filter: (wifiactivetagsassignmenthistory.watah_mac = wifiactivetags.wat_mac)
3. 0.026 0.026 ↑ 1.0 1 1

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

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

Nested Loop (cost=0.73..21.48 rows=1 width=114) (actual time=0.060..0.063 rows=1 loops=1)

5. 0.003 0.046 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.58..21.07 rows=1 width=86) (actual time=0.044..0.046 rows=1 loops=1)

6. 0.004 0.027 ↑ 1.0 1 1

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

7. 0.015 0.015 ↑ 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.015..0.015 rows=1 loops=1)

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

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

  • Index Cond: (nl_id = wifiactivetagsassignmenthistory.watah_nl_id)
9. 0.001 0.016 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.29..4.66 rows=1 width=76) (actual time=0.015..0.016 rows=1 loops=1)

10. 0.008 0.008 ↑ 1.0 1 1

Index Scan using tdh_index_active on tagdeviceshistory (cost=0.14..0.46 rows=1 width=12) (actual time=0.006..0.008 rows=1 loops=1)

  • Index Cond: (tdh_nl_lamp_id = nla.nl_id)
11. 0.007 0.007 ↑ 1.0 1 1

Index Scan using nodeslogical_pkey on nodeslogical nlp (cost=0.14..4.16 rows=1 width=68) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (nl_id = tagdeviceshistory.tdh_nl_personnel_id)
12. 0.015 0.015 ↑ 1.0 1 1

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

  • Index Cond: (e_id = nla.nl_e_id)
13. 0.002 0.015 ↑ 2.0 1 1

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

14. 0.007 0.007 ↑ 1.0 1 1

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

  • Filter: (wap_basemac = COALESCE(wifiactivetags.wat_wap_basemac, wifiactivetags.wat_wap_basemac_previous))
  • Rows Removed by Filter: 3
15. 0.000 0.006 ↓ 0.0 0 1

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

16. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

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

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

  • Index Cond: (nl_id = wifiaccesspointsassignmenthistory.wapah_nl_id)
Planning time : 1.154 ms