explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uyrk

Settings
# exclusive inclusive rows x rows loops node
1. 10.791 707.340 ↑ 338.0 1 1

HashAggregate (cost=24,309.20..24,312.58 rows=338 width=24) (actual time=707.340..707.340 rows=1 loops=1)

  • Group Key: agricultureusing.mcrops
2. 34.282 696.549 ↓ 1.7 29,056 1

Hash Join (cost=15,104.65..24,225.07 rows=16,826 width=24) (actual time=555.923..696.549 rows=29,056 loops=1)

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

Index Only Scan using agricultureusing_curr_year_delete on agricultureusing (cost=0.42..8,663.99 rows=76,960 width=32) (actual time=0.084..107.122 rows=74,772 loops=1)

  • Index Cond: ((myear = 2019) AND (is_deleted = false))
  • Filter: (NOT is_deleted)
  • Heap Fetches: 74772
4. 41.583 555.145 ↓ 1.1 126,950 1

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

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

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

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

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

  • Sort Key: vsxlayers.mid
  • Sort Method: quicksort Memory: 242kB
7. 127.277 127.277 ↓ 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.153..127.277 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. 308.952 308.952 ↓ 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.027..308.952 rows=546,505 loops=1)

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