explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MaPK : 1

Settings
# exclusive inclusive rows x rows loops node
1. 8.613 1,758.409 ↑ 1.6 29,056 1

Hash Left Join (cost=36,318.41..45,876.18 rows=47,742 width=797) (actual time=1,439.327..1,758.409 rows=29,056 loops=1)

  • Hash Cond: ((lc.mid = lcu.midcontract) AND (c.mid = lcu.midcrop))
2. 9.998 1,749.570 ↑ 1.6 29,056 1

Hash Left Join (cost=36,315.79..45,515.37 rows=47,742 width=797) (actual time=1,439.086..1,749.570 rows=29,056 loops=1)

  • Hash Cond: ((au.myear = lc.myear) AND (l.mid = lc.midlayer))
3. 8.519 1,739.495 ↑ 1.6 29,056 1

Hash Left Join (cost=36,314.25..45,152.73 rows=47,742 width=785) (actual time=1,438.995..1,739.495 rows=29,056 loops=1)

  • Hash Cond: (f.mregion = r.mid)
4. 13.732 1,730.893 ↑ 1.6 29,056 1

Hash Join (cost=36,310.10..44,903.81 rows=47,742 width=269) (actual time=1,438.829..1,730.893 rows=29,056 loops=1)

  • Hash Cond: (au.mcrops = c.mid)
5. 22.172 1,714.498 ↑ 1.6 29,056 1

Hash Join (cost=36,231.64..44,168.89 rows=47,742 width=251) (actual time=1,436.109..1,714.498 rows=29,056 loops=1)

  • Hash Cond: (f.mlayer = l.mid)
6. 175.921 1,686.994 ↓ 1.0 74,707 1

Hash Join (cost=36,092.95..43,279.72 rows=72,817 width=76) (actual time=1,429.392..1,686.994 rows=74,707 loops=1)

  • Hash Cond: (au.mfeature = f.mid)
7. 84.472 84.472 ↓ 1.0 74,707 1

Index Scan using agricultureusing_curr_year_delete on agricultureusing au (cost=0.42..5,538.36 rows=72,817 width=36) (actual time=0.063..84.472 rows=74,707 loops=1)

  • Index Cond: ((myear = 2019) AND (is_deleted = false))
  • Filter: (NOT is_deleted)
8. 268.554 1,426.601 ↑ 1.0 546,055 1

Hash (cost=28,726.99..28,726.99 rows=546,539 width=56) (actual time=1,426.601..1,426.601 rows=546,055 loops=1)

  • Buckets: 524288 Batches: 2 Memory Usage: 26987kB
9. 1,158.047 1,158.047 ↑ 1.0 546,055 1

Seq Scan on vsxfeature f (cost=0.00..28,726.99 rows=546,539 width=56) (actual time=0.042..1,158.047 rows=546,055 loops=1)

  • Filter: (NOT is_deleted)
  • Rows Removed by Filter: 484
10. 1.606 5.332 ↓ 1.0 3,110 1

Hash (cost=100.03..100.03 rows=3,092 width=191) (actual time=5.332..5.332 rows=3,110 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 395kB
11. 1.889 3.726 ↓ 1.0 3,110 1

Hash Left Join (cost=0.56..100.03 rows=3,092 width=191) (actual time=0.121..3.726 rows=3,110 loops=1)

  • Hash Cond: (l.mcluster = cl.mid)
12. 1.805 1.805 ↓ 1.0 3,110 1

Index Scan using ind_fk_vsxlayers_mowner on vsxlayers l (cost=0.28..79.19 rows=3,092 width=166) (actual time=0.074..1.805 rows=3,110 loops=1)

  • Index Cond: (mowner = '79610a40-aeaa-4bff-a9d6-5444a5aa94c9'::uuid)
13. 0.014 0.032 ↓ 2.8 22 1

Hash (cost=0.18..0.18 rows=8 width=41) (actual time=0.032..0.032 rows=22 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
14. 0.018 0.018 ↓ 2.8 22 1

Seq Scan on clusters cl (cost=0.00..0.18 rows=8 width=41) (actual time=0.012..0.018 rows=22 loops=1)

15. 1.217 2.663 ↓ 1.0 3,226 1

Hash (cost=38.15..38.15 rows=3,225 width=34) (actual time=2.663..2.663 rows=3,226 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 243kB
16. 1.446 1.446 ↓ 1.0 3,226 1

Seq Scan on crops c (cost=0.00..38.15 rows=3,225 width=34) (actual time=0.038..1.446 rows=3,226 loops=1)

17. 0.023 0.083 ↑ 4.5 31 1

Hash (cost=2.40..2.40 rows=140 width=520) (actual time=0.083..0.083 rows=31 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
18. 0.060 0.060 ↑ 4.5 31 1

Seq Scan on regions r (cost=0.00..2.40 rows=140 width=520) (actual time=0.054..0.060 rows=31 loops=1)

19. 0.019 0.077 ↑ 1.0 30 1

Hash (cost=1.09..1.09 rows=30 width=36) (actual time=0.077..0.077 rows=30 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
20. 0.058 0.058 ↑ 1.0 30 1

Seq Scan on leasecontracts lc (cost=0.00..1.09 rows=30 width=36) (actual time=0.013..0.058 rows=30 loops=1)

  • Filter: (myear = 2019)
  • Rows Removed by Filter: 1
21. 0.017 0.226 ↑ 1.0 25 1

Hash (cost=2.25..2.25 rows=25 width=40) (actual time=0.226..0.226 rows=25 loops=1)

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

Seq Scan on leasecontractunits lcu (cost=0.00..2.25 rows=25 width=40) (actual time=0.030..0.209 rows=25 loops=1)

Planning time : 8.922 ms
Execution time : 1,767.321 ms