explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4BrJ

Settings
# exclusive inclusive rows x rows loops node
1. 8.269 1,068.459 ↑ 1.7 29,056 1

Hash Left Join (cost=21,739.35..29,480.40 rows=50,418 width=306) (actual time=783.864..1,068.459 rows=29,056 loops=1)

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

Hash Left Join (cost=21,738.62..29,101.41 rows=50,418 width=306) (actual time=783.821..1,060.159 rows=29,056 loops=1)

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

Hash Left Join (cost=21,737.69..28,593.10 rows=50,418 width=294) (actual time=783.774..1,050.769 rows=29,056 loops=1)

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

Hash Join (cost=21,736.89..28,332.91 rows=50,418 width=263) (actual time=783.711..1,042.418 rows=29,056 loops=1)

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

Hash Join (cost=21,658.72..27,561.49 rows=50,418 width=245) (actual time=781.648..1,026.470 rows=29,056 loops=1)

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

Hash Join (cost=21,516.40..26,626.64 rows=76,892 width=76) (actual time=777.174..1,000.559 rows=74,685 loops=1)

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

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

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

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

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

  • Filter: (NOT is_deleted)
10. 1.560 4.420 ↑ 1.0 3,110 1

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

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

Hash Left Join (cost=0.88..103.44 rows=3,110 width=185) (actual time=0.052..2.860 rows=3,110 loops=1)

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

  • Index Cond: (mowner = '79610a40-aeaa-4bff-a9d6-5444a5aa94c9'::uuid)
13. 0.010 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: 1024 Batches: 1 Memory Usage: 10kB
14. 0.011 0.011 ↑ 1.0 22 1

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

15. 1.204 2.036 ↑ 1.0 3,221 1

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

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

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

17. 0.027 0.047 ↑ 1.0 31 1

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

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

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

19. 0.015 0.035 ↑ 1.0 30 1

Hash (cost=0.49..0.49 rows=30 width=36) (actual time=0.035..0.035 rows=30 loops=1)

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

Seq Scan on leasecontracts lc (cost=0.00..0.49 rows=30 width=36) (actual time=0.010..0.020 rows=30 loops=1)

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

Hash (cost=0.35..0.35 rows=25 width=40) (actual time=0.031..0.031 rows=25 loops=1)

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

Seq Scan on leasecontractunits lcu (cost=0.00..0.35 rows=25 width=40) (actual time=0.008..0.014 rows=25 loops=1)

Planning time : 3.910 ms
Execution time : 1,074.355 ms