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.
