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