explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VhDI : FAST

Settings
# exclusive inclusive rows x rows loops node
1. 167.124 487.005 ↓ 1.0 7,192 1

Hash Left Join (cost=26,122.53..47,748.53 rows=7,179 width=196) (actual time=300.759..487.005 rows=7,192 loops=1)

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

Seq Scan on objekti o (cost=0.00..7,949.81 rows=7,179 width=298) (actual time=0.017..19.540 rows=7,192 loops=1)

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

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

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

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

5. 48.791 280.266 ↓ 378.2 75,649 1

HashAggregate (cost=26,116.03..26,118.03 rows=200 width=52) (actual time=264.340..280.266 rows=75,649 loops=1)

  • Group Key: kk.objekti_id
6. 41.041 231.475 ↓ 1.0 104,876 1

GroupAggregate (cost=16,702.55..24,544.16 rows=104,791 width=40) (actual time=93.444..231.475 rows=104,876 loops=1)

  • Group Key: kk.katovi_id
7. 37.682 190.434 ↓ 1.0 131,722 1

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

  • Merge Cond: (kk.katovi_id = ddd.katovi_id)
8. 29.737 29.737 ↓ 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..29.737 rows=104,876 loops=1)

9. 10.867 123.015 ↑ 1.0 131,721 1

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

10. 90.996 112.148 ↑ 1.0 131,721 1

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

  • Sort Key: ddd.katovi_id
  • Sort Method: external merge Disk: 3344kB
11. 21.152 21.152 ↑ 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..21.152 rows=131,721 loops=1)

Planning time : 0.371 ms
Execution time : 490.404 ms