explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zOUK : 6

Settings
# exclusive inclusive rows x rows loops node
1. 23.640 1,153.826 ↑ 1.6 29,056 1

Hash Join (cost=36,185.98..44,077.61 rows=47,686 width=202) (actual time=868.866..1,153.826 rows=29,056 loops=1)

  • Hash Cond: (f.mlayer = l.mid)
2. 187.844 1,127.436 ↓ 1.0 74,707 1

Hash Join (cost=36,068.14..43,210.16 rows=72,732 width=52) (actual time=865.304..1,127.436 rows=74,707 loops=1)

  • Hash Cond: (au.mfeature = f.mid)
3. 76.926 76.926 ↓ 1.0 74,707 1

Index Scan using agricultureusing_curr_year_delete on agricultureusing au (cost=0.42..5,538.36 rows=72,817 width=16) (actual time=0.015..76.926 rows=74,707 loops=1)

  • Index Cond: ((myear = 2019) AND (is_deleted = false))
  • Filter: (NOT is_deleted)
4. 260.623 862.666 ↓ 1.0 546,110 1

Hash (cost=28,720.08..28,720.08 rows=545,211 width=52) (actual time=862.666..862.666 rows=546,110 loops=1)

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

Seq Scan on vsxfeature f (cost=0.00..28,720.08 rows=545,211 width=52) (actual time=0.020..602.043 rows=546,110 loops=1)

  • Filter: (NOT is_deleted)
6. 1.222 2.750 ↓ 1.0 3,110 1

Hash (cost=79.19..79.19 rows=3,092 width=150) (actual time=2.750..2.750 rows=3,110 loops=1)

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

Index Scan using ind_fk_vsxlayers_mowner on vsxlayers l (cost=0.28..79.19 rows=3,092 width=150) (actual time=0.021..1.528 rows=3,110 loops=1)

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