MIME-Version: 1.0
References: <CAGB0_6600w5C=hvhgfMWCqO9BCwCg+3s0PxXuoQv48NLqTp6dA@mail.gmail.com>
 <CAApHDvq=sj+vVQ6HKOdNLeWbQnHErg5QPSz26s0a90PtY1NLdw@mail.gmail.com>
In-Reply-To: <CAApHDvq=sj+vVQ6HKOdNLeWbQnHErg5QPSz26s0a90PtY1NLdw@mail.gmail.com>
From: =?UTF-8?B?U2HFoW8gR2FudGFy?= <sasog23@gmail.com>
Date: Mon, 20 May 2024 13:09:00 +0200
Message-ID: <CAGB0_640Kv4c9Kq5qDNZCNcAxo-_aO=AaKJqBann+iNiU0imWA@mail.gmail.com>
Subject: Re: problem with query
To: David Rowley <dgrowleyml@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000243be40618e0bb38"
Archived-At: <https://www.postgresql.org/message-id/CAGB0_640Kv4c9Kq5qDNZCNcAxo-_aO%3DAaKJqBann%2BiNiU0imWA%40mail.gmail.com>
Precedence: bulk

--000000000000243be40618e0bb38
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

what helps is
SET enable_nestloop =3D off;
query takes less then 2seconds

but it's probably not a good idea to change this flag

On Wed, 15 May 2024 at 13:23, David Rowley <dgrowleyml@gmail.com> wrote:

> On Wed, 15 May 2024 at 21:08, Sa=C5=A1o Gantar <sasog23@gmail.com> wrote:
> > this query takes more than 8 seconds,
> > if i remove "AND ((pgn.nspname=3D'servicedesk'))" and test it, it takes=
 <1s
>
> Including the EXPLAIN rather than EXPLAIN (ANALYZE, BUFFERS) isn't
> very useful as there's no way to tell if the planner's estimates were
> accurate or not. Also with EXPLAIN only, we don't know where the time
> was spent in the query.
>
> Running the EXPLAIN with "SET track_io_timing =3D 1;" would be even more
> useful.
>
> David
>

--000000000000243be40618e0bb38
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">what helps is =C2=A0 =C2=A0<br>SET enable_nestloop =3D off=
;<br>query takes less then 2seconds<br><br>but it&#39;s probably not a good=
 idea to change this flag<br></div><br><div class=3D"gmail_quote"><div dir=
=3D"ltr" class=3D"gmail_attr">On Wed, 15 May 2024 at 13:23, David Rowley &l=
t;<a href=3D"mailto:dgrowleyml@gmail.com">dgrowleyml@gmail.com</a>&gt; wrot=
e:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0=
.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On Wed, 15 Ma=
y 2024 at 21:08, Sa=C5=A1o Gantar &lt;<a href=3D"mailto:sasog23@gmail.com" =
target=3D"_blank">sasog23@gmail.com</a>&gt; wrote:<br>
&gt; this query takes more than 8 seconds,<br>
&gt; if i remove &quot;AND ((pgn.nspname=3D&#39;servicedesk&#39;))&quot; an=
d test it, it takes &lt;1s<br>
<br>
Including the EXPLAIN rather than EXPLAIN (ANALYZE, BUFFERS) isn&#39;t<br>
very useful as there&#39;s no way to tell if the planner&#39;s estimates we=
re<br>
accurate or not. Also with EXPLAIN only, we don&#39;t know where the time<b=
r>
was spent in the query.<br>
<br>
Running the EXPLAIN with &quot;SET track_io_timing =3D 1;&quot; would be ev=
en more useful.<br>
<br>
David<br>
</blockquote></div>

--000000000000243be40618e0bb38--