explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NK4h : Optimization for: Optimization for: plan #EcGQ; plan #r2v6

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 3,425.263 13,108.757 ↓ 4.0 69,472 1

HashAggregate (cost=1,236,265.71..1,236,440.58 rows=17,487 width=24) (actual time=13,083.050..13,108.757 rows=69,472 loops=1)

  • Group Key: student_id
2. 9,683.494 9,683.494 ↑ 1.0 9,910,252 1

Seq Scan on questions (cost=0.00..1,184,654.32 rows=10,322,278 width=24) (actual time=0.015..9,683.494 rows=9,910,252 loops=1)

  • Filter: (has_revised IS TRUE)
  • Rows Removed by Filter: 16,970,659
Planning time : 0.604 ms
Execution time : 13,112.908 ms