| 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: | Whole Thread | Raw Message | 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? |