explain.depesz.com

PostgreSQL's explain analyze made readable

Result: f66Q

Settings
# exclusive inclusive rows x rows loops node
1. 10.452 884.508 ↑ 338.0 1 1

HashAggregate (cost=24,537.51..24,540.89 rows=338 width=24) (actual time=884.507..884.508 rows=1 loops=1)

  • Group Key: agricultureusing.mcrops
2. 33.146 874.056 ↓ 1.7 29,056 1

Hash Join (cost=15,104.23..24,453.22 rows=16,858 width=24) (actual time=563.688..874.056 rows=29,056 loops=1)

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

Seq Scan on agricultureusing (cost=0.00..8,891.56 rows=77,104 width=32) (actual time=0.030..277.992 rows=74,750 loops=1)

  • Filter: ((NOT is_deleted) AND mcurrent AND (myear = 2019))
  • Rows Removed by Filter: 478522
4. 41.116 562.918 ↓ 1.1 126,950 1

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

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

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

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

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

  • Sort Key: vsxlayers.mid
  • Sort Method: quicksort Memory: 242kB
7. 128.184 128.184 ↓ 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.152..128.184 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. 314.634 314.634 ↓ 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.028..314.634 rows=546,505 loops=1)

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