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



Reply via email to