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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
