Re: Query went slow all of sudden. ON V 11.3

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: nikhil raj <nikhilraj474(at)gmail(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Query went slow all of sudden. ON V 11.3
Date: 2019-10-04 13:20:44
Message-ID: 20191004132044.GB11241@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message nikhil raj 2019-10-04 13:58:54 Re: Query went slow all of sudden. ON V 11.3
Previous Message nikhil raj 2019-10-04 10:22:26 Query went slow all of sudden. ON V 11.3