explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LHPJ

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

GroupAggregate (cost=199,568.55..1,571,562.97 rows=24,749 width=556) (actual time=940.702..11,565.752 rows=79,783 loops=1)

  • Group Key: line_number
2. 685.724 1,019.665 ↑ 1.0 672,152 1

Sort (cost=199,568.55..201,248.93 rows=672,152 width=175) (actual time=816.015..1,019.665 rows=672,152 loops=1)

  • Sort Key: line_number
  • Sort Method: external merge Disk: 83,640kB
3. 333.941 333.941 ↑ 1.0 672,152 1

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