explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qfJu6 : SLOW

Settings
# exclusive inclusive rows x rows loops node
1. 13,032.526 57,750.023 ↓ 3,423.0 3,423 1

Nested Loop Left Join (cost=26,116.03..34,074.22 rows=1 width=196) (actual time=271.369..57,750.023 rows=3,423 loops=1)

  • Join Filter: (kk.objekti_id = o.objekti_id)
  • Rows Removed by Join Filter: 258943104
2. 19.963 19.963 ↓ 3,423.0 3,423 1

Seq Scan on objekti o (cost=0.00..7,949.81 rows=1 width=298) (actual time=0.260..19.963 rows=3,423 loops=1)

  • Filter: (projekti_id = 14)
  • Rows Removed by Filter: 72227
3. 44,466.526 44,697.534 ↓ 378.2 75,649 3,423

HashAggregate (cost=26,116.03..26,118.03 rows=200 width=52) (actual time=0.077..13.058 rows=75,649 loops=3,423)

  • Group Key: kk.objekti_id
4. 41.439 231.008 ↓ 1.0 104,876 1

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

  • Group Key: kk.katovi_id
5. 37.447 189.569 ↓ 1.0 131,722 1

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

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

7. 10.623 123.795 ↑ 1.0 131,721 1

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

8. 91.790 113.172 ↑ 1.0 131,721 1

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

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

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

Planning time : 0.334 ms