public inbox for [email protected]
help / color / mirror / Atom feedFrom: Greg Sabino Mullane <[email protected]>
To: Alexander Kulikov <[email protected]>
Cc: [email protected]
Subject: Re: small database huge planning time
Date: Tue, 13 Jan 2026 09:44:49 -0500
Message-ID: <CAKAnmmLSGFSZzyneC-u==0t0ue3GoqkyecbbcJJqTh5tNMmQ2Q@mail.gmail.com> (raw)
In-Reply-To: <AS4PR02MB874303264FDEF9B160C06DF9EA8EA@AS4PR02MB8743.eurprd02.prod.outlook.com>
References: <AS4PR02MB874303264FDEF9B160C06DF9EA8EA@AS4PR02MB8743.eurprd02.prod.outlook.com>
On Tue, Jan 13, 2026 at 4:16 AM Alexander Kulikov <[email protected]>
wrote:
> I have got huge planning time for a query in quite small database in PortgreSQL 17
> Planning Time: 452.796 ms
>
> > shared_preload_libraries = '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
view thread (5+ messages) latest in thread
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: [email protected]
Cc: [email protected], [email protected]
Subject: Re: small database huge planning time
In-Reply-To: <CAKAnmmLSGFSZzyneC-u==0t0ue3GoqkyecbbcJJqTh5tNMmQ2Q@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox