what is parse <unnamed>?

rummandba wrote

Hi All,

I am facing some slow sqls in my database as follows:

2015-01-29 18:57:19.777 CST [29024][user@user] 10.6.48.226(59246): [1-1]
LOG: duration: 3409.729 ms parse
<unnamed>
:
2015-01-29 18:57:19.782 CST [29140][user@user] 10.6.48.227(36662): [1-1]
LOG: duration: 3468.549 ms parse
<unnamed>
:
2015-01-29 18:57:19.785 CST [29512][user@db] 10.6.48.227(37110): [1-1]
LOG:
duration: 3505.666 ms parse
<unnamed>
:
2015-01-29 18:57:19.799 CST [28340][user@user] 10.6.48.224(36070): [1-1]
LOG: duration: 3551.065 ms parse
<unnamed>
:
2015-01-29 18:57:19.803 CST [29678][user@db] 10.6.48.226(59748): [1-1]
LOG:
duration: 3557.675 ms parse
<unnamed>
:
2015-01-29 18:57:19.814 CST [27185][user@db] 10.6.48.224(35502): [1-1]
LOG:
duration: 3575.141 ms parse
<unnamed>
: INSERT INTO schema.table
(id,aac_id,create_time,event_type,details) VALUES($1,$2,$3,$4,$5)
2015-01-29 18:57:19.816 CST [29604][user@db] 10.6.48.226(59600): [1-1]
LOG:
duration: 3508.277 ms parse
<unnamed>
:
2015-01-29 18:57:19.816 CST [27586][user@db] 10.6.48.225(38279): [1-1]
LOG:
duration: 3540.860 ms parse
<unnamed>
: INSERT INTO schema.table
(id,aac_id,create_time,event_type,details) VALUES($1,$2,$3,$4,$5)
2015-01-29 18:57:19.826 CST [28996][user@db] 10.6.48.225(39696): [1-1]
LOG:
duration: 3589.108 ms parse
<unnamed>
: SELECT id, location_ts, type,
aac_id, latitude, longitude, accuracy, source, create_time, modified_time
FROM schema.table2 WHERE aac_id = $1 AND type = 'E'

This query are running fine when I am executing them separately.

Can you please let me know what does it mean by
parse
<unnamed>
?

Thanks.

If you PREPARE a query you can assign it a name which will then be logged.
If a query does not have a name you end up seeing <unnamed> where the name
would go.

You indeed have issues if simple query parsing is taking 3.5 seconds...

I don't know the specifics of how these are measured and you provided
insufficient information for anyone to hazard even a guess.

David J.

--
View this message in context: http://postgresql.nabble.com/what-is-parse-unnamed-tp5836072p5836082.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

On 01/29/2015 05:05 PM, AI Rumman wrote:

Hi All,

This query are running fine when I am executing them separately.

Can you please let me know what does it mean by
parse <unnamed>
?

It means you prepared an unnamed statement and it is parsing that statement.

JD

Thanks.

--
Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, @cmdpromptinc
"If we send our children to Caesar for their education, we should
not be surprised when they come back as Romans."

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general