Search Postgresql Archives
need explanation about an explain plan
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: need explanation about an explain plan
From
: Marc Millas <marc.millas@xxxxxxxxxx>
Date
: Wed, 28 Jun 2023 17:22:12 +0200
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
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Follow-Ups
:
Re: need explanation about an explain plan
From:
Marc Millas
Prev by Date:
Re: pgbouncer
Next by Date:
Re: need explanation about an explain plan
Previous by thread:
Replication between different 15.x minor versions ok?
Next by thread:
Re: need explanation about an explain plan
Index(es):
Date
Thread
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]