explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FIX8

Settings
# exclusive inclusive rows x rows loops node
1. 0.679 5.805 ↑ 1.0 1,231 1

Hash Left Join (cost=42.07..402.78 rows=1,231 width=362) (actual time=1.750..5.805 rows=1,231 loops=1)

  • Hash Cond: ((a.rbroj)::text = (c.redni_broj_zgrade)::text)
  • Buffers: shared hit=292
2. 1.246 5.048 ↑ 1.0 1,231 1

Hash Left Join (cost=39.70..395.77 rows=1,231 width=332) (actual time=1.646..5.048 rows=1,231 loops=1)

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

Seq Scan on dyn_rbz a (cost=0.00..351.10 rows=1,231 width=279) (actual time=0.014..2.193 rows=1,231 loops=1)

  • Filter: (rbroj IS NOT NULL)
  • Buffers: shared hit=279
4. 0.855 1.609 ↑ 1.0 1,231 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 63kB
  • Buffers: shared hit=12
5. 0.754 0.754 ↑ 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.754 rows=1,231 loops=1)

  • Buffers: shared hit=12
6. 0.049 0.078 ↑ 1.0 61 1

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

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

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

  • Buffers: shared hit=1