Re: small database huge planning time - Mailing list pgsql-performance

From Greg Sabino Mullane
Subject Re: small database huge planning time
Date
Msg-id CAKAnmmLSGFSZzyneC-u==0t0ue3GoqkyecbbcJJqTh5tNMmQ2Q@mail.gmail.com
Whole thread Raw
In response to small database huge planning time  (Alexander Kulikov <a-kulikov@hotmail.com>)
List pgsql-performance
On Tue, Jan 13, 2026 at 4:16 AM Alexander Kulikov <a-kulikov@hotmail.com> 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

--
Enterprise Postgres Software Products & Tech Support

pgsql-performance by date:

Previous
From: Andrei Lepikhov
Date:
Subject: Re: small database huge planning time
Next
From: Huanbing Lu
Date:
Subject: Re: small database huge planning time