what is parse <unnamed>?

From: AI Rumman <rummandba(at)gmail(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: what is parse <unnamed>?
Date: 2015-01-30 01:05:15
Message-ID: CAGoODpdhx2vD1b=F+VLo0QBFNB94ME402ie_heQooKXAm3pAUw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G Johnston 2015-01-30 01:25:18 Re: what is parse <unnamed>?
Previous Message Craig Ringer 2015-01-30 00:59:58 Re: trouble adding a node to BDR