explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OJk9

Settings
# exclusive inclusive rows x rows loops node
1. 10,681.135 11,976.437 ↓ 3.2 79,783 1

GroupAggregate (cost=217,950.55..1,596,666.49 rows=24,749 width=556) (actual time=1,235.340..11,976.437 rows=79,783 loops=1)

  • Group Key: exaasmouvementsaccountspivot.line_number
2. 1,010.122 1,295.302 ↑ 1.0 672,152 1

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

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

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