Re: strange slow query - lost lot of time somewhere

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: David Rowley <dgrowleyml(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: strange slow query - lost lot of time somewhere
Date: 2022-05-03 04:57:07
Message-ID: 1956750.1651553827@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> writes:
> there is really something strange (see attached file). Looks so this issue
> is much more related to planning time than execution time

You sure there's not something taking an exclusive lock on one of these
tables every so often?

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2022-05-03 05:02:09 Re: strange slow query - lost lot of time somewhere
Previous Message Andres Freund 2022-05-03 04:42:44 Re: mylodon's failures in the back branches