explain.depesz.com

PostgreSQL's explain analyze made readable

Result: flp3 : Optimization for: plan #aIC0

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 1.232 2.530 ↓ 1.0 2,001 1

Nested Loop Left Join (cost=1.37..25,513.74 rows=2,000 width=366) (actual time=0.019..2.530 rows=2,001 loops=1)

  • Join Filter: (wifiaeroscouttagsassignmenthistory.watah_mac = wifiaeroscouttags.wat_mac)
2. 1.058 1.298 ↓ 1.0 2,001 1

Nested Loop Left Join (cost=0.68..25,432.24 rows=2,000 width=207) (actual time=0.011..1.298 rows=2,001 loops=1)

3. 0.240 0.240 ↓ 1.0 2,001 1

Seq Scan on wifiaeroscouttags (cost=0.00..33.00 rows=2,000 width=39) (actual time=0.007..0.240 rows=2,001 loops=1)

  • Filter: (wat_active IS TRUE)
4. 0.000 0.000 ↓ 0.0 0 2,001

Nested Loop Left Join (cost=0.68..12.69 rows=1 width=196) (actual time=0.000..0.000 rows=0 loops=2,001)

5. 0.000 0.000 ↓ 0.0 0 2,001

Nested Loop Left Join (cost=0.40..4.39 rows=1 width=42) (actual time=0.000..0.000 rows=0 loops=2,001)

  • Join Filter: (wifiaccesspointsassignmenthistory.wapah_basemac = wifiaccesspoints.wap_basemac)
6. 0.000 0.000 ↓ 0.0 0 2,001

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

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

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

8. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (nl_id = wifiaccesspointsassignmenthistory.wapah_nl_id)
9. 0.000 0.000 ↓ 0.0 0 2,001

Materialize (cost=0.69..16.50 rows=1 width=70) (actual time=0.000..0.000 rows=0 loops=2,001)

10. 0.000 0.001 ↓ 0.0 0 1

Nested Loop (cost=0.69..16.50 rows=1 width=70) (actual time=0.001..0.001 rows=0 loops=1)

11. 0.000 0.001 ↓ 0.0 0 1

Nested Loop (cost=0.41..16.13 rows=1 width=70) (actual time=0.001..0.001 rows=0 loops=1)

12. 0.001 0.001 ↓ 0.0 0 1

Index Scan using watah_unique_active_logical on wifiaeroscouttagsassignmenthistory (cost=0.12..7.83 rows=1 width=18) (actual time=0.001..0.001 rows=0 loops=1)

13. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (nl_id = wifiaeroscouttagsassignmenthistory.watah_nl_id)
14. 0.000 0.000 ↓ 0.0 0

Index Scan using entities_pkey on entities (cost=0.28..0.36 rows=1 width=8) (never executed)

  • Index Cond: (e_id = nodeslogical.nl_e_id)