Re: different execution time for the same query (and same DB status)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: different execution time for the same query (and same DB status)
From: Julien Rouhaud <rjuju123@xxxxxxxxx>
Date: Sun, 7 Mar 2021 23:08:18 +0800
Cc: "'Francesco De Angelis'" <franc.tozzus@xxxxxxxxx>, pgsql-performance@xxxxxxxxxxxxxxxxxxxx
In-reply-to: <00ce01d71361$4dd83750$e988a5f0$@msym.fr>
References: <CAHWr2Cc0TAEQ-Af_x0zYPjZ5H5QerBU0d6cmzCTC6W5NLd2vew@mail.gmail.com> <CAHWr2CeC_Q+kOBY7O3HmX1qVRHch26yiDw6HeUZGGaBpANubVQ@mail.gmail.com> <00ce01d71361$4dd83750$e988a5f0$@msym.fr>

On Sun, Mar 07, 2021 at 03:51:05PM +0100, Michel SALAIS wrote:
> 
> Have you tried to use EXPLAIN ANALYZE at least?
> 
> It could give valuable information about why this is occurring.

+1, and more generally please follow
https://wiki.postgresql.org/wiki/Slow_Query_Questions.

Follow-Ups:
- Re: different execution time for the same query (and same DB status)
  - From: Tom Lane

References:
- Fwd: different execution time for the same query (and same DB status)
  - From: Francesco De Angelis
- RE: different execution time for the same query (and same DB status)
  - From: Michel SALAIS

Prev by Date: RE: different execution time for the same query (and same DB status)
Next by Date: Re: different execution time for the same query (and same DB status)
Previous by thread: RE: different execution time for the same query (and same DB status)
Next by thread: Re: different execution time for the same query (and same DB status)
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux