explain.depesz.com

PostgreSQL's explain analyze made readable

Result: N03

Settings
# exclusive inclusive rows x rows loops node
1. 17.215 772.958 ↑ 1.8 29,056 1

Hash Left Join (cost=403.08..26,388.08 rows=53,021 width=318) (actual time=10.863..772.958 rows=29,056 loops=1)

  • Hash Cond: ((lc.mid = lcu.midcontract) AND (c.mid = lcu.midcrop))
2. 10.399 755.717 ↑ 1.8 29,056 1

Hash Left Join (cost=402.36..25,857.01 rows=53,021 width=313) (actual time=10.826..755.717 rows=29,056 loops=1)

  • Hash Cond: ((au.myear = lc.myear) AND (l.mid = lc.midlayer))
3. 10.605 745.284 ↑ 1.8 29,056 1

Hash Left Join (cost=401.42..25,322.51 rows=53,021 width=301) (actual time=10.784..745.284 rows=29,056 loops=1)

  • Hash Cond: (vf.mregion = r.mid)
4. 17.481 734.636 ↑ 1.8 29,056 1

Hash Join (cost=400.58..25,051.86 rows=53,021 width=270) (actual time=10.726..734.636 rows=29,056 loops=1)

  • Hash Cond: (au.mcrops = c.mid)
5. 25.833 711.856 ↑ 1.8 29,056 1

Hash Join (cost=208.95..24,131.19 rows=53,021 width=245) (actual time=5.413..711.856 rows=29,056 loops=1)

  • Hash Cond: (vf.mlayer = l.mid)
6. 111.541 680.824 ↑ 1.1 74,555 1

Merge Join (cost=66.63..23,155.43 rows=80,862 width=76) (actual time=0.158..680.824 rows=74,555 loops=1)

  • Merge Cond: (au.mfeature = vf.mid)
7. 117.953 117.953 ↑ 1.1 74,555 1

Index Only Scan using agricultureusing_curr_year_delete on agricultureusing au (cost=0.42..9,106.24 rows=80,862 width=36) (actual time=0.051..117.953 rows=74,555 loops=1)

  • Index Cond: ((myear = 2019) AND (is_deleted = false))
  • Filter: (NOT is_deleted)
  • Heap Fetches: 74555
8. 451.330 451.330 ↑ 1.0 535,411 1

Index Only Scan using ind_vsxfeature_complex on vsxfeature vf (cost=0.55..11,743.95 rows=554,766 width=56) (actual time=0.035..451.330 rows=535,411 loops=1)

  • Index Cond: (is_deleted = false)
  • Filter: (NOT is_deleted)
  • Heap Fetches: 51433
9. 1.403 5.199 ↑ 1.0 3,110 1

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

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

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

  • Hash Cond: (l.mcluster = cl.mid)
11. 1.136 1.136 ↑ 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.084..1.136 rows=3,110 loops=1)

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

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

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

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

14. 1.201 5.299 ↑ 1.0 3,234 1

Hash (cost=151.21..151.21 rows=3,234 width=41) (actual time=5.299..5.299 rows=3,234 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 266kB
15. 1.832 4.098 ↑ 1.0 3,234 1

Hash Join (cost=68.70..151.21 rows=3,234 width=41) (actual time=1.721..4.098 rows=3,234 loops=1)

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

Seq Scan on crops c (cost=0.00..38.04 rows=3,234 width=50) (actual time=0.017..0.575 rows=3,234 loops=1)

17. 0.818 1.691 ↑ 1.0 2,871 1

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

  • Buckets: 4096 Batches: 1 Memory Usage: 187kB
18. 0.873 0.873 ↑ 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.873 rows=2,871 loops=1)

19. 0.014 0.043 ↑ 1.0 33 1

Hash (cost=0.43..0.43 rows=33 width=35) (actual time=0.043..0.043 rows=33 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
20. 0.029 0.029 ↑ 1.0 33 1

Seq Scan on regions r (cost=0.00..0.43 rows=33 width=35) (actual time=0.022..0.029 rows=33 loops=1)

21. 0.013 0.034 ↓ 1.0 31 1

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

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

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

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

Hash (cost=0.35..0.35 rows=25 width=40) (actual time=0.026..0.026 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 : 5.310 ms
Execution time : 774.255 ms