Re: Planning time is high in Postgres 11.5 Compared with Postgres 10.11 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Planning time is high in Postgres 11.5 Compared with Postgres 10.11
Date
Msg-id 26233.1576600294@sss.pgh.pa.us
Whole thread Raw
In response to Re: Planning time is high in Postgres 11.5 Compared with Postgres10.11  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-bugs
Tomas Vondra <tomas.vondra@2ndquadrant.com> writes:
> You've been asked (at least) twice to check size of statistics stored in
> pg_stats. It's really hard to help you when you don't provide important
> information like this.

Apparently we need to be more explicit.  What we want to see is

select most_common_vals from pg_stats
where tablename = 'child' and attname = 'id';

select most_common_vals from pg_stats
where tablename = 'core' and attname = 'groupid';

from both databases.  (Adjust as necessary if those weren't the
real table and column names.)  We probably don't need the specific
array elements, but we do want to know how big those arrays are.

            regards, tom lane



pgsql-bugs by date:

Previous
From: Arseny Sher
Date:
Subject: Re: ERROR: subtransaction logged without previous top-level txn record
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #16169: Default time output for 24:00 is 00:00