explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LEBh

Settings
# exclusive inclusive rows x rows loops node
1. 0.343 332.583 ↑ 135.2 180 1

Sort (cost=14,072.52..14,133.36 rows=24,336 width=20) (actual time=332.537..332.583 rows=180 loops=1)

  • Sort Key: name
  • Sort Method: quicksort Memory: 37kB
2. 211.976 332.240 ↑ 135.2 180 1

HashAggregate (cost=12,056.18..12,299.55 rows=24,336 width=20) (actual time=332.154..332.240 rows=180 loops=1)

  • Group Key: name, code
3. 120.264 120.264 ↑ 1.0 446,965 1

Seq Scan on currencies_currency (cost=0.00..8,703.82 rows=446,982 width=20) (actual time=0.012..120.264 rows=446,965 loops=1)

Planning time : 0.473 ms
Execution time : 332.827 ms