explain.depesz.com

PostgreSQL's explain analyze made readable

Result: z7uo

Settings
# exclusive inclusive rows x rows loops node
1. 18.456 1,434.508 ↑ 1.7 29,056 1

Hash Left Join (cost=429.11..31,082.91 rows=50,452 width=302) (actual time=10.175..1,434.508 rows=29,056 loops=1)

  • Hash Cond: ((lc.mid = lcu.midcontract) AND (c.mid = lcu.midcrop))
2. 10.962 1,416.024 ↑ 1.7 29,056 1

Hash Left Join (cost=428.39..30,577.53 rows=50,452 width=313) (actual time=10.138..1,416.024 rows=29,056 loops=1)

  • Hash Cond: ((au.myear = lc.myear) AND (l.mid = lc.midlayer))
3. 10.675 1,405.027 ↑ 1.7 29,056 1

Hash Left Join (cost=427.45..30,068.88 rows=50,452 width=301) (actual time=10.095..1,405.027 rows=29,056 loops=1)

  • Hash Cond: (f.mregion = r.mid)
4. 17.687 1,394.314 ↑ 1.7 29,056 1

Hash Join (cost=426.65..29,811.35 rows=50,452 width=270) (actual time=10.049..1,394.314 rows=29,056 loops=1)

  • Hash Cond: (au.mcrops = c.mid)
5. 30.527 1,371.157 ↑ 1.7 29,056 1

Hash Join (cost=235.49..28,926.48 rows=50,452 width=245) (actual time=4.552..1,371.157 rows=29,056 loops=1)

  • Hash Cond: (f.mlayer = l.mid)
6. 111.330 1,336.170 ↑ 1.0 74,707 1

Merge Join (cost=93.18..27,991.10 rows=76,944 width=76) (actual time=0.061..1,336.170 rows=74,707 loops=1)

  • Merge Cond: (f.mid = au.mfeature)
7. 1,089.865 1,089.865 ↑ 1.0 546,110 1

Index Scan using vsxfeature_pkey on vsxfeature f (cost=0.42..17,098.13 rows=546,134 width=56) (actual time=0.014..1,089.865 rows=546,110 loops=1)

  • Filter: (NOT is_deleted)
8. 134.975 134.975 ↑ 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=36) (actual time=0.013..134.975 rows=74,707 loops=1)

  • Index Cond: ((myear = 2019) AND (is_deleted = false))
  • Filter: (NOT is_deleted)
  • Heap Fetches: 74715
9. 1.594 4.460 ↑ 1.0 3,110 1

Hash (cost=103.44..103.44 rows=3,110 width=185) (actual time=4.460..4.460 rows=3,110 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 395kB
10. 1.747 2.866 ↑ 1.0 3,110 1

Hash Left Join (cost=0.88..103.44 rows=3,110 width=185) (actual time=0.049..2.866 rows=3,110 loops=1)

  • Hash Cond: (l.mcluster = cl.mid)
11. 1.094 1.094 ↑ 1.0 3,110 1

Index Scan using ind_fk_vsxlayers_mowner on vsxlayers l (cost=0.28..71.00 rows=3,110 width=165) (actual time=0.019..1.094 rows=3,110 loops=1)

  • Index Cond: (mowner = '79610a40-aeaa-4bff-a9d6-5444a5aa94c9'::uuid)
12. 0.012 0.025 ↑ 1.0 22 1

Hash (cost=0.32..0.32 rows=22 width=36) (actual time=0.025..0.025 rows=22 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
13. 0.013 0.013 ↑ 1.0 22 1

Seq Scan on clusters cl (cost=0.00..0.32 rows=22 width=36) (actual time=0.009..0.013 rows=22 loops=1)

14. 1.294 5.470 ↑ 1.0 3,221 1

Hash (cost=150.90..150.90 rows=3,221 width=41) (actual time=5.470..5.470 rows=3,221 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 265kB
15. 1.856 4.176 ↑ 1.0 3,221 1

Hash Join (cost=68.70..150.90 rows=3,221 width=41) (actual time=1.835..4.176 rows=3,221 loops=1)

  • Hash Cond: (c.mstyle = s.mid)
16. 0.532 0.532 ↑ 1.0 3,221 1

Seq Scan on crops c (cost=0.00..37.91 rows=3,221 width=50) (actual time=0.017..0.532 rows=3,221 loops=1)

17. 0.902 1.788 ↑ 1.0 2,871 1

Hash (cost=32.81..32.81 rows=2,871 width=23) (actual time=1.788..1.788 rows=2,871 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 187kB
18. 0.886 0.886 ↑ 1.0 2,871 1

Seq Scan on vsxstyles s (cost=0.00..32.81 rows=2,871 width=23) (actual time=0.009..0.886 rows=2,871 loops=1)

19. 0.024 0.038 ↑ 1.0 31 1

Hash (cost=0.41..0.41 rows=31 width=35) (actual time=0.038..0.038 rows=31 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
20. 0.014 0.014 ↑ 1.0 31 1

Seq Scan on regions r (cost=0.00..0.41 rows=31 width=35) (actual time=0.010..0.014 rows=31 loops=1)

21. 0.015 0.035 ↓ 1.0 31 1

Hash (cost=0.49..0.49 rows=30 width=36) (actual time=0.035..0.035 rows=31 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
22. 0.020 0.020 ↓ 1.0 31 1

Seq Scan on leasecontracts lc (cost=0.00..0.49 rows=30 width=36) (actual time=0.010..0.020 rows=31 loops=1)

  • Filter: (myear = 2019)
  • Rows Removed by Filter: 1
23. 0.014 0.028 ↓ 1.1 28 1

Hash (cost=0.35..0.35 rows=25 width=40) (actual time=0.028..0.028 rows=28 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
24. 0.014 0.014 ↓ 1.1 28 1

Seq Scan on leasecontractunits lcu (cost=0.00..0.35 rows=25 width=40) (actual time=0.007..0.014 rows=28 loops=1)

Planning time : 4.872 ms
Execution time : 1,436.430 ms