On Wed, 2024-11-06 at 22:43 +0530, Ramakrishna m wrote:
> One of the queries, which retrieves a single record from a table with 16 hash partitions,
> is taking more than 10 seconds to execute. In contrast, when we run the same query manually,
> it completes within milliseconds.
If I read your file right, the slow execution has an additional "LIMIT 55".
That can make a difference.
In general, you can use auto_explain to get the execution plan of the slow query.
Yours,
Laurenz Albe
