explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9cpK

Settings
# exclusive inclusive rows x rows loops node
1. 8.728 920.346 ↑ 1.7 29,056 1

Hash Left Join (cost=16,380.51..24,118.67 rows=50,418 width=306) (actual time=609.275..920.346 rows=29,056 loops=1)

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

Hash Left Join (cost=16,379.32..23,739.22 rows=50,418 width=306) (actual time=609.230..911.581 rows=29,056 loops=1)

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

Hash Left Join (cost=16,377.91..23,230.44 rows=50,418 width=294) (actual time=609.176..902.060 rows=29,056 loops=1)

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

Hash Join (cost=16,376.62..22,972.64 rows=50,418 width=263) (actual time=609.109..893.641 rows=29,056 loops=1)

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

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

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

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

  • Hash Cond: (au.mfeature = f.mid)
7. 65.099 65.099 ↑ 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.026..65.099 rows=74,685 loops=1)

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

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

  • Buckets: 524288 Batches: 2 Memory Usage: 26989kB
9. 335.090 335.090 ↑ 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.015..335.090 rows=546,110 loops=1)

  • Heap Fetches: 0
10. 1.449 4.295 ↑ 1.0 3,110 1

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

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

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

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

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

15. 1.259 4.050 ↑ 1.0 3,221 1

Hash (cost=55.80..55.80 rows=3,221 width=34) (actual time=4.050..4.050 rows=3,221 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 243kB
16. 2.791 2.791 ↑ 1.0 3,221 1

Index Scan using crops_pkey on crops c (cost=0.28..55.80 rows=3,221 width=34) (actual time=0.011..2.791 rows=3,221 loops=1)

17. 0.027 0.049 ↑ 1.0 31 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
18. 0.022 0.022 ↑ 1.0 31 1

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

19. 0.021 0.045 ↑ 1.0 30 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
20. 0.024 0.024 ↑ 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.024 rows=30 loops=1)

  • Index Cond: (myear = 2019)
21. 0.021 0.037 ↑ 1.0 25 1

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

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

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

Planning time : 3.329 ms
Execution time : 925.226 ms