explain.depesz.com

PostgreSQL's explain analyze made readable

Result: U5AJ : Optimization for: plan #e6Q6

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.038 0.112 ↑ 1.0 32 1

Hash Right Join (cost=16.44..35.41 rows=32 width=156) (actual time=0.097..0.112 rows=32 loops=1)

  • Hash Cond: (wifiaeroscouttagsassignmenthistory.watah_mac = wifiaeroscouttags.wat_mac)
2. 0.001 0.054 ↑ 8.0 1 1

Nested Loop (cost=14.72..33.43 rows=8 width=110) (actual time=0.054..0.054 rows=1 loops=1)

3. 0.002 0.047 ↑ 8.0 1 1

Nested Loop (cost=14.57..30.17 rows=8 width=82) (actual time=0.046..0.047 rows=1 loops=1)

4. 0.013 0.029 ↑ 8.0 1 1

Hash Join (cost=14.42..26.95 rows=8 width=86) (actual time=0.028..0.029 rows=1 loops=1)

  • Hash Cond: (nodeslogical.nl_id = wifiaeroscouttagsassignmenthistory.watah_nl_id)
5. 0.005 0.005 ↑ 200.0 1 1

Seq Scan on nodeslogical (cost=0.00..12.00 rows=200 width=76) (actual time=0.005..0.005 rows=1 loops=1)

6. 0.001 0.011 ↑ 8.0 1 1

Hash (cost=14.32..14.32 rows=8 width=18) (actual time=0.011..0.011 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.006 0.010 ↑ 8.0 1 1

Bitmap Heap Scan on wifiaeroscouttagsassignmenthistory (cost=4.19..14.32 rows=8 width=18) (actual time=0.010..0.010 rows=1 loops=1)

  • Recheck Cond: (watah_end IS NULL)
  • Heap Blocks: exact=1
8. 0.004 0.004 ↑ 8.0 1 1

Bitmap Index Scan on watah_unique_active_logical (cost=0.00..4.18 rows=8 width=0) (actual time=0.004..0.004 rows=1 loops=1)

9. 0.016 0.016 ↑ 1.0 1 1

Index Only Scan using nodesphysical_pkey on nodesphysical (cost=0.14..0.40 rows=1 width=4) (actual time=0.016..0.016 rows=1 loops=1)

  • Index Cond: (np_id = nodeslogical.nl_np_id)
  • Heap Fetches: 1
10. 0.006 0.006 ↑ 1.0 1 1

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

  • Index Cond: (e_id = nodeslogical.nl_e_id)
11. 0.005 0.020 ↑ 1.0 32 1

Hash (cost=1.32..1.32 rows=32 width=6) (actual time=0.020..0.020 rows=32 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
12. 0.015 0.015 ↑ 1.0 32 1

Seq Scan on wifiaeroscouttags (cost=0.00..1.32 rows=32 width=6) (actual time=0.012..0.015 rows=32 loops=1)

  • Filter: (wat_active IS TRUE)