explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dUZ0

Settings
# exclusive inclusive rows x rows loops node
1. 0.659 4.343 ↑ 1.0 1,231 1

Hash Left Join (cost=59.86..360.78 rows=1,231 width=362) (actual time=1.906..4.343 rows=1,231 loops=1)

  • Hash Cond: ((a.rbroj)::text = (c.redni_broj_zgrade)::text)
  • Buffers: shared hit=49
2. 1.375 3.595 ↑ 1.0 1,231 1

Hash Left Join (cost=57.49..353.77 rows=1,231 width=332) (actual time=1.808..3.595 rows=1,231 loops=1)

  • Hash Cond: ((a.rbroj)::text = (b.redni_broj_zgrade)::text)
  • Buffers: shared hit=48
3. 0.457 0.701 ↑ 1.0 1,231 1

Bitmap Heap Scan on dyn_rbz a (cost=17.79..309.10 rows=1,231 width=279) (actual time=0.267..0.701 rows=1,231 loops=1)

  • Recheck Cond: (rbroj IS NOT NULL)
  • Buffers: shared hit=36
4. 0.244 0.244 ↑ 1.0 1,231 1

Bitmap Index Scan on dyn_rbz_rbroj_idx (cost=0.00..17.48 rows=1,231 width=0) (actual time=0.244..0.244 rows=1,231 loops=1)

  • Index Cond: (rbroj IS NOT NULL)
  • Buffers: shared hit=5
5. 0.811 1.519 ↑ 1.0 1,231 1

Hash (cost=24.31..24.31 rows=1,231 width=57) (actual time=1.519..1.519 rows=1,231 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 63kB
  • Buffers: shared hit=12
6. 0.708 0.708 ↑ 1.0 1,231 1

Seq Scan on dyn_2a b (cost=0.00..24.31 rows=1,231 width=57) (actual time=0.013..0.708 rows=1,231 loops=1)

  • Buffers: shared hit=12
7. 0.058 0.089 ↑ 1.0 61 1

Hash (cost=1.61..1.61 rows=61 width=33) (actual time=0.089..0.089 rows=61 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 4kB
  • Buffers: shared hit=1
8. 0.031 0.031 ↑ 1.0 61 1

Seq Scan on dyn_2c c (cost=0.00..1.61 rows=61 width=33) (actual time=0.007..0.031 rows=61 loops=1)

  • Buffers: shared hit=1