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:
> &g
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
Hi,
Can you check by vacuum analyze the database. And run the query.
**Remember don't use Vacuum full.
On Tue, 24 Sep 2019, 12:07 am Luís Roberto Weck, <
luisrobe...@siscobra.com.br> wrote:
> Hi!
>
> Recently I've been looking for bloat in my databases and found a query to
> show which table
