explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KspC

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

Finalize Aggregate (cost=408,086.16..408,086.17 rows=1 width=8) (actual time=1,991.143..1,991.143 rows=1 loops=1)

2. 49.391 2,034.424 ↓ 1.1 8 1

Gather (cost=408,085.43..408,086.14 rows=7 width=8) (actual time=1,990.808..2,034.424 rows=8 loops=1)

  • Workers Planned: 7
  • Workers Launched: 7
3. 301.269 1,985.033 ↑ 1.0 1 8 / 8

Partial Aggregate (cost=407,085.43..407,085.44 rows=1 width=8) (actual time=1,985.033..1,985.033 rows=1 loops=8)

4. 1,683.764 1,683.764 ↑ 1.1 4,754,413 8 / 8

Parallel Index Only Scan using holdings_pkey on holdings (cost=0.56..393,508.12 rows=5,430,926 width=0) (actual time=0.090..1,683.764 rows=4,754,413 loops=8)

  • Heap Fetches: 11421
Planning time : 1.040 ms
Execution time : 2,034.503 ms