pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Julien Rouhaud <rjuju123@gmail.com>
To: Michel SALAIS <msalais@msym.fr>
Cc: Francesco De Angelis <franc.tozzus@gmail.com>
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: different execution time for the same query (and same DB status)
Date: Sun, 7 Mar 2021 23:08:18 +0800
Message-ID: <20210307150818.hiqv26pmrovi3ced@nol> (raw)
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.

view thread (10+ messages)  latest in thread

Message-ID: <20210307150818.hiqv26pmrovi3ced@nol>
Permalink:  ../20210307150818.hiqv26pmrovi3ced@nol/
Also on:    postgresql.org/message-id/20210307150818.hiqv26pmrovi3ced@nol

copy link · copy postgr.es

reply

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: rjuju123@gmail.com, msalais@msym.fr, franc.tozzus@gmail.com, pgsql-performance@lists.postgresql.org
  Subject: Re: different execution time for the same query (and same DB status)
  In-Reply-To: <20210307150818.hiqv26pmrovi3ced@nol>

* 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