explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GBP

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 392.142 508.722 ↓ 4.0 21,704 1

HashAggregate (cost=81,491.210..81,545.110 rows=5,390 width=23) (actual time=505.259..508.722 rows=21,704 loops=1)

  • Group Key: four
2. 116.580 116.580 ↓ 1.0 652,214 1

Seq Scan on whiskey (cost=0.000..79,866.570 rows=649,857 width=23) (actual time=0.013..116.580 rows=652,214 loops=1)

Planning time : 0.273 ms
Execution time : 509.856 ms