explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NXMw

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 195,049.609 ↑ 1.0 1 1

Finalize Aggregate (cost=566,810.27..566,810.28 rows=1 width=8) (actual time=195,049.599..195,049.609 rows=1 loops=1)

2. 17.670 195,050.782 ↓ 1.5 3 1

Gather (cost=566,810.05..566,810.26 rows=2 width=8) (actual time=195,049.312..195,050.782 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 95,498.654 195,033.112 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=565,810.05..565,810.06 rows=1 width=8) (actual time=195,033.102..195,033.112 rows=1 loops=3)

4. 99,534.458 99,534.458 ↑ 1.3 4,389,794 3 / 3

Parallel Seq Scan on timeline_event (cost=0.00..552,057.04 rows=5,501,204 width=0) (actual time=0.234..99,534.458 rows=4,389,794 loops=3)

Planning time : 0.477 ms
Execution time : 195,050.899 ms