explain.depesz.com

PostgreSQL's explain analyze made readable

Result: p5T3

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

WindowAgg (cost=44,299.33..44,952.93 rows=32,680 width=48) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=44,299.33..44,381.03 rows=32,680 width=40) (actual rows= loops=)

  • Sort Key: test_attempt_id, scheduled
3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on test_event (cost=905.69..41,848.96 rows=32,680 width=40) (actual rows= loops=)

  • Recheck Cond: ((event_state = 'CREATED'::pass.test_event_state) AND (NOT completed))
  • -> Bitmap Index Scan on sq (cost=0.00..897.52 rows=32,680 width=0)" Index Cond: (event_state = 'CREATED'::pass.test_event_state)