Re: small database huge planning time

From: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
To: Alexander Kulikov <a-kulikov(at)hotmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: small database huge planning time
Date: 2026-01-13 14:44:49
Message-ID: CAKAnmmLSGFSZzyneC-u==0t0ue3GoqkyecbbcJJqTh5tNMmQ2Q@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Jan 13, 2026 at 4:16 AM Alexander Kulikov <a-kulikov(at)hotmail(dot)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

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Huanbing Lu 2026-01-13 16:07:33 Re: small database huge planning time
Previous Message Andrei Lepikhov 2026-01-13 09:29:45 Re: small database huge planning time