explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1ySg

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=1,101,130.52..1,101,130.54 rows=5 width=12) (actual rows= loops=)

  • JIT:
  • Functions: 17
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
2. 0.000 0.000 ↓ 0.0

Sort (cost=1,101,130.52..1,101,151.79 rows=8,507 width=12) (actual rows= loops=)

  • Sort Key: (max(((max(one.cumsum) OVER (?) - one.cumsum)))) DESC
3. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.43..1,100,989.23 rows=8,507 width=12) (actual rows= loops=)

  • Group Key: one.strategy_id
4. 0.000 0.000 ↓ 0.0

WindowAgg (cost=0.43..950,904.16 rows=10,000,000 width=16) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Subquery Scan on one (cost=0.43..750,904.16 rows=10,000,000 width=16) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

WindowAgg (cost=0.43..650,904.16 rows=10,000,000 width=16) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Index Scan using tetetetetetetete on test (cost=0.43..475,904.16 rows=10,000,000 width=12) (actual rows= loops=)