explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yhoX

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

GroupAggregate (cost=451,755.58..465,995.16 rows=995 width=48) (actual rows= loops=)

  • Group Key: project_id
2. 0.000 0.000 ↓ 0.0

Sort (cost=451,755.58..456,497.96 rows=1,896,952 width=32) (actual rows= loops=)

  • Sort Key: project_id
3. 0.000 0.000 ↓ 0.0

Seq Scan on firedrill_resultsummary rs (cost=0.00..163,172.52 rows=1,896,952 width=32) (actual rows= loops=)