Vikas Sharma <shavikas@xxxxxxxxx> writes: > But why are there so many parse statement occurances for one query? A "parse" log entry is recorded when the client sends a Parse protocol message. So the answer to that question needs to be sought in your client application's logic. > In the log I can see these parse statement occurances about 400 times in a > day and everytime taking longer than 15 secs. That seems like a mighty long time for parse analysis. Maybe you're having difficulties with something taking exclusive locks, thereby blocking other queries? regards, tom lane
