need explanation about an explain plan

From: Marc Millas <marc(dot)millas(at)mokadb(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: need explanation about an explain plan
Date: 2023-06-28 15:22:12
Message-ID: CADX_1aZHUsDwXAutJ5Eh2d9dNnTjRoWV4f=tS0yBhQhLg5t+Hg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Postgres 14.2 (for one more month)
The explain plan and request is here:
https://explain.depesz.com/s/Opk0

The big table is split in around 130 partitions, one by month.
the ladate column is the partition key, and it does have 1 value for each
partition.
there is a

Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc Millas 2023-06-28 15:29:27 Re: need explanation about an explain plan
Previous Message Ben Chobot 2023-06-28 14:32:29 Re: pgbouncer