explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UrKE : Optimization for: fahrzeuge; plan #c6dN

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.008 0.022 ↑ 1.0 8 1

Hash Join (cost=1.18..2.29 rows=8 width=17) (actual time=0.020..0.022 rows=8 loops=1)

  • Hash Cond: (f.hid = h.hid)
2. 0.008 0.008 ↑ 1.0 8 1

Seq Scan on fahrzeug f (cost=0.00..1.08 rows=8 width=8) (actual time=0.007..0.008 rows=8 loops=1)

3. 0.003 0.006 ↑ 1.0 8 1

Hash (cost=1.08..1.08 rows=8 width=9) (actual time=0.006..0.006 rows=8 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
4. 0.003 0.003 ↑ 1.0 8 1

Seq Scan on halter h (cost=0.00..1.08 rows=8 width=9) (actual time=0.002..0.003 rows=8 loops=1)