explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rFYF

Settings
# exclusive inclusive rows x rows loops node
1. 3.449 44,525.528 ↑ 3.4 59 1

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

  • Group Key: ((st_valuecount(cv.rast, 1, true, NULL::double precision[], '0'::double precision))).value
  • Buffers: shared hit=17664
  • Functions: 12
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 3.299 ms, Inlining 10.675 ms, Optimization 125.677 ms, Emission 82.355 ms, Total 222.005 ms
2. 2.215 44,522.079 ↑ 129.8 15,812 1

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

  • Buffers: shared hit=17664
3. 44,518.516 44,519.864 ↑ 129.8 15,812 1

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

  • Buffers: shared hit=17664
4. 1.348 1.348 ↑ 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.348 rows=2,052 loops=1)

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