explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sAc5

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 10,469.669 ↑ 1.0 3 1

Finalize GroupAggregate (cost=24,492.08..24,492.84 rows=3 width=10) (actual time=10,469.405..10,469.669 rows=3 loops=1)

  • Group Key: category
2. 19.531 10,473.466 ↓ 1.5 9 1

Gather Merge (cost=24,492.08..24,492.78 rows=6 width=10) (actual time=10,469.193..10,473.466 rows=9 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.145 10,453.935 ↑ 1.0 3 3 / 3

Sort (cost=23,492.06..23,492.06 rows=3 width=10) (actual time=10,453.894..10,453.935 rows=3 loops=3)

  • Sort Key: category
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
  • Worker 1: Sort Method: quicksort Memory: 25kB
4. 5,262.479 10,453.790 ↑ 1.0 3 3 / 3

Partial HashAggregate (cost=23,492.00..23,492.03 rows=3 width=10) (actual time=10,453.749..10,453.790 rows=3 loops=3)

  • Group Key: category
5. 5,191.311 5,191.311 ↑ 1.3 333,333 3 / 3

Parallel Seq Scan on persons (cost=0.00..21,408.67 rows=416,667 width=2) (actual time=0.030..5,191.311 rows=333,333 loops=3)

Planning time : 0.199 ms
Execution time : 10,474.031 ms