Обсуждение: vacuumdb did not analyze all tables?=
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)
Ron: On Thu, 14 Dec 2023 at 03:39, Ron Johnson <ronljohnsonjr@gmail.com> wrote: ... > Three of the 71 tables were not analyzed. Why would that be? ... > vacuumdb -U postgres -h $DbServer --analyze -j6 -t ... -t cds.cdstransaction_rp20_y2021 -t ... ... > 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 I'm not sure if you kept the line, but you have ellipsed-out ( is that a word? ) the interesting names, so quoted vacuumdb line is useless for check. Francisco Olarte.
On Thu, Dec 14, 2023 at 12:20 PM Francisco Olarte <folarte@peoplecall.com> wrote:
Ron:
On Thu, 14 Dec 2023 at 03:39, Ron Johnson <ronljohnsonjr@gmail.com> wrote:
...
> Three of the 71 tables were not analyzed. Why would that be?
...
> vacuumdb -U postgres -h $DbServer --analyze -j6 -t ... -t cds.cdstransaction_rp20_y2021 -t ...
...
> 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
I'm not sure if you kept the line, but you have ellipsed-out ( is that
a word? )
I think so.
the interesting names, so quoted vacuumdb line is useless
for check.
71 tables were listed, and didn't want to flood my email with a KB or two of non-essential text.
I verified that all three tables were in the vacuumdb command line. (The list was generated by a query, and stdout and stderr were redirected to a file, and I grepped it for the table names.)
If you want, I can attach the log file.
On Thu, 14 Dec 2023 13:10:16 -0500 Ron Johnson wrote: >> I'm not sure if you kept the line, but you have ellipsed-out ( is that >> a word? ) ellipse: curve ellipsis: ...
On Thu, Dec 14, 2023 at 5:46 PM <pf@pfortin.com> wrote:
On Thu, 14 Dec 2023 13:10:16 -0500 Ron Johnson wrote:
>> I'm not sure if you kept the line, but you have ellipsed-out ( is that
>> a word? )
ellipse: curve
ellipsis: ...
Though in contect "redacted" makes sense too.
David J.
On Thu, Dec 14, 2023 at 7:51 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Thu, Dec 14, 2023 at 5:46 PM <pf@pfortin.com> wrote:On Thu, 14 Dec 2023 13:10:16 -0500 Ron Johnson wrote:
>> I'm not sure if you kept the line, but you have ellipsed-out ( is that
>> a word? )
ellipse: curve
ellipsis: ...Though in contect "redacted" makes sense too.
Context, not contect. :D