explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l40u

Settings
# exclusive inclusive rows x rows loops node
1. 7.359 1,027.037 ↑ 1.7 29,056 1

Hash Left Join (cost=16,285.11..23,424.71 rows=50,418 width=272) (actual time=747.082..1,027.037 rows=29,056 loops=1)

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

Hash Left Join (cost=16,283.93..22,950.62 rows=50,418 width=288) (actual time=747.038..1,019.642 rows=29,056 loops=1)

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

Hash Left Join (cost=16,282.51..22,441.84 rows=50,418 width=276) (actual time=746.985..1,011.189 rows=29,056 loops=1)

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

Hash Join (cost=16,281.22..22,183.99 rows=50,418 width=245) (actual time=746.922..1,003.678 rows=29,056 loops=1)

  • Hash Cond: (f.mlayer = l.mid)
5. 168.271 979.133 ↑ 1.0 74,685 1

Hash Join (cost=16,138.46..21,248.70 rows=76,892 width=76) (actual time=744.468..979.133 rows=74,685 loops=1)

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

  • Index Cond: ((myear = 2019) AND (mcurrent = true))
  • Filter: mcurrent
7. 400.020 742.538 ↑ 1.0 546,110 1

Hash (cost=8,777.96..8,777.96 rows=546,134 width=56) (actual time=742.538..742.538 rows=546,110 loops=1)

  • Buckets: 524288 Batches: 2 Memory Usage: 26989kB
8. 342.518 342.518 ↑ 1.0 546,110 1

Index Only Scan using ind_vsxfeature_complex on vsxfeature f (cost=0.55..8,777.96 rows=546,134 width=56) (actual time=0.053..342.518 rows=546,110 loops=1)

  • Heap Fetches: 0
9. 0.780 2.416 ↑ 1.0 3,110 1

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

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

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

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

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

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

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

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

14. 0.028 0.048 ↑ 1.0 31 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
15. 0.020 0.020 ↑ 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.020 rows=31 loops=1)

16. 0.021 0.044 ↑ 1.0 30 1

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

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

  • Index Cond: (myear = 2019)
18. 0.019 0.036 ↑ 1.0 25 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
19. 0.017 0.017 ↑ 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.017 rows=25 loops=1)

Planning time : 1.654 ms
Execution time : 1,031.090 ms