Hi Laurenz,
Please find attached explain query plan and query.
Regards,
Aditya.
On Friday, October 1, 2021, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> wrote:
> 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 plan as the query never runs fully even
> waiting for say half an hour.
> >
> > We have composite indexes on run_date,status. Do I need to create an
> index on run_date only?
>
> You need to share the query and probably the table definition. EXPLAIN
> output
> (without ANALYZE) will also help.
>
> Yours,
> Laurenz Albe
> --
> Cybertec | https://www.cybertec-postgresql.com
>
>
