Re: Posgresql Log: lots of parse statements

On Thursday, March 1, 2018, Vikas Sharma <shavikas(at)gmail(dot)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.