Quick Links

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

From:	Julien Rouhaud <rjuju123(at)gmail(dot)com>
To:	Michel SALAIS <msalais(at)msym(dot)fr>
Cc:	'Francesco De Angelis' <franc(dot)tozzus(at)gmail(dot)com>, pgsql-performance(at)lists(dot)postgresql(dot)org
Subject:	Re: different execution time for the same query (and same DB status)
Date:	2021-03-07 15:08:18
Message-ID:	20210307150818.hiqv26pmrovi3ced@nol
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-performance

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.

In response to

RE: different execution time for the same query (and same DB status) at 2021-03-07 14:51:05 from Michel SALAIS

Responses

Re: different execution time for the same query (and same DB status) at 2021-03-07 16:37:22 from Tom Lane

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Tom Lane	2021-03-07 16:37:22	Re: different execution time for the same query (and same DB status)
Previous Message	Michel SALAIS	2021-03-07 14:51:05	RE: different execution time for the same query (and same DB status)