[pgpool-general: 8986] vacuumdb did not analyze all tables?

Ron Johnson ronljohnsonjr at gmail.com
Thu Dec 14 02:49:55 JST 2023


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)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20231213/75beb86b/attachment.htm>


More information about the pgpool-general mailing list