explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RAFl

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.017 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.96..21.03 rows=33 width=196) (actual time=0.017..0.017 rows=0 loops=1)

2. 0.002 0.016 ↓ 0.0 0 1

Nested Loop (cost=0.55..16.60 rows=1 width=60) (actual time=0.016..0.016 rows=0 loops=1)

3. 0.014 0.014 ↑ 1.0 1 1

Index Scan using wifiaeroscouttags_pkey on wifiaeroscouttags (cost=0.28..8.29 rows=1 width=28) (actual time=0.013..0.014 rows=1 loops=1)

  • Index Cond: (wat_mac = '00:00:00:00:00:00'::macaddr)
4. 0.000 0.000 ↓ 0.0 0 1

Index Scan using wifiaccesspoints_pkey on wifiaccesspoints (cost=0.28..8.29 rows=1 width=38) (actual time=0.000..0.000 rows=0 loops=1)

  • Index Cond: (wap_basemac = COALESCE(wifiaeroscouttags.wat_wap_basemac, wifiaeroscouttags.wat_wap_basemac_previous))
5. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.41..4.41 rows=1 width=148) (never executed)

6. 0.000 0.000 ↓ 0.0 0

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

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

Index Scan using nodeslogical_pkey on nodeslogical (cost=0.28..0.31 rows=1 width=142) (never executed)

  • Index Cond: (nl_id = wifiaccesspointsassignmenthistory.wapah_nl_id)