MIME-Version: 1.0
References: 
 <AS4PR02MB874303264FDEF9B160C06DF9EA8EA@AS4PR02MB8743.eurprd02.prod.outlook.com>
In-Reply-To: 
 <AS4PR02MB874303264FDEF9B160C06DF9EA8EA@AS4PR02MB8743.eurprd02.prod.outlook.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Tue, 13 Jan 2026 09:44:49 -0500
Message-ID: 
 <CAKAnmmLSGFSZzyneC-u==0t0ue3GoqkyecbbcJJqTh5tNMmQ2Q@mail.gmail.com>
Subject: Re: small database huge planning time
To: Alexander Kulikov <a-kulikov@hotmail.com>
Cc: pgsql-performance@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000d6bd6b0648460ae8"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKAnmmLSGFSZzyneC-u%3D%3D0t0ue3GoqkyecbbcJJqTh5tNMmQ2Q%40mail.gmail.com>
Precedence: bulk

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

On Tue, Jan 13, 2026 at 4:16=E2=80=AFAM Alexander Kulikov <a-kulikov@hotmai=
l.com>
wrote:

> I have got huge planning time for a query in quite small database in Port=
greSQL 17
>  Planning Time: 452.796 ms
>
> > shared_preload_libraries =3D 'online_analyze, plantuner,
pg_stat_statements'

Maybe try without that 'plantuner' extension?

2. querry itself in query.sql.
>
>
A smaller and cleaner test query would make it much easier to get help, FYI=
.


Cheers,
Greg

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support

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

<div dir=3D"ltr"><div dir=3D"ltr">On Tue, Jan 13, 2026 at 4:16=E2=80=AFAM A=
lexander Kulikov &lt;<a href=3D"mailto:a-kulikov@hotmail.com">a-kulikov@hot=
mail.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_containe=
r"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bord=
er-left:1px solid rgb(204,204,204);padding-left:1ex"><u></u>

 =20
  <div>
    <pre cols=3D"72">I have got huge planning time for a query in quite sma=
ll database in PortgreSQL 17=20
 Planning Time: 452.796 ms
</pre></div></blockquote><div>&gt; shared_preload_libraries =3D &#39;online=
_analyze, plantuner, pg_stat_statements&#39;</div><div><br></div><div>Maybe=
 try without that &#39;plantuner&#39; extension?</div><div><br></div><block=
quote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1=
px solid rgb(204,204,204);padding-left:1ex"><div><pre cols=3D"72"><span sty=
le=3D"color:rgb(77,77,84);font-family:&quot;Noto Sans Display&quot;,Roboto;=
font-size:14px;font-style:normal;font-variant-ligatures:normal;font-variant=
-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-in=
dent:0px;text-transform:none;word-spacing:0px;white-space:pre-wrap;backgrou=
nd-color:rgb(242,242,242);text-decoration-style:initial;text-decoration-col=
or:initial;float:none;display:inline">2. querry itself in query.sql.
</span></pre></div></blockquote><div><br></div><div>A smaller and cleaner t=
est query would make it much easier to get help, FYI.</div><div><br></div><=
/div><div><br clear=3D"all"></div><div>Cheers,</div><div dir=3D"ltr" class=
=3D"gmail_signature"><div dir=3D"ltr"><div>Greg</div><div><br></div><div>--=
</div><div>Crunchy Data - <a href=3D"https://www.crunchydata.com" target=3D=
"_blank">https://www.crunchydata.com</a></div><div>Enterprise Postgres Soft=
ware Products &amp; Tech Support</div><div><br></div></div></div></div>

--000000000000d6bd6b0648460ae8--