explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GH8k

Settings
# exclusive inclusive rows x rows loops node
1. 5,254.976 104,333.379 ↓ 4.1 12,437,950 1

Sort (cost=2,407,350.07..2,414,910.88 rows=3,024,325 width=16) (actual time=102,693.841..104,333.379 rows=12,437,950 loops=1)

  • Sort Key: (count(*)) DESC
  • Sort Method: external merge Disk: 316,648kB
  • JIT:
  • Functions: 3
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 0.466 ms, Inlining 2.041 ms, Optimization 18.189 ms, Emission 13.472 ms, Total 34.167 ms
2. 7,684.413 99,078.403 ↓ 4.1 12,437,950 1

GroupAggregate (cost=0.57..2,051,534.58 rows=3,024,325 width=16) (actual time=34.085..99,078.403 rows=12,437,950 loops=1)

  • Group Key: submission_id
3. 91,393.990 91,393.990 ↑ 1.0 67,316,234 1

Index Only Scan using subm_id_idx on faves (cost=0.57..1,684,703.13 rows=67,317,641 width=8) (actual time=0.027..91,393.990 rows=67,316,234 loops=1)

  • Heap Fetches: 67,322,406
Planning time : 0.092 ms
Execution time : 104,881.348 ms