explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7Q0H

Settings
# exclusive inclusive rows x rows loops node
1. 8.118 877.811 ↑ 1.7 29,056 1

Hash Left Join (cost=16,509.43..24,342.22 rows=50,418 width=305) (actual time=605.472..877.811 rows=29,056 loops=1)

  • Hash Cond: ((lc.mid = lcu.midcontract) AND (au.mcrops = lcu.midcrop))
2. 9.414 869.666 ↑ 1.7 29,056 1

Hash Left Join (cost=16,508.25..23,868.14 rows=50,418 width=313) (actual time=605.438..869.666 rows=29,056 loops=1)

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

Hash Left Join (cost=16,506.83..23,359.36 rows=50,418 width=301) (actual time=605.395..860.216 rows=29,056 loops=1)

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

Hash Join (cost=16,505.54..23,101.56 rows=50,418 width=270) (actual time=605.341..852.514 rows=29,056 loops=1)

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

Hash Join (cost=16,280.56..22,183.33 rows=50,418 width=245) (actual time=595.779..829.370 rows=29,056 loops=1)

  • Hash Cond: (f.mlayer = l.mid)
6. 161.668 805.688 ↑ 1.0 74,685 1

Hash Join (cost=16,137.80..21,248.04 rows=76,892 width=76) (actual time=591.410..805.688 rows=74,685 loops=1)

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

Index Scan using agricultureusing_curr_year_delete on agricultureusing au (cost=0.42..3,399.80 rows=76,892 width=36) (actual time=0.025..55.611 rows=74,685 loops=1)

  • Index Cond: ((myear = 2019) AND (mcurrent = true))
  • Filter: mcurrent
8. 261.820 588.409 ↑ 1.0 546,110 1

Hash (cost=8,777.60..8,777.60 rows=546,110 width=56) (actual time=588.409..588.409 rows=546,110 loops=1)

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

Index Only Scan using ind_vsxfeature_complex on vsxfeature f (cost=0.55..8,777.60 rows=546,110 width=56) (actual time=0.018..326.589 rows=546,110 loops=1)

  • Heap Fetches: 0
10. 1.462 4.332 ↑ 1.0 3,110 1

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

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

Hash Left Join (cost=1.33..103.89 rows=3,110 width=185) (actual time=0.048..2.870 rows=3,110 loops=1)

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

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

Hash (cost=0.77..0.77 rows=22 width=36) (actual time=0.022..0.022 rows=22 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
14. 0.012 0.012 ↑ 1.0 22 1

Index Scan using clusters_pkey on clusters cl (cost=0.14..0.77 rows=22 width=36) (actual time=0.003..0.012 rows=22 loops=1)

15. 1.215 9.547 ↑ 1.0 3,221 1

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

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

Hash Join (cost=84.91..184.72 rows=3,221 width=41) (actual time=3.773..8.332 rows=3,221 loops=1)

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

Index Scan using crops_pkey on crops c (cost=0.28..55.80 rows=3,221 width=50) (actual time=0.010..2.465 rows=3,221 loops=1)

18. 0.874 3.749 ↑ 1.0 2,871 1

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

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

Index Scan using vsxstyle_pkey on vsxstyles s (cost=0.28..48.75 rows=2,871 width=23) (actual time=0.008..2.875 rows=2,871 loops=1)

20. 0.022 0.040 ↑ 1.0 31 1

Hash (cost=0.90..0.90 rows=31 width=35) (actual time=0.040..0.040 rows=31 loops=1)

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

Index Scan using regions_pkey on regions r (cost=0.14..0.90 rows=31 width=35) (actual time=0.007..0.018 rows=31 loops=1)

22. 0.016 0.036 ↑ 1.0 30 1

Hash (cost=0.96..0.96 rows=30 width=36) (actual time=0.036..0.036 rows=30 loops=1)

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

Index Scan using leasecontracts_idx_myear on leasecontracts lc (cost=0.14..0.96 rows=30 width=36) (actual time=0.010..0.020 rows=30 loops=1)

  • Index Cond: (myear = 2019)
24. 0.013 0.027 ↑ 1.0 25 1

Hash (cost=0.81..0.81 rows=25 width=40) (actual time=0.027..0.027 rows=25 loops=1)

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

Index Scan using leasecontractunits_idx on leasecontractunits lcu (cost=0.14..0.81 rows=25 width=40) (actual time=0.005..0.014 rows=25 loops=1)

Planning time : 4.354 ms
Execution time : 882.951 ms