explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Z3YR

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

Limit (cost=1,658,556.19..1,696,765.69 rows=500 width=12) (actual rows= loops=)

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

GroupAggregate (cost=1,658,556.19..2,308,652.64 rows=8,507 width=12) (actual rows= loops=)

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

WindowAgg (cost=1,658,556.19..2,158,564.94 rows=10,000,175 width=16) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Subquery Scan on one (cost=1,658,556.19..1,958,561.44 rows=10,000,175 width=16) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

WindowAgg (cost=1,658,556.19..1,858,559.69 rows=10,000,175 width=16) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Sort (cost=1,658,556.19..1,683,556.63 rows=10,000,175 width=12) (actual rows= loops=)

  • Sort Key: test.strategy_id, test.id
7. 0.000 0.000 ↓ 0.0

Seq Scan on test (cost=0.00..154,056.75 rows=10,000,175 width=12) (actual rows= loops=)