Hi Justin,
Its been executing for 35 + mins due to statement time out its getting canceled.
Yes
temp_10032019020721_4470table index is there on
cr column.
On Fri, Oct 4, 2019 at 6:50 PM Justin Pryzby <pryzby@xxxxxxxxxxxxx> wrote:
On Fri, Oct 04, 2019 at 03:52:26PM +0530, nikhil raj wrote:
> Hi All,
>
> All of sudden the query went slow before the query was executing in 30- 35
> sec now even after 30 mins i am not getting any result.
Can you show "explain(analyze,buffers)" when it's running fast, and at least
"explain" when it's slow ?
> later I have dropped a table ( t_meners) and recreated it and again it
> started working very fast.
What indexes exist on that table and on temp_10032019020721_4470 ?
Justin
