explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yeN9

Settings
# exclusive inclusive rows x rows loops node
1. 13.999 996.369 ↑ 168.7 299 1

HashAggregate (cost=29,824.05..30,454.70 rows=50,452 width=40) (actual time=996.162..996.369 rows=299 loops=1)

  • Group Key: l.mid, c.mid
2. 10.578 982.370 ↑ 1.7 29,056 1

Hash Join (cost=17,585.15..29,319.53 rows=50,452 width=40) (actual time=649.896..982.370 rows=29,056 loops=1)

  • Hash Cond: (au.mcrops = c.mid)
3. 20.787 969.337 ↑ 1.7 29,056 1

Hash Join (cost=17,506.97..28,547.65 rows=50,452 width=40) (actual time=647.411..969.337 rows=29,056 loops=1)

  • Hash Cond: (f.mlayer = l.mid)
4. 142.364 943.990 ↑ 1.0 74,707 1

Hash Join (cost=17,397.09..27,644.71 rows=76,944 width=40) (actual time=642.822..943.990 rows=74,707 loops=1)

  • Hash Cond: (au.mfeature = f.mid)
5. 161.490 161.490 ↑ 1.0 74,707 1

Index Only Scan using agricultureusing_curr_year_delete on agricultureusing au (cost=0.42..8,658.16 rows=76,944 width=32) (actual time=0.137..161.490 rows=74,707 loops=1)

  • Index Cond: ((myear = 2019) AND (is_deleted = false))
  • Filter: (NOT is_deleted)
  • Heap Fetches: 74707
6. 230.059 640.136 ↑ 1.0 546,110 1

Hash (cost=10,143.29..10,143.29 rows=546,134 width=40) (actual time=640.136..640.136 rows=546,110 loops=1)

  • Buckets: 524288 Batches: 2 Memory Usage: 23293kB
7. 410.077 410.077 ↑ 1.0 546,110 1

Index Only Scan using ind_vsxfeature_complex on vsxfeature f (cost=0.55..10,143.29 rows=546,134 width=40) (actual time=0.130..410.077 rows=546,110 loops=1)

  • Index Cond: (is_deleted = false)
  • Filter: (NOT is_deleted)
  • Heap Fetches: 102
8. 1.178 4.560 ↑ 1.0 3,110 1

Hash (cost=71.00..71.00 rows=3,110 width=16) (actual time=4.560..4.560 rows=3,110 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 178kB
9. 3.382 3.382 ↑ 1.0 3,110 1

Index Scan using ind_fk_vsxlayers_mowner on vsxlayers l (cost=0.28..71.00 rows=3,110 width=16) (actual time=0.066..3.382 rows=3,110 loops=1)

  • Index Cond: (mowner = '79610a40-aeaa-4bff-a9d6-5444a5aa94c9'::uuid)
10. 0.915 2.455 ↑ 1.0 3,221 1

Hash (cost=37.91..37.91 rows=3,221 width=16) (actual time=2.455..2.455 rows=3,221 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 183kB
11. 1.540 1.540 ↑ 1.0 3,221 1

Seq Scan on crops c (cost=0.00..37.91 rows=3,221 width=16) (actual time=0.040..1.540 rows=3,221 loops=1)

Planning time : 5.043 ms
Execution time : 1,002.015 ms