[Flaky test] dist_parallel_agg reports different plan

[jchampio]

Which test is flaky?

dist_parallel_agg

Since when has the test been flaky?

February 14, 2023

Link to the failed test run

https://github.com/timescale/timescaledb/actions/runs/4175600633/jobs/7233371487

Log output

diff -u /Users/runner/work/timescaledb/timescaledb/tsl/test/shared/expected/dist_parallel_agg.out /Users/runner/work/timescaledb/timescaledb/build/tsl/test/shared/results/dist_parallel_agg.out
--- /Users/runner/work/timescaledb/timescaledb/tsl/test/shared/expected/dist_parallel_agg.out   2023-02-14 15:56:32.000000000 +0000
+++ /Users/runner/work/timescaledb/timescaledb/build/tsl/test/shared/results/dist_parallel_agg.out  2023-02-14 16:05:52.000000000 +0000
@@ -53,11 +53,12 @@
                    Output: PARTIAL count(*)
                    Worker 0: actual rows=1 loops=1
                    ->  Parallel Append (actual rows=10000 loops=2)
-                         Worker 0: actual rows=0 loops=1
-                         ->  Parallel Seq Scan on _timescaledb_internal._dist_hyper_X_X_chunk (actual rows=17990 loops=1)
+                         Worker 0: actual rows=7382 loops=1
+                         ->  Parallel Seq Scan on _timescaledb_internal._dist_hyper_X_X_chunk (actual rows=8995 loops=2)
+                               Worker 0: actual rows=7382 loops=1
                          ->  Parallel Seq Scan on _timescaledb_internal._dist_hyper_X_X_chunk (actual rows=2010 loops=1)

-(22 rows)
+(23 rows)

 :analyze
 select ts_debug_shippable_safe_count(*) from metrics_dist1;

Reason for flakiness

No response

[svenklemm]

multinode has been removed