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 <pry...@telsasoft.com> 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 >
