explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Yewz

Settings
# exclusive inclusive rows x rows loops node
1. 11.993 764.130 ↑ 338.0 1 1

HashAggregate (cost=24,309.17..24,312.55 rows=338 width=24) (actual time=764.129..764.130 rows=1 loops=1)

  • Group Key: agricultureusing.mcrops
2. 39.235 752.137 ↓ 1.7 29,056 1

Hash Join (cost=15,104.65..24,225.04 rows=16,825 width=24) (actual time=568.146..752.137 rows=29,056 loops=1)

  • Hash Cond: (agricultureusing.mfeature = vsxfeature.mid)
3. 145.439 145.439 ↑ 1.0 74,750 1

Index Scan using agricultureusing_curr_year_delete on agricultureusing (cost=0.42..8,663.99 rows=76,955 width=32) (actual time=0.015..145.439 rows=74,750 loops=1)

  • Index Cond: ((myear = 2019) AND (is_deleted = false))
  • Filter: ((NOT is_deleted) AND mcurrent)
  • Rows Removed by Filter: 22
4. 43.508 567.463 ↓ 1.1 126,950 1

Hash (cost=13,611.49..13,611.49 rows=119,419 width=24) (actual time=567.463..567.463 rows=126,950 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 7967kB
5. 75.494 523.955 ↓ 1.1 126,950 1

Merge Join (cost=1,436.31..13,611.49 rows=119,419 width=24) (actual time=146.944..523.955 rows=126,950 loops=1)

  • Merge Cond: (vsxlayers.mid = vsxfeature.mlayer)
6. 3.381 133.363 ↓ 3.0 3,110 1

Sort (cost=900.45..903.04 rows=1,037 width=16) (actual time=132.717..133.363 rows=3,110 loops=1)

  • Sort Key: vsxlayers.mid
  • Sort Method: quicksort Memory: 242kB
7. 129.982 129.982 ↓ 3.0 3,110 1

Index Scan using ind_fk_vsxlayers_mowner on vsxlayers (cost=0.28..848.50 rows=1,037 width=16) (actual time=0.146..129.982 rows=3,110 loops=1)

  • Index Cond: (mowner = '79610a40-aeaa-4bff-a9d6-5444a5aa94c9'::uuid)
  • Filter: fn_layer_bind_user(mid, 'd536ece4-3511-4f31-a77f-b5944f5f953e'::uuid)
8. 315.098 315.098 ↓ 1.0 546,505 1

Index Only Scan using ind_vsxfeature_complex on vsxfeature (cost=0.55..10,146.20 rows=546,197 width=40) (actual time=0.026..315.098 rows=546,505 loops=1)

  • Index Cond: (is_deleted = false)
  • Filter: (NOT is_deleted)
  • Heap Fetches: 3007
Planning time : 0.892 ms
Execution time : 766.250 ms