explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kUuJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=128,990,537.58..131,513,008.51 rows=139,679 width=55) (actual rows= loops=)

  • Group Key: YYY_id
2. 0.000 0.000 ↓ 0.0

Sort (cost=128,990,537.58..129,830,895.62 rows=336,143,219 width=55) (actual rows= loops=)

  • Sort Key: YYY_id
3. 0.000 0.000 ↓ 0.0

Seq Scan on YYY_journal (cost=0.00..35,428,007.19 rows=336,143,219 width=55) (actual rows= loops=)