diff options
Diffstat (limited to 'src/test/regress/expected/select_parallel.out')
| -rw-r--r-- | src/test/regress/expected/select_parallel.out | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/src/test/regress/expected/select_parallel.out b/src/test/regress/expected/select_parallel.out index 0eca76cb41e..9775cc898ce 100644 --- a/src/test/regress/expected/select_parallel.out +++ b/src/test/regress/expected/select_parallel.out @@ -89,6 +89,33 @@ select round(avg(aa)), sum(aa) from a_star a3; 14 | 355 (1 row) +-- Temporary hack to investigate whether extra vacuum/analyze is happening +select relname, relpages, reltuples +from pg_class +where relname like '__star' order by relname; + relname | relpages | reltuples +---------+----------+----------- + a_star | 1 | 3 + b_star | 1 | 4 + c_star | 1 | 4 + d_star | 1 | 16 + e_star | 1 | 7 + f_star | 1 | 16 +(6 rows) + +select relname, vacuum_count, analyze_count, autovacuum_count, autoanalyze_count +from pg_stat_all_tables +where relname like '__star' order by relname; + relname | vacuum_count | analyze_count | autovacuum_count | autoanalyze_count +---------+--------------+---------------+------------------+------------------- + a_star | 1 | 0 | 0 | 0 + b_star | 1 | 0 | 0 | 0 + c_star | 1 | 0 | 0 | 0 + d_star | 1 | 0 | 0 | 0 + e_star | 1 | 0 | 0 | 0 + f_star | 1 | 0 | 0 | 0 +(6 rows) + -- Disable Parallel Append alter table a_star reset (parallel_workers); alter table b_star reset (parallel_workers); |