explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ev2b

Settings
# exclusive inclusive rows x rows loops node
1. 10,619.454 12,011.276 ↓ 3.2 79,783 1

GroupAggregate (cost=217,950.55..1,596,666.49 rows=24,749 width=556) (actual time=1,300.190..12,011.276 rows=79,783 loops=1)

  • Group Key: exaasmouvementsaccountspivot.line_number
2. 1,102.555 1,391.822 ↑ 1.0 672,152 1

Sort (cost=217,950.55..219,630.93 rows=672,152 width=207) (actual time=1,158.786..1,391.822 rows=672,152 loops=1)

  • Sort Key: exaasmouvementsaccountspivot.line_number, exaasmouvementsaccountspivot.mainamount DESC
  • Sort Method: external merge Disk: 83,520kB
3. 289.267 289.267 ↑ 1.0 672,152 1

Seq Scan on exaasmouvementsaccountspivot (cost=0.00..19,639.52 rows=672,152 width=207) (actual time=0.009..289.267 rows=672,152 loops=1)