Postgresql planning time too high
От
Sterpu Victor
Тема
Postgresql planning time too high
Дата
Msg-id
emd93eb533-aade-42ef-8609-2dccab1463d4@victor-pc
Список
Дерево обсуждения
Postgresql planning time too high "Sterpu Victor" <victor@caido.ro>
RE: Postgresql planning time too high Fırat Güleç <firat.gulec@hepsijet.com>
Re[2]: Postgresql planning time too high "Sterpu Victor" <victor@caido.ro>
Re: Postgresql planning time too high Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Re[2]: Postgresql planning time too high Pavel Stehule <pavel.stehule@gmail.com>
Re[4]: Postgresql planning time too high "Sterpu Victor" <victor@caido.ro>
Re: Re[4]: Postgresql planning time too high Pavel Stehule <pavel.stehule@gmail.com>
Re: Re[4]: Postgresql planning time too high Michael Lewis <mlewis@entrata.com>
Re[4]: Postgresql planning time too high "Sterpu Victor" <victor@caido.ro>
Re[3]: Postgresql planning time too high "Sterpu Victor" <victor@caido.ro>
Re[2]: Postgresql planning time too high "Sterpu Victor" <victor@caido.ro>
RE: Re[2]: Postgresql planning time too high Fırat Güleç <firat.gulec@hepsijet.com>
Re[4]: Postgresql planning time too high "Sterpu Victor" <victor@caido.ro>
Re[4]: Postgresql planning time too high "Sterpu Victor" <victor@caido.ro>
Re: Postgresql planning time too high Luís Roberto Weck <luisroberto@siscobra.com.br>
Hello
I'm on a PostgreSQL 12.1 and I just restored a database from a backup.
When I run a query I get a big execution time: 5.482 ms
After running EXPLAIN ANALYZE I can see that the "Planning Time: 5165.742 ms" and the "Execution Time: 6.244 ms".
The database is new(no need to vacuum) and i'm the only one connected to it. I use a single partition on the harddrive.
I also tried this on a postgresql 9.5 and the result was the same.
I'm not sure what to do to improve this situation.
The query and the explain is attached.
Thank you
В списке pgsql-performance по дате отправления
