explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oRnX : Optimization for: plan #wajd

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.023 249.287 ↑ 7.7 26 1

Sort (cost=31.15..31.65 rows=200 width=128) (actual time=249.286..249.287 rows=26 loops=1)

  • Sort Key: (sum(COALESCE(crosstab.sec, '0'::bigint))) DESC, (sum(COALESCE(crosstab.min, '0'::bigint))) DESC, (sum(COALESCE(crosstab."15m", '0'::bigint))) DESC
  • Sort Method: quicksort Memory: 27kB
2. 0.034 249.264 ↑ 7.7 26 1

HashAggregate (cost=20.00..23.50 rows=200 width=128) (actual time=249.254..249.264 rows=26 loops=1)

  • Group Key: crosstab.egauge
3. 249.230 249.230 ↑ 22.7 44 1

Function Scan on crosstab (cost=0.00..10.00 rows=1,000 width=56) (actual time=249.227..249.230 rows=44 loops=1)

Planning time : 0.224 ms
Execution time : 249.366 ms