explain.depesz.com

PostgreSQL's explain analyze made readable

Result: K9iW

Settings
# exclusive inclusive rows x rows loops node
1. 10.245 1,303.721 ↑ 1.7 29,056 1

Hash Left Join (cost=9,990.91..31,160.63 rows=50,418 width=306) (actual time=123.823..1,303.721 rows=29,056 loops=1)

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

Hash Join (cost=9,989.62..30,902.83 rows=50,418 width=267) (actual time=123.706..1,293.378 rows=29,056 loops=1)

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

Hash Join (cost=9,893.56..30,113.53 rows=50,418 width=249) (actual time=119.550..1,274.978 rows=29,056 loops=1)

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

Merge Join (cost=9,732.50..29,159.94 rows=76,892 width=72) (actual time=113.110..1,241.984 rows=74,685 loops=1)

  • Merge Cond: (f.mid = au.mfeature)
5. 1,006.181 1,006.181 ↓ 1.0 546,110 1

Index Scan using vsxfeature_pkey on vsxfeature f (cost=0.42..17,094.34 rows=545,881 width=56) (actual time=0.047..1,006.181 rows=546,110 loops=1)

6. 75.868 133.687 ↑ 1.0 74,685 1

Sort (cost=9,639.80..9,832.03 rows=76,892 width=32) (actual time=113.027..133.687 rows=74,685 loops=1)

  • Sort Key: au.mfeature
  • Sort Method: quicksort Memory: 8907kB
7. 57.819 57.819 ↑ 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.028..57.819 rows=74,685 loops=1)

  • Index Cond: ((myear = 2019) AND (mcurrent = true))
  • Filter: mcurrent
8. 1.808 6.406 ↑ 1.0 3,110 1

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

  • Buckets: 4096 Batches: 1 Memory Usage: 396kB
9. 1.621 4.598 ↑ 1.0 3,110 1

Hash Left Join (cost=3.87..122.18 rows=3,110 width=193) (actual time=0.137..4.598 rows=3,110 loops=1)

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

Hash Left Join (cost=2.83..89.30 rows=3,110 width=173) (actual time=0.104..2.953 rows=3,110 loops=1)

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

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

Hash (cost=2.17..2.17 rows=30 width=24) (actual time=0.076..0.076 rows=30 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
13. 0.032 0.063 ↑ 1.0 30 1

Merge Left Join (cost=0.28..2.17 rows=30 width=24) (actual time=0.020..0.063 rows=30 loops=1)

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

Index Scan using leasecontracts_pkey on leasecontracts lc (cost=0.14..0.98 rows=30 width=32) (actual time=0.007..0.022 rows=30 loops=1)

  • Filter: (myear = 2019)
  • Rows Removed by Filter: 1
15. 0.009 0.009 ↑ 1.0 25 1

Index Scan using leasecontractunits_idx on leasecontractunits lcu (cost=0.14..0.81 rows=25 width=24) (actual time=0.002..0.009 rows=25 loops=1)

16. 0.012 0.024 ↑ 1.0 22 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
17. 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)

18. 1.346 4.129 ↑ 1.0 3,221 1

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

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

20. 0.013 0.098 ↑ 1.0 31 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
21. 0.085 0.085 ↑ 1.0 31 1

Index Scan using regions_pkey on regions r (cost=0.14..0.90 rows=31 width=35) (actual time=0.079..0.085 rows=31 loops=1)

Planning time : 4.157 ms
Execution time : 1,306.273 ms