explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ETdc : 8

Settings
# exclusive inclusive rows x rows loops node
1. 19.114 1,451.594 ↑ 1.7 29,056 1

Hash Join (cost=21,638.42..27,496.93 rows=50,422 width=201) (actual time=1,175.382..1,451.594 rows=29,056 loops=1)

  • Hash Cond: (f.mlayer = l.mid)
2. 164.123 1,428.700 ↑ 1.0 74,707 1

Hash Join (cost=21,528.55..26,594.46 rows=76,897 width=52) (actual time=1,171.014..1,428.700 rows=74,707 loops=1)

  • Hash Cond: (au.mfeature = f.mid)
3. 96.183 96.183 ↑ 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=16) (actual time=0.101..96.183 rows=74,707 loops=1)

  • Index Cond: ((myear = 2019) AND (is_deleted = false))
  • Filter: (NOT is_deleted)
4. 282.919 1,168.394 ↑ 1.0 546,110 1

Hash (cost=14,161.32..14,161.32 rows=546,632 width=52) (actual time=1,168.394..1,168.394 rows=546,110 loops=1)

  • Buckets: 524288 Batches: 2 Memory Usage: 27602kB
5. 885.475 885.475 ↑ 1.0 546,110 1

Seq Scan on vsxfeature f (cost=0.00..14,161.32 rows=546,632 width=52) (actual time=0.049..885.475 rows=546,110 loops=1)

  • Filter: (NOT is_deleted)
6. 1.296 3.780 ↑ 1.0 3,110 1

Hash (cost=71.00..71.00 rows=3,110 width=149) (actual time=3.780..3.780 rows=3,110 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 294kB
7. 2.484 2.484 ↑ 1.0 3,110 1

Index Scan using ind_fk_vsxlayers_mowner on vsxlayers l (cost=0.28..71.00 rows=3,110 width=149) (actual time=0.071..2.484 rows=3,110 loops=1)

  • Index Cond: (mowner = '79610a40-aeaa-4bff-a9d6-5444a5aa94c9'::uuid)
Planning time : 2.887 ms
Execution time : 1,460.898 ms