explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9otb

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

GroupAggregate (cost=234,599.82..1,606,594.24 rows=24,749 width=556) (actual time=1,384.455..11,658.189 rows=79,783 loops=1)

  • Group Key: q.line_number
2. 763.761 1,420.235 ↑ 1.0 672,152 1

Sort (cost=234,599.82..236,280.20 rows=672,152 width=175) (actual time=1,246.129..1,420.235 rows=672,152 loops=1)

  • Sort Key: q.line_number
  • Sort Method: external merge Disk: 83,664kB
3. 240.766 656.474 ↑ 1.0 672,152 1

Subquery Scan on q (cost=0.42..54,670.79 rows=672,152 width=175) (actual time=0.024..656.474 rows=672,152 loops=1)

4. 415.708 415.708 ↑ 1.0 672,152 1

Index Scan Backward using aaa on exaasmouvementsaccountspivot (cost=0.42..47,949.27 rows=672,152 width=207) (actual time=0.023..415.708 rows=672,152 loops=1)