Re: 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(at)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(at)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(at)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(at)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(at)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(at)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(at)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(at)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(at)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.