explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PZPU

Settings
# exclusive inclusive rows x rows loops node
1. 13.685 1,140.525 ↓ 1.7 29,056 1

Hash Join (cost=19,861.74..29,674.33 rows=16,858 width=221) (actual time=783.545..1,140.525 rows=29,056 loops=1)

  • Hash Cond: (agricultureusing.mvarieties = varieties.mid)
2. 14.231 1,126.301 ↓ 1.7 29,056 1

Hash Join (cost=19,832.88..29,413.67 rows=16,858 width=204) (actual time=782.987..1,126.301 rows=29,056 loops=1)

  • Hash Cond: (agricultureusing.mcrops = crops.mid)
3. 39.483 1,109.531 ↓ 1.7 29,056 1

Hash Join (cost=19,754.70..29,103.70 rows=16,858 width=164) (actual time=780.421..1,109.531 rows=29,056 loops=1)

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

Seq Scan on agricultureusing (cost=0.00..8,891.56 rows=77,104 width=88) (actual time=0.020..290.300 rows=74,750 loops=1)

  • Filter: ((NOT is_deleted) AND mcurrent AND (myear = 2019))
  • Rows Removed by Filter: 478522
5. 59.795 779.748 ↓ 1.1 126,950 1

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

  • Buckets: 131072 Batches: 1 Memory Usage: 13650kB
6. 123.537 719.953 ↓ 1.1 126,950 1

Hash Join (cost=861.47..18,261.97 rows=119,419 width=92) (actual time=134.858..719.953 rows=126,950 loops=1)

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

Seq Scan on vsxfeature (cost=0.00..14,158.07 rows=546,197 width=92) (actual time=0.011..461.602 rows=546,505 loops=1)

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

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

  • Buckets: 4096 (originally 2048) Batches: 1 (originally 1) Memory Usage: 178kB
9. 132.761 132.761 ↓ 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.159..132.761 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.367 2.539 ↓ 1.0 3,234 1

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

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

Seq Scan on crops (cost=0.00..37.91 rows=3,221 width=56) (actual time=0.009..1.172 rows=3,234 loops=1)

12. 0.310 0.539 ↑ 1.5 821 1

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

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

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

Planning time : 1.831 ms
Execution time : 1,144.844 ms