Will try to get a query in text format. It looks difficult though.
Regards,
Aditya.
On Fri, Oct 1, 2021 at 4:03 PM hubert depesz lubaczewski
wrote:
> On Fri, Oct 01, 2021 at 02:24:11PM +0530, aditya desai wrote:
> > Hi Laurenz,
> > Please find attached explain query plan and query.
>
> Can you
On Fri, Oct 01, 2021 at 02:24:11PM +0530, aditya desai wrote:
> Hi Laurenz,
> Please find attached explain query plan and query.
Can you show us \d of the table, and exact query you ran?
Also, please, don't send images. This is text, so you can copy-paste it
directly into mail.
Or, put it on som
On Fri, 2021-10-01 at 12:58 +0530, aditya desai wrote:
> Hi,
> Query on one of our partitioned tables which is range partitioned on
> "run"date" column is going to all partitions despite having run_date in WHERE
> clause. "enable_parition_pruning" is also on. I am
> unable to generate a query pl
Hi,
Query on one of our partitioned tables which is range partitioned on
"run"date" column is going to all partitions despite having run_date in
WHERE clause. "enable_parition_pruning" is also on. I am unable to generate
a query plan as the query never runs fully even waiting for say half an
hour.
