Horton
Menu

Thread

  1. vacuumdb did not analyze all tables?=

    Ron Johnson <ronljohnsonjr@gmail.com> — 2023-12-14T02:38:52Z

      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)

  2. Re: vacuumdb did not analyze all tables?=

    Francisco Olarte <folarte@peoplecall.com> — 2023-12-14T17:19:46Z

    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.

  3. Re: vacuumdb did not analyze all tables?=

    Ron Johnson <ronljohnsonjr@gmail.com> — 2023-12-14T18:10:16Z

    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.

  4. Re: vacuumdb did not analyze all tables?=

    Pierre Fortin <pf@pfortin.com> — 2023-12-15T00:46:16Z

    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:  ...

  5. Re: vacuumdb did not analyze all tables?=

    David G. Johnston <david.g.johnston@gmail.com> — 2023-12-15T00:50:19Z

    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.

  6. Re: vacuumdb did not analyze all tables?=

    Ron Johnson <ronljohnsonjr@gmail.com> — 2023-12-15T01:56:43Z

    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