explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qCkA

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

Finalize Aggregate (cost=1,797,063.05..1,797,063.06 rows=1 width=8) (actual time=16,439.821..16,439.821 rows=1 loops=1)

2. 25.227 16,441.406 ↓ 1.5 3 1

Gather (cost=1,797,062.83..1,797,063.04 rows=2 width=8) (actual time=16,439.703..16,441.406 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 7,239.320 16,416.179 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=1,796,062.83..1,796,062.84 rows=1 width=8) (actual time=16,416.179..16,416.179 rows=1 loops=3)

4. 9,176.859 9,176.859 ↑ 1.2 18,187,392 3 / 3

Parallel Index Only Scan using streaming_file_inserted_at_index on streaming_file (cost=0.56..1,739,227.73 rows=22,734,042 width=0) (actual time=0.036..9,176.859 rows=18,187,392 loops=3)

  • Heap Fetches: 549436
Planning time : 211,106.605 ms
Execution time : 16,441.484 ms