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
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? |