explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OC1Z : FAST

Settings
# exclusive inclusive rows x rows loops node
1. 13.839 324.534 ↓ 1.0 7,192 1

Hash Left Join (cost=26,122.53..34,269.96 rows=7,179 width=13) (actual time=292.790..324.534 rows=7,192 loops=1)

  • Hash Cond: (o.objekti_id = d.objekti_id)
2. 17.935 17.935 ↓ 1.0 7,192 1

Seq Scan on objekti o (cost=0.00..7,949.81 rows=7,179 width=13) (actual time=0.016..17.935 rows=7,192 loops=1)

  • Filter: (projekti_id = 10)
  • Rows Removed by Filter: 68458
3. 14.228 292.760 ↓ 378.2 75,649 1

Hash (cost=26,120.03..26,120.03 rows=200 width=12) (actual time=292.760..292.760 rows=75,649 loops=1)

  • Buckets: 131072 (originally 1024) Batches: 2 (originally 1) Memory Usage: 3073kB
4. 6.372 278.532 ↓ 378.2 75,649 1

Subquery Scan on d (cost=26,116.03..26,120.03 rows=200 width=12) (actual time=258.049..278.532 rows=75,649 loops=1)

5. 47.522 272.160 ↓ 378.2 75,649 1

HashAggregate (cost=26,116.03..26,118.03 rows=200 width=12) (actual time=258.049..272.160 rows=75,649 loops=1)

  • Group Key: kk.objekti_id
6. 37.164 224.638 ↓ 1.0 104,876 1

GroupAggregate (cost=16,702.55..24,544.16 rows=104,791 width=20) (actual time=90.830..224.638 rows=104,876 loops=1)

  • Group Key: kk.katovi_id
7. 37.880 187.474 ↓ 1.0 131,722 1

Merge Left Join (cost=16,702.55..22,837.65 rows=131,721 width=20) (actual time=90.814..187.474 rows=131,722 loops=1)

  • Merge Cond: (kk.katovi_id = ddd.katovi_id)
8. 28.800 28.800 ↓ 1.0 104,876 1

Index Scan using katovi_pkey on katovi kk (cost=0.29..3,592.75 rows=104,791 width=12) (actual time=0.006..28.800 rows=104,876 loops=1)

9. 10.826 120.794 ↑ 1.0 131,721 1

Materialize (cost=16,702.19..17,360.79 rows=131,721 width=16) (actual time=90.804..120.794 rows=131,721 loops=1)

10. 89.163 109.968 ↑ 1.0 131,721 1

Sort (cost=16,702.19..17,031.49 rows=131,721 width=16) (actual time=90.797..109.968 rows=131,721 loops=1)

  • Sort Key: ddd.katovi_id
  • Sort Method: external merge Disk: 3344kB
11. 20.805 20.805 ↑ 1.0 131,721 1

Seq Scan on dijelovi ddd (cost=0.00..3,247.21 rows=131,721 width=16) (actual time=0.008..20.805 rows=131,721 loops=1)

Planning time : 0.313 ms
Execution time : 327.715 ms