Home > mailing lists

need explanation about an explain plan - Mailing list pgsql-general

From	Marc Millas
Subject	need explanation about an explain plan
Date	June 28, 2023 18:22:12
Msg-id	CADX_1aZHUsDwXAutJ5Eh2d9dNnTjRoWV4f=tS0yBhQhLg5t+Hg@mail.gmail.com Whole thread Raw
Responses	Re: need explanation about an explain plan (Marc Millas <marc.millas@mokadb.com>)
List	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

pgsql-general by date:

Previous

From: Ben Chobot
Date: 28 June 2023, 17:32:29
Subject: Re: pgbouncer

Next

From: Marc Millas
Date: 28 June 2023, 18:29:27
Subject: Re: need explanation about an explain plan