explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vCbN

Settings
# exclusive inclusive rows x rows loops node
1. 5,041.367 67,292.491 ↓ 4.1 12,463,085 1

Sort (cost=1,736,612.79..1,744,173.60 rows=3,024,325 width=16) (actual time=66,075.861..67,292.491 rows=12,463,085 loops=1)

  • Sort Key: (count(*)) DESC
  • Sort Method: external merge Disk: 317,080kB
  • JIT:
  • Functions: 6
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 0.950 ms, Inlining 3.099 ms, Optimization 24.003 ms, Emission 11.211 ms, Total 39.264 ms
2. 51,596.762 62,251.124 ↓ 4.1 12,463,085 1

HashAggregate (cost=1,380,828.45..1,411,071.70 rows=3,024,325 width=16) (actual time=56,705.450..62,251.124 rows=12,463,085 loops=1)

  • Group Key: submission_id
3. 10,654.362 10,654.362 ↑ 1.0 67,667,148 1

Seq Scan on faves (cost=0.00..1,042,485.63 rows=67,668,563 width=8) (actual time=3.707..10,654.362 rows=67,667,148 loops=1)

Planning time : 0.107 ms
Execution time : 67,906.051 ms