Re: need explanation about an explain plan

From: Marc Millas <marc(dot)millas(at)mokadb(dot)com>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: need explanation about an explain plan
Date: 2023-06-29 10:07:55
Message-ID: CADX_1aYmoxPaADZM5hjgRK7UfjLLdZAd-rDK6axh9qsHseHuxQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Le mer. 28 juin 2023 à 22:46, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> a
écrit :

> On Wed, 2023-06-28 at 19:25 +0200, Marc Millas wrote:
> > Hi Laurenz, as said, in each partition there is only one value for
> ladate.
>
> The planner doesn't seem to take that into account.
>
Indeed. I did check values in pg_statistic. And rerun analyze. No change...

>
> Yours,
> Laurenz Albe
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc Millas 2023-06-29 11:55:03 analyze partition
Previous Message Dominique Devienne 2023-06-29 08:21:33 Topological sort of tables, based on FK relationships