explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MDFx

Settings
# exclusive inclusive rows x rows loops node
1. 7.411 834.420 ↑ 1.7 29,056 1

Hash Left Join (cost=16,300.81..27,668.38 rows=50,418 width=264) (actual time=556.792..834.420 rows=29,056 loops=1)

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

Hash Join (cost=16,299.52..27,410.53 rows=50,418 width=233) (actual time=556.744..826.974 rows=29,056 loops=1)

  • Hash Cond: (f.mlayer = l.mid)
3. 148.884 799.887 ↑ 1.0 74,685 1

Hash Join (cost=16,138.46..26,456.95 rows=76,892 width=56) (actual time=551.503..799.887 rows=74,685 loops=1)

  • Hash Cond: (au.mfeature = f.mid)
4. 102.020 102.020 ↑ 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=16) (actual time=0.014..102.020 rows=74,685 loops=1)

  • Index Cond: ((myear = 2019) AND (mcurrent = true))
  • Filter: mcurrent
  • Heap Fetches: 74685
5. 241.235 548.983 ↑ 1.0 546,110 1

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

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

  • Heap Fetches: 0
7. 1.499 5.227 ↑ 1.0 3,110 1

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

  • Buckets: 4096 Batches: 1 Memory Usage: 396kB
8. 1.419 3.728 ↑ 1.0 3,110 1

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

  • Hash Cond: (l.mcluster = cl.mid)
9. 1.126 2.287 ↑ 1.0 3,110 1

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

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

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
12. 0.022 0.052 ↑ 1.0 30 1

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

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

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

  • Filter: (myear = 2019)
  • Rows Removed by Filter: 1
14. 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)

15. 0.010 0.022 ↑ 1.0 22 1

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

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

17. 0.018 0.035 ↑ 1.0 31 1

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

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

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

Planning time : 2.357 ms
Execution time : 838.513 ms