explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aTxr

Settings
# exclusive inclusive rows x rows loops node
1. 8.045 876.015 ↑ 1.7 29,056 1

Hash Left Join (cost=17,649.73..24,789.61 rows=50,422 width=280) (actual time=594.936..876.015 rows=29,056 loops=1)

  • Hash Cond: ((lc.mid = lcu.midcontract) AND (au.mcrops = lcu.midcrop))
2. 9.027 867.909 ↑ 1.7 29,056 1

Hash Left Join (cost=17,648.54..24,315.49 rows=50,422 width=288) (actual time=594.863..867.909 rows=29,056 loops=1)

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

Hash Left Join (cost=17,647.13..23,806.66 rows=50,422 width=276) (actual time=594.774..858.807 rows=29,056 loops=1)

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

Hash Join (cost=17,645.84..23,548.84 rows=50,422 width=245) (actual time=594.675..850.637 rows=29,056 loops=1)

  • Hash Cond: (f.mlayer = l.mid)
5. 160.579 823.691 ↑ 1.0 74,707 1

Hash Join (cost=17,503.08..22,613.49 rows=76,897 width=76) (actual time=589.736..823.691 rows=74,707 loops=1)

  • Hash Cond: (au.mfeature = f.mid)
6. 75.852 75.852 ↑ 1.0 74,707 1

Index Scan using agricultureusing_curr_year_delete on agricultureusing au (cost=0.42..3,399.91 rows=76,897 width=36) (actual time=0.029..75.852 rows=74,707 loops=1)

  • Index Cond: ((myear = 2019) AND (is_deleted = false))
  • Filter: (NOT is_deleted)
7. 250.497 587.260 ↑ 1.0 546,110 1

Hash (cost=10,142.88..10,142.88 rows=546,110 width=56) (actual time=587.260..587.260 rows=546,110 loops=1)

  • Buckets: 524288 Batches: 2 Memory Usage: 27747kB
8. 336.763 336.763 ↑ 1.0 546,110 1

Index Only Scan using ind_vsxfeature_complex on vsxfeature f (cost=0.55..10,142.88 rows=546,110 width=56) (actual time=0.018..336.763 rows=546,110 loops=1)

  • Index Cond: (is_deleted = false)
  • Filter: (NOT is_deleted)
  • Heap Fetches: 0
9. 1.455 4.298 ↑ 1.0 3,110 1

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

  • Buckets: 4096 Batches: 1 Memory Usage: 395kB
10. 1.724 2.843 ↑ 1.0 3,110 1

Hash Left Join (cost=1.33..103.89 rows=3,110 width=185) (actual time=0.054..2.843 rows=3,110 loops=1)

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

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

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

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

Index Scan using clusters_pkey on clusters cl (cost=0.14..0.77 rows=22 width=36) (actual time=0.004..0.014 rows=22 loops=1)

14. 0.044 0.078 ↑ 1.0 31 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
15. 0.034 0.034 ↑ 1.0 31 1

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

16. 0.036 0.075 ↑ 1.0 30 1

Hash (cost=0.96..0.96 rows=30 width=36) (actual time=0.075..0.075 rows=30 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
17. 0.039 0.039 ↑ 1.0 30 1

Index Scan using leasecontracts_idx_myear on leasecontracts lc (cost=0.14..0.96 rows=30 width=36) (actual time=0.014..0.039 rows=30 loops=1)

  • Index Cond: (myear = 2019)
18. 0.034 0.061 ↑ 1.0 25 1

Hash (cost=0.81..0.81 rows=25 width=40) (actual time=0.061..0.061 rows=25 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
19. 0.027 0.027 ↑ 1.0 25 1

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

Planning time : 2.522 ms
Execution time : 880.745 ms