Posgresql Log: lots of parse statements

From: Vikas Sharma <shavikas(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Posgresql Log: lots of parse statements
Date: 2018-03-01 15:23:53
Message-ID: CAN6gwKx7cjSa4aviWp0Eh7zTJqrGXEbnkZTj0gdQC2caTB69PQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

I need help to understand this please. I was looking to do performance
tuning on slow queries so have stated logging queries taking more than 15
secs. In the postgresql log I can see a query which appears only as
"parse" while others appear as execute.

2018-01-21 14:01:16 GMT LOG: duration: 62952.558 ms parse <unnamed>:
select this_.busi_type as business_type from tablea where this_.busi_id =
$1 and this_.busi_date = $2
2018-01-21 14:05:00 GMT LOG: duration: 62952.558 ms parse <unnamed>:
select this_.busi_type as business_type from tablea where this_.busi_id =
$1 and this_.busi_date = $2
2018-01-21 14:17:12 GMT LOG: duration: 62952.558 ms parse <unnamed>:
select this_.busi_type as business_type from tablea where this_.busi_id =
$1 and this_.busi_date = $2
2018-01-21 14:34:08 GMT LOG: duration: 62952.558 ms parse <unnamed>:
select this_.busi_type as business_type from tablea where this_.busi_id =
$1 and this_.busi_date = $2

I don't see this query to appear as execute, so how can find out how much
time it's taking to execute? does this parse timing includes execute also?

Best Regards
Vikas

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2018-03-01 15:30:36 Re: Posgresql Log: lots of parse statements
Previous Message Melvin Davidson 2018-03-01 14:46:58 Re: Version upgrade: is restoring the postgres database needed?