Обсуждение: what is parse ?

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.

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."