explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aIC0

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 1.449 3.906 ↑ 5,997,001.5 2,001 1

Nested Loop Left Join (cost=364.07..633,831,092.66 rows=12,000,000,000 width=366) (actual time=0.975..3.906 rows=2,001 loops=1)

2. 0.268 0.456 ↓ 1.0 2,001 1

Hash Left Join (cost=16.51..57.02 rows=2,000 width=103) (actual time=0.016..0.456 rows=2,001 loops=1)

  • Hash Cond: (wifiaeroscouttags.wat_mac = wifiaeroscouttagsassignmenthistory.watah_mac)
3. 0.185 0.185 ↓ 1.0 2,001 1

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

  • Filter: (wat_active IS TRUE)
4. 0.001 0.003 ↓ 0.0 0 1

Hash (cost=16.50..16.50 rows=1 width=70) (actual time=0.003..0.003 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
5. 0.000 0.002 ↓ 0.0 0 1

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

6. 0.000 0.002 ↓ 0.0 0 1

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

7. 0.002 0.002 ↓ 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.002..0.002 rows=0 loops=1)

8. 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)
9. 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)
10. 0.000 2.001 ↓ 0.0 0 2,001

Nested Loop (cost=347.56..91,915.52 rows=6,000,000 width=196) (actual time=0.001..0.001 rows=0 loops=2,001)

11. 1.056 2.001 ↓ 0.0 0 2,001

Hash Join (cost=347.56..16,896.02 rows=6,000 width=148) (actual time=0.001..0.001 rows=0 loops=2,001)

  • Hash Cond: (wifiaccesspointsassignmenthistory.wapah_nl_id = nodeslogical_1.nl_id)
12. 0.000 0.000 ↓ 0.0 0 2,001

Bitmap Heap Scan on wifiaccesspointsassignmenthistory (cost=207.06..16,739.75 rows=6,000 width=10) (actual time=0.000..0.000 rows=0 loops=2,001)

  • Recheck Cond: (wapah_basemac = COALESCE(wifiaeroscouttags.wat_wap_basemac, wifiaeroscouttags.wat_wap_basemac_previous))
13. 0.000 0.000 ↓ 0.0 0 2,001

Bitmap Index Scan on wapah_pkey (cost=0.00..205.56 rows=6,000 width=0) (actual time=0.000..0.000 rows=0 loops=2,001)

  • Index Cond: (wapah_basemac = COALESCE(wifiaeroscouttags.wat_wap_basemac, wifiaeroscouttags.wat_wap_basemac_previous))
14. 0.372 0.945 ↑ 1.0 3,000 1

Hash (cost=103.00..103.00 rows=3,000 width=142) (actual time=0.945..0.945 rows=3,000 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 186kB
15. 0.573 0.573 ↑ 1.0 3,000 1

Seq Scan on nodeslogical nodeslogical_1 (cost=0.00..103.00 rows=3,000 width=142) (actual time=0.003..0.573 rows=3,000 loops=1)

16. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..22.00 rows=1,000 width=32) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Seq Scan on wifiaccesspoints (cost=0.00..17.00 rows=1,000 width=32) (never executed)