Re: Too slow to create new schema and their tables, functions, triggers.

From: Luca Ferrari <fluca1978(at)gmail(dot)com>
To: PegoraroF10 <marcos(at)f10(dot)com(dot)br>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Too slow to create new schema and their tables, functions, triggers.
Date: 2019-07-26 16:45:40
Message-ID: CAKoxK+5Ui9=_LJQaQi9JhOheXn=W7eFqpdeH6sLMN2FUomeLbQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jul 26, 2019 at 1:15 PM PegoraroF10 <marcos(at)f10(dot)com(dot)br> wrote:
>
> select count(*), count(*) filter (where last_autovacuum is not null) from
> pg_stat_all_tables
> count count
> 36605 1178
>

What are the results of the same query against pg_stat_sys_tables and
pg_stat_user_tables? That's would help understanding which set of
tables are not being vacuumed.

Luca

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message PegoraroF10 2019-07-26 17:38:55 Re: Too slow to create new schema and their tables, functions, triggers.
Previous Message Adrian Klaver 2019-07-26 14:28:36 Re: Too slow to create new schema and their tables, functions, triggers.