explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wyUb

Settings
# exclusive inclusive rows x rows loops node
1. 9.080 1,081.792 ↑ 1.7 29,056 1

Hash Left Join (cost=21,852.34..29,401.53 rows=50,422 width=321) (actual time=788.845..1,081.792 rows=29,056 loops=1)

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

Hash Left Join (cost=21,851.61..29,022.51 rows=50,422 width=313) (actual time=788.806..1,072.681 rows=29,056 loops=1)

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

Hash Left Join (cost=21,850.67..28,514.16 rows=50,422 width=301) (actual time=788.752..1,062.669 rows=29,056 loops=1)

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

Hash Join (cost=21,849.88..28,253.94 rows=50,422 width=270) (actual time=788.681..1,054.104 rows=29,056 loops=1)

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

Hash Join (cost=21,658.72..27,369.48 rows=50,422 width=245) (actual time=783.165..1,033.691 rows=29,056 loops=1)

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

Hash Join (cost=21,516.40..26,434.58 rows=76,897 width=76) (actual time=778.255..1,007.690 rows=74,707 loops=1)

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

Index Scan using agricultureusing_curr_year_delete on agricultureusing au (cost=0.42..3,207.67 rows=76,897 width=36) (actual time=0.020..52.442 rows=74,707 loops=1)

  • Index Cond: (myear = 2019)
8. 278.957 775.728 ↑ 1.0 546,110 1

Hash (cost=14,156.20..14,156.20 rows=546,110 width=56) (actual time=775.728..775.728 rows=546,110 loops=1)

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

Seq Scan on vsxfeature f (cost=0.00..14,156.20 rows=546,110 width=56) (actual time=0.016..496.771 rows=546,110 loops=1)

10. 1.592 4.456 ↑ 1.0 3,110 1

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

  • Buckets: 4096 Batches: 1 Memory Usage: 395kB
11. 1.743 2.864 ↑ 1.0 3,110 1

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

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

  • Index Cond: (mowner = '79610a40-aeaa-4bff-a9d6-5444a5aa94c9'::uuid)
13. 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
14. 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.008..0.013 rows=22 loops=1)

15. 1.304 5.482 ↑ 1.0 3,221 1

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

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

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

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

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

18. 0.891 1.789 ↑ 1.0 2,871 1

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

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

20. 0.031 0.056 ↑ 1.0 31 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
21. 0.025 0.025 ↑ 1.0 31 1

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

22. 0.020 0.042 ↑ 1.0 30 1

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

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

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

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

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

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

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

Planning time : 4.635 ms
Execution time : 1,089.362 ms