explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WNZ3E

Settings
# exclusive inclusive rows x rows loops node
1. 0.666 4.391 ↑ 1.0 1,231 1

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

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

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

  • Hash Cond: ((a.rbroj)::text = (b.redni_broj_zgrade)::text)
  • Buffers: shared hit=48
3. 0.439 0.681 ↑ 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.265..0.681 rows=1,231 loops=1)

  • Recheck Cond: (rbroj IS NOT NULL)
  • Buffers: shared hit=36
4. 0.242 0.242 ↑ 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.242..0.242 rows=1,231 loops=1)

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

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

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

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

  • Buffers: shared hit=12
7. 0.055 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.034 0.034 ↑ 1.0 61 1

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

  • Buffers: shared hit=1