What are approx row counts and distribution of data in the concerned tables
and columns? Have you run EXPLAIN (query plan) to get the plan that will be
executed and can you paste on https://explain.depesz.com/ and share the
link that results?
Do you have an index on LOWER( cr ) on table temp_10032
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 wrote:
> On Fri, Oct 04, 2019 at 03:52:26PM +0530, nikhil raj wrote:
> > Hi All,
> >
> > All
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" whe
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.
later I have dropped a table ( t_meners) and recreated it and again it
started working very fast.
is there way to find what happen on that why is not any is
