explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EPK8

Settings
# exclusive inclusive rows x rows loops node
1. 16.055 1,111.557 ↓ 1.1 46,123 1

Hash Left Join (cost=19,861.74..32,315.63 rows=40,118 width=211) (actual time=748.949..1,111.557 rows=46,123 loops=1)

  • Hash Cond: (agricultureusing.mvarieties = varieties.mid)
2. 16.461 1,095.071 ↓ 1.1 46,123 1

Hash Left Join (cost=19,832.88..31,735.15 rows=40,118 width=194) (actual time=748.501..1,095.071 rows=46,123 loops=1)

  • Hash Cond: (agricultureusing.mcrops = crops.mid)
3. 62.144 1,076.628 ↓ 1.1 46,123 1

Hash Join (cost=19,754.70..31,105.35 rows=40,118 width=170) (actual time=746.481..1,076.628 rows=46,123 loops=1)

  • Hash Cond: (agricultureusing.mfeature = vsxfeature.mid)
4. 268.784 268.784 ↓ 1.0 184,111 1

Seq Scan on agricultureusing (cost=0.00..10,261.38 rows=183,491 width=88) (actual time=0.027..268.784 rows=184,111 loops=1)

  • Filter: ((NOT is_deleted) AND mcurrent AND (myear >= 2016) AND (myear <= 2019))
  • Rows Removed by Filter: 369161
5. 60.400 745.700 ↓ 1.1 126,950 1

Hash (cost=18,261.97..18,261.97 rows=119,419 width=98) (actual time=745.700..745.700 rows=126,950 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 13744kB
6. 115.797 685.300 ↓ 1.1 126,950 1

Hash Join (cost=861.47..18,261.97 rows=119,419 width=98) (actual time=129.597..685.300 rows=126,950 loops=1)

  • Hash Cond: (vsxfeature.mlayer = vsxlayers.mid)
7. 439.954 439.954 ↓ 1.0 546,505 1

Seq Scan on vsxfeature (cost=0.00..14,158.07 rows=546,197 width=98) (actual time=0.012..439.954 rows=546,505 loops=1)

  • Filter: (NOT is_deleted)
  • Rows Removed by Filter: 66
8. 1.931 129.549 ↓ 3.0 3,110 1

Hash (cost=848.50..848.50 rows=1,037 width=16) (actual time=129.549..129.549 rows=3,110 loops=1)

  • Buckets: 4096 (originally 2048) Batches: 1 (originally 1) Memory Usage: 178kB
9. 127.618 127.618 ↓ 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.245..127.618 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)
10. 1.046 1.982 ↓ 1.0 3,234 1

Hash (cost=37.91..37.91 rows=3,221 width=40) (actual time=1.982..1.982 rows=3,234 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 244kB
11. 0.936 0.936 ↓ 1.0 3,234 1

Seq Scan on crops (cost=0.00..37.91 rows=3,221 width=40) (actual time=0.021..0.936 rows=3,234 loops=1)

12. 0.248 0.431 ↑ 1.5 821 1

Hash (cost=13.55..13.55 rows=1,225 width=33) (actual time=0.431..0.431 rows=821 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 69kB
13. 0.183 0.183 ↑ 1.5 821 1

Seq Scan on varieties (cost=0.00..13.55 rows=1,225 width=33) (actual time=0.013..0.183 rows=821 loops=1)

Planning time : 1.657 ms
Execution time : 1,116.501 ms