explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QWsX

Settings
# exclusive inclusive rows x rows loops node
1. 7.409 743.442 ↑ 1.7 29,056 1

Hash Left Join (cost=16,396.85..28,865.93 rows=50,418 width=298) (actual time=496.182..743.442 rows=29,056 loops=1)

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

Hash Left Join (cost=16,395.66..28,486.48 rows=50,418 width=306) (actual time=496.148..736.007 rows=29,056 loops=1)

  • Hash Cond: (f.mregion = r.mid)
3. 11.089 728.062 ↑ 1.7 29,056 1

Hash Join (cost=16,394.37..28,228.63 rows=50,418 width=275) (actual time=496.103..728.062 rows=29,056 loops=1)

  • Hash Cond: (au.mcrops = c.mid)
4. 20.356 712.863 ↑ 1.7 29,056 1

Hash Join (cost=16,298.31..27,439.32 rows=50,418 width=257) (actual time=491.976..712.863 rows=29,056 loops=1)

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

Hash Join (cost=16,138.46..26,486.95 rows=76,892 width=72) (actual time=486.885..687.430 rows=74,685 loops=1)

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

Index Only Scan using agricultureusing_curr_year_delete on agricultureusing au (cost=0.42..8,653.05 rows=76,892 width=32) (actual time=0.013..80.054 rows=74,685 loops=1)

  • Index Cond: ((myear = 2019) AND (mcurrent = true))
  • Filter: mcurrent
  • Heap Fetches: 74685
7. 211.816 484.368 ↑ 1.0 546,110 1

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

  • Buckets: 524288 Batches: 2 Memory Usage: 27747kB
8. 272.552 272.552 ↑ 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.013..272.552 rows=546,110 loops=1)

  • Heap Fetches: 0
9. 1.498 5.077 ↑ 1.0 3,110 1

Hash (cost=120.98..120.98 rows=3,110 width=201) (actual time=5.077..5.077 rows=3,110 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 396kB
10. 0.777 3.579 ↑ 1.0 3,110 1

Hash Left Join (cost=2.66..120.98 rows=3,110 width=201) (actual time=0.080..3.579 rows=3,110 loops=1)

  • Hash Cond: (l.mid = lc.midlayer)
11. 1.685 2.774 ↑ 1.0 3,110 1

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

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

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

Hash (cost=0.77..0.77 rows=22 width=36) (actual time=0.023..0.023 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. 0.010 0.028 ↑ 1.0 30 1

Hash (cost=0.96..0.96 rows=30 width=32) (actual time=0.028..0.028 rows=30 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
16. 0.018 0.018 ↑ 1.0 30 1

Index Scan using leasecontracts_idx_myear on leasecontracts lc (cost=0.14..0.96 rows=30 width=32) (actual time=0.006..0.018 rows=30 loops=1)

  • Index Cond: (myear = 2019)
17. 1.269 4.110 ↑ 1.0 3,221 1

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

  • Buckets: 4096 Batches: 1 Memory Usage: 243kB
18. 2.841 2.841 ↑ 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.841 rows=3,221 loops=1)

19. 0.018 0.032 ↑ 1.0 31 1

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

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

21. 0.012 0.026 ↑ 1.0 25 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
22. 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.146 ms
Execution time : 748.318 ms