Re: Posgresql Log: lots of parse statements

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Posgresql Log: lots of parse statements
Дата
Msg-id CAKFQuwbLaXQt3fpvaehjdsCYhAd1xxNcfx7iWMVnZ-HR5j_OHQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Posgresql Log: lots of parse statements  (Vikas Sharma <shavikas@gmail.com>)
Список pgsql-general
On Thursday, March 1, 2018, Vikas Sharma <shavikas@gmail.com> wrote:
Thanks David,

But why are there so many parse statement occurances for one query? Does postgres parse the statement everytime before  execution or parse the query only first time it is loaded in memory and reuse the same parsed plan until it ages out of memory?.

In the log I can see these parse statement occurances about 400 times in a day and everytime taking longer than 15 secs.

Please don't top-post replies.

Normally "parse unnamed" happens when client interfaces execute prepared statements using parse-bind-execute protocol.  If you want to reduce the number you will need to change your application.  As for the time it takes its impossible to say without knowing more about the environment and query.

David J.

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Posgresql Log: lots of parse statements
Следующее
От: Melvin Davidson
Дата:
Сообщение: Re: Version upgrade: is restoring the postgres database needed?