explain.depesz.com

PostgreSQL's explain analyze made readable

Result: W8HN : 9.6

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 5.455 94,062.161 ↑ 3.4 59 1

HashAggregate (cost=42,103.26..42,105.26 rows=200 width=16) (actual time=94,062.150..94,062.161 rows=59 loops=1)

  • Group Key: (st_valuecount(cv.rast, 1, true, NULL::double precision[], '0'::double precision)).value
  • Buffers: shared hit=35,395
2. 94,056.706 94,056.706 ↑ 129.8 15,812 1

Seq Scan on calveg_whrtype_20m cv (cost=0.00..11,323.26 rows=2,052,000 width=12) (actual time=90.687..94,056.706 rows=15,812 loops=1)

  • Buffers: shared hit=35,395
Planning time : 0.213 ms
Execution time : 94,062.215 ms