Postgres Pro
Downloads
Home   >   mailing lists

Re: Query went slow all of sudden. ON V 11.3 - Mailing list pgsql-performance

From nikhil raj
Subject Re: Query went slow all of sudden. ON V 11.3
Date
Msg-id CAG1ps1wtQt=Z=jmXM45ET5zoBNZmAni_Z+7AdSoRpKEss7yDbA@mail.gmail.com
Whole thread Raw
In response to Re: Query went slow all of sudden. ON V 11.3  (Justin Pryzby <pryzby@telsasoft.com>)
Responses Re: Query went slow all of sudden. ON V 11.3  (Michael Lewis <mlewis@entrata.com>)
Re: Query went slow all of sudden. ON V 11.3  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-performance
Tree view
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@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

pgsql-performance by date:

Previous
From: Justin Pryzby
Date:
Subject: Re: Query went slow all of sudden. ON V 11.3
Next
From: Michael Lewis
Date:
Subject: Re: Query went slow all of sudden. ON V 11.3