explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gHwI : 5

Settings
# exclusive inclusive rows x rows loops node
1. 10.261 1,241.470 ↑ 1.6 29,056 1

Hash Left Join (cost=36,407.60..45,960.07 rows=47,686 width=812) (actual time=893.629..1,241.470 rows=29,056 loops=1)

  • Hash Cond: ((lc.mid = lcu.midcontract) AND (c.mid = lcu.midcrop))
2. 11.501 1,231.113 ↑ 1.6 29,056 1

Hash Left Join (cost=36,404.97..45,599.68 rows=47,686 width=804) (actual time=893.508..1,231.113 rows=29,056 loops=1)

  • Hash Cond: ((au.myear = lc.myear) AND (l.mid = lc.midlayer))
3. 10.034 1,219.515 ↑ 1.6 29,056 1

Hash Left Join (cost=36,403.44..45,237.47 rows=47,686 width=792) (actual time=893.392..1,219.515 rows=29,056 loops=1)

  • Hash Cond: (f.mregion = r.mid)
4. 17.548 1,209.400 ↑ 1.6 29,056 1

Hash Join (cost=36,399.29..44,989.19 rows=47,686 width=276) (actual time=893.273..1,209.400 rows=29,056 loops=1)

  • Hash Cond: (au.mcrops = c.mid)
5. 24.796 1,186.314 ↑ 1.6 29,056 1

Hash Join (cost=36,206.83..44,141.05 rows=47,686 width=251) (actual time=887.703..1,186.314 rows=29,056 loops=1)

  • Hash Cond: (f.mlayer = l.mid)
6. 193.250 1,156.965 ↓ 1.0 74,707 1

Hash Join (cost=36,068.14..43,252.76 rows=72,732 width=76) (actual time=881.949..1,156.965 rows=74,707 loops=1)

  • Hash Cond: (au.mfeature = f.mid)
7. 84.431 84.431 ↓ 1.0 74,707 1

Index Scan using agricultureusing_curr_year_delete on agricultureusing au (cost=0.42..5,538.36 rows=72,817 width=36) (actual time=0.016..84.431 rows=74,707 loops=1)

  • Index Cond: ((myear = 2019) AND (is_deleted = false))
  • Filter: (NOT is_deleted)
8. 278.519 879.284 ↓ 1.0 546,110 1

Hash (cost=28,720.08..28,720.08 rows=545,211 width=56) (actual time=879.284..879.284 rows=546,110 loops=1)

  • Buckets: 524288 Batches: 2 Memory Usage: 27747kB
9. 600.765 600.765 ↓ 1.0 546,110 1

Seq Scan on vsxfeature f (cost=0.00..28,720.08 rows=545,211 width=56) (actual time=0.014..600.765 rows=546,110 loops=1)

  • Filter: (NOT is_deleted)
10. 1.613 4.553 ↓ 1.0 3,110 1

Hash (cost=100.03..100.03 rows=3,092 width=191) (actual time=4.553..4.553 rows=3,110 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 395kB
11. 1.783 2.940 ↓ 1.0 3,110 1

Hash Left Join (cost=0.56..100.03 rows=3,092 width=191) (actual time=0.061..2.940 rows=3,110 loops=1)

  • Hash Cond: (l.mcluster = cl.mid)
12. 1.128 1.128 ↓ 1.0 3,110 1

Index Scan using ind_fk_vsxlayers_mowner on vsxlayers l (cost=0.28..79.19 rows=3,092 width=166) (actual time=0.019..1.128 rows=3,110 loops=1)

  • Index Cond: (mowner = '79610a40-aeaa-4bff-a9d6-5444a5aa94c9'::uuid)
13. 0.013 0.029 ↓ 2.8 22 1

Hash (cost=0.18..0.18 rows=8 width=41) (actual time=0.029..0.029 rows=22 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
14. 0.016 0.016 ↓ 2.8 22 1

Seq Scan on clusters cl (cost=0.00..0.18 rows=8 width=41) (actual time=0.011..0.016 rows=22 loops=1)

15. 1.312 5.538 ↑ 1.0 3,221 1

Hash (cost=152.15..152.15 rows=3,225 width=41) (actual time=5.538..5.538 rows=3,221 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 265kB
16. 1.859 4.226 ↑ 1.0 3,221 1

Hash Join (cost=69.65..152.15 rows=3,225 width=41) (actual time=1.862..4.226 rows=3,221 loops=1)

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

Seq Scan on crops c (cost=0.00..38.15 rows=3,225 width=50) (actual time=0.019..0.554 rows=3,221 loops=1)

18. 0.896 1.813 ↑ 1.0 2,871 1

Hash (cost=33.29..33.29 rows=2,909 width=23) (actual time=1.813..1.813 rows=2,871 loops=1)

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

Seq Scan on vsxstyles s (cost=0.00..33.29 rows=2,909 width=23) (actual time=0.011..0.917 rows=2,871 loops=1)

20. 0.042 0.081 ↑ 4.5 31 1

Hash (cost=2.40..2.40 rows=140 width=520) (actual time=0.081..0.081 rows=31 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
21. 0.039 0.039 ↑ 4.5 31 1

Seq Scan on regions r (cost=0.00..2.40 rows=140 width=520) (actual time=0.025..0.039 rows=31 loops=1)

22. 0.033 0.097 ↑ 1.0 30 1

Hash (cost=1.09..1.09 rows=30 width=36) (actual time=0.097..0.097 rows=30 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
23. 0.064 0.064 ↑ 1.0 30 1

Seq Scan on leasecontracts lc (cost=0.00..1.09 rows=30 width=36) (actual time=0.018..0.064 rows=30 loops=1)

  • Filter: (myear = 2019)
  • Rows Removed by Filter: 1
24. 0.031 0.096 ↑ 1.0 25 1

Hash (cost=2.25..2.25 rows=25 width=40) (actual time=0.096..0.096 rows=25 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
25. 0.065 0.065 ↑ 1.0 25 1

Seq Scan on leasecontractunits lcu (cost=0.00..2.25 rows=25 width=40) (actual time=0.016..0.065 rows=25 loops=1)

Planning time : 4.754 ms
Execution time : 1,250.761 ms