explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Dg2J6

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

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

  • Group Key: q.line_number
2. 714.704 1,270.695 ↑ 1.0 672,152 1

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

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

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

4. 348.018 348.018 ↑ 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.008..348.018 rows=672,152 loops=1)