explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CoFg

Settings
# exclusive inclusive rows x rows loops node
1. 11.739 893.803 ↑ 338.0 1 1

HashAggregate (cost=24,523.38..24,526.76 rows=338 width=24) (actual time=893.803..893.803 rows=1 loops=1)

  • Group Key: agricultureusing.mcrops
2. 34.990 882.064 ↓ 1.7 29,056 1

Hash Join (cost=15,104.23..24,439.26 rows=16,825 width=24) (actual time=561.329..882.064 rows=29,056 loops=1)

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

Seq Scan on agricultureusing (cost=0.00..8,878.20 rows=76,955 width=32) (actual time=0.027..286.503 rows=74,750 loops=1)

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

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

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

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

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

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

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

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