From: Justin Pryzby <pryzby@telsasoft.com>
To: nikhil raj <nikhilraj474@gmail.com>
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: Query went slow all of sudden. ON V 11.3
Date: Fri, 4 Oct 2019 08:20:44 -0500
Message-ID: <20191004132044.GB11241@telsasoft.com> (raw)
In-Reply-To: <CAG1ps1yzDsdpkoasOgAQOm=TZksfDWS1d-DXt0ufKZ_7CabH=w@mail.gmail.com>
References: <CAG1ps1yzDsdpkoasOgAQOm=TZksfDWS1d-DXt0ufKZ_7CabH=w@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pryzby@telsasoft.com, nikhilraj474@gmail.com, pgsql-performance@lists.postgresql.org
Subject: Re: Query went slow all of sudden. ON V 11.3
In-Reply-To: <20191004132044.GB11241@telsasoft.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox