explain.depesz.com

PostgreSQL's explain analyze made readable

Result: es6D

Settings
# exclusive inclusive rows x rows loops node
1. 8.112 1,053.167 ↑ 1.7 29,056 1

Hash Left Join (cost=21,755.31..28,595.73 rows=50,418 width=306) (actual time=786.785..1,053.167 rows=29,056 loops=1)

  • Hash Cond: (f.mregion = r.mid)
2. 12.499 1,045.003 ↑ 1.7 29,056 1

Hash Join (cost=21,754.52..28,335.53 rows=50,418 width=267) (actual time=786.717..1,045.003 rows=29,056 loops=1)

  • Hash Cond: (au.mcrops = c.mid)
3. 22.162 1,030.564 ↑ 1.7 29,056 1

Hash Join (cost=21,676.34..27,564.11 rows=50,418 width=249) (actual time=784.762..1,030.564 rows=29,056 loops=1)

  • Hash Cond: (f.mlayer = l.mid)
4. 162.175 1,003.172 ↑ 1.0 74,685 1

Hash Join (cost=21,516.40..26,611.64 rows=76,892 width=72) (actual time=779.493..1,003.172 rows=74,685 loops=1)

  • Hash Cond: (au.mfeature = f.mid)
5. 64.490 64.490 ↑ 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=32) (actual time=0.029..64.490 rows=74,685 loops=1)

  • Index Cond: ((myear = 2,019) AND (mcurrent = true))
  • Filter: mcurrent
6. 264.742 776.507 ↑ 1.0 546,110 1

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

  • Buckets: 524,288 Batches: 2 Memory Usage: 26,989kB
7. 511.765 511.765 ↑ 1.0 546,110 1

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

  • Filter: (NOT is_deleted)
8. 1.480 5.230 ↑ 1.0 3,110 1

Hash (cost=121.07..121.07 rows=3,110 width=193) (actual time=5.230..5.230 rows=3,110 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 396kB
9. 1.412 3.750 ↑ 1.0 3,110 1

Hash Left Join (cost=2.75..121.07 rows=3,110 width=193) (actual time=0.124..3.750 rows=3,110 loops=1)

  • Hash Cond: (l.mcluster = cl.mid)
10. 1.123 2.317 ↑ 1.0 3,110 1

Hash Left Join (cost=2.16..88.63 rows=3,110 width=173) (actual time=0.098..2.317 rows=3,110 loops=1)

  • Hash Cond: (l.mid = lc.midlayer)
11. 1.125 1.125 ↑ 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.023..1.125 rows=3,110 loops=1)

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

Hash (cost=1.50..1.50 rows=30 width=24) (actual time=0.069..0.069 rows=30 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
13. 0.016 0.057 ↑ 1.0 30 1

Hash Left Join (cost=0.66..1.50 rows=30 width=24) (actual time=0.038..0.057 rows=30 loops=1)

  • Hash Cond: (lc.mid = lcu.midcontract)
14. 0.021 0.021 ↑ 1.0 30 1

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

  • Filter: (myear = 2,019)
  • Rows Removed by Filter: 1
15. 0.007 0.020 ↑ 1.0 25 1

Hash (cost=0.35..0.35 rows=25 width=24) (actual time=0.020..0.020 rows=25 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
16. 0.013 0.013 ↑ 1.0 25 1

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

17. 0.011 0.021 ↑ 1.0 22 1

Hash (cost=0.32..0.32 rows=22 width=36) (actual time=0.021..0.021 rows=22 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
18. 0.010 0.010 ↑ 1.0 22 1

Seq Scan on clusters cl (cost=0.00..0.32 rows=22 width=36) (actual time=0.006..0.010 rows=22 loops=1)

19. 1.084 1.940 ↑ 1.0 3,221 1

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

  • Buckets: 4,096 Batches: 1 Memory Usage: 243kB
20. 0.856 0.856 ↑ 1.0 3,221 1

Seq Scan on crops c (cost=0.00..37.91 rows=3,221 width=34) (actual time=0.018..0.856 rows=3,221 loops=1)

21. 0.026 0.052 ↑ 1.0 31 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
22. 0.026 0.026 ↑ 1.0 31 1

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

Planning time : 3.675 ms
Execution time : 1,058.779 ms