Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres sometimes stalling on 'percentile_cont' - Mailing list pgsql-general

From Tom Lane
Subject Re: Postgres sometimes stalling on 'percentile_cont'
Date
Msg-id 13894.1531419210@sss.pgh.pa.us
Whole thread Raw
In response to Re: Postgres sometimes stalling on 'percentile_cont'  (Tom van Tilburg <tom.van.tilburg@gmail.com>)
List pgsql-general
Tree view 
Tom van Tilburg <tom.van.tilburg@gmail.com> writes:
> Problem is that the query is not slow, it just stalls and never finishes (
> I waited several hours for a 2 seconds query). Would it still be possible
> to derive an EXPLAIN ANALYZE from it in that case?

No, not really, but it'd be sufficient to compare EXPLAIN (without
ANALYZE) output for the slow and fast cases.  What I'm wondering about
is whether the shape of the plan changes.

            regards, tom lane

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: How to watch for schema changes
Next
From: Igor Korot
Date:
Subject: Re: How to watch for schema changes