explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BnxW

Settings
# exclusive inclusive rows x rows loops node
1. 50,020.576 57,569.271 ↓ 4.1 12,466,143 1

HashAggregate (cost=1,382,240.24..1,412,483.49 rows=3,024,325 width=16) (actual time=51,786.840..57,569.271 rows=12,466,143 loops=1)

  • Group Key: submission_id
  • JIT:
  • Functions: 6
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 1.020 ms, Inlining 1.744 ms, Optimization 22.938 ms, Emission 11.524 ms, Total 37.226 ms
2. 7,548.695 7,548.695 ↑ 1.0 67,736,387 1

Seq Scan on faves (cost=0.00..1,043,551.49 rows=67,737,749 width=8) (actual time=0.085..7,548.695 rows=67,736,387 loops=1)

Planning time : 0.129 ms
Execution time : 58,169.294 ms