explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lIRS : 12

Settings
# exclusive inclusive rows x rows loops node
1. 3.417 44,634.031 ↑ 3.4 59 1

HashAggregate (cost=1,088,130.78..1,088,132.78 rows=200 width=16) (actual time=44,634.021..44,634.031 rows=59 loops=1)

  • Group Key: ((st_valuecount(cv.rast, 1, true, NULL::double precision[], '0'::double precision))).value
  • Buffers: shared hit=17,664
  • Functions: 12
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 3.299 ms, Inlining 10.618 ms, Optimization 124.105 ms, Emission 80.956 ms, Total 218.978 ms
2. 2.307 44,630.614 ↑ 129.8 15,812 1

Result (cost=0.00..1,057,350.78 rows=2,052,000 width=12) (actual time=348.651..44,630.614 rows=15,812 loops=1)

  • Buffers: shared hit=17,664
3. 44,626.996 44,628.307 ↑ 129.8 15,812 1

ProjectSet (cost=0.00..10,830.78 rows=2,052,000 width=32) (actual time=348.637..44,628.307 rows=15,812 loops=1)

  • Buffers: shared hit=17,664
4. 1.311 1.311 ↑ 1.0 2,052 1

Seq Scan on calveg_whrtype_20m cv (cost=0.00..47.52 rows=2,052 width=31) (actual time=0.022..1.311 rows=2,052 loops=1)

  • Buffers: shared hit=27
Execution time : 44,637.499 ms