vacuumdb did not analyze all tables?=
| От | Ron Johnson |
|---|---|
| Тема | vacuumdb did not analyze all tables?= |
| Дата | |
| Msg-id | CANzqJaCdq_V2a6oyYO5pJ9W9=4O7t_haOzK+pH5XE2PROUmp1Q@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: vacuumdb did not analyze all tables?=
|
| Список | pgsql-general |
vacuumdb 15.3
database instance: 9.6.24
I manually analyzed 71 tables this morning at 10:42. (All those with "rp20_y2021" in the relname.)
Three of the 71 tables were not analyzed. Why would that be?
(Five were not vacuumed, but I accept that some other process might have blocked them.)
vacuumdb -U postgres -h $DbServer --analyze -j6 -t ... -t cds.cdstransaction_rp20_y2021 -t ...
TAPb=# select schemaname||'.'||relname as table_name
, last_vacuum
, last_analyze
from pg_stat_user_tables
where schemaname||'.'||relname in ('cds.cdstransaction_rp20_y2021'
, 'css.image_annotation_rp20_y2021'
, 'tms.document_rp20_y2021')
order by 1;
table_name | last_vacuum | last_analyze
---------------------------------+-------------------------------+-------------------------------
cds.cdstransaction_rp20_y2021 | 2023-12-13 10:42:09.683143-05 | 2023-11-17 04:11:08.761861-05
css.image_annotation_rp20_y2021 | 2023-09-25 20:00:07.831722-04 | 2023-09-25 20:00:07.831793-04
tms.document_rp20_y2021 | 2023-12-13 10:42:03.079969-05 | 2023-11-17 04:11:56.583881-05
(3 rows)
TAPb=# select schemaname||'.'||relname as table_name
, last_vacuum
, last_analyze
from pg_stat_user_tables
where schemaname||'.'||relname in ('cds.cdstransaction_rp20_y2021'
, 'css.image_annotation_rp20_y2021'
, 'tms.document_rp20_y2021')
order by 1;
table_name | last_vacuum | last_analyze
---------------------------------+-------------------------------+-------------------------------
cds.cdstransaction_rp20_y2021 | 2023-12-13 10:42:09.683143-05 | 2023-11-17 04:11:08.761861-05
css.image_annotation_rp20_y2021 | 2023-09-25 20:00:07.831722-04 | 2023-09-25 20:00:07.831793-04
tms.document_rp20_y2021 | 2023-12-13 10:42:03.079969-05 | 2023-11-17 04:11:56.583881-05
(3 rows)
В списке pgsql-general по дате отправления: