pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedslow slow query log
2+ messages / 2 participants
[nested] [flat]
* slow slow query log
@ 2008-12-03 20:03 Vladimir Rusinov <vladimir@greenmice.info>
0 siblings, 1 reply; 2+ messages in thread
From: Vladimir Rusinov @ 2008-12-03 20:03 UTC (permalink / raw)
To: pgsql-admin
Hi. [Sorry, English is not my native, so it might be hard to understand me]
We have following in postgresql.conf:
log_destination = 'syslog'
log_min_duration_statement = 2000
log_connections = off
log_disconnections = off
log_line_prefix = 'user=%u,db=%d '
log_statement = 'none'
And sometimes we have large updates like UPDATE table SET data=$1 WHERE
id=123, where $1 is big binary blob (up to 5 megabytes). (Yes, we know that
storing binary data is not good idea, this is our design error, which we are
trying to fix, but this is long process).
Of course this updates goes to slow query log.
And for example right now I can see two such updates (they are running 10+
minutes and using 100% on two cores of our cpu).
And the most interesting: I can see in postgresql log that they were already
finished (I can see it's duration) and now dumping full query text to log
file. Lines on log looks like
Dec 3 08:37:09 db1 postgres[17786]: [4-199722]
246\260hgW\037Q{I\014M\3367\246\326\253\324ZNq\202&.\372\374\275\310\025\026\227k\246Y\311\014\307:\356\206\343\371\015\273\307\
so, this is escaped binary data.
Is there any way to disable dumping query parameters to query log? It would
be ok for us, if this would be just UPDATE table SET data=$1 WHERE id=$2 on
log, we don't need full text on log files.
--
Vladimir Rusinov
http://greenmice.info/
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: slow slow query log
@ 2008-12-17 01:18 Michael Monnerie <michael.monnerie@is.it-management.at>
parent: Vladimir Rusinov <vladimir@greenmice.info>
0 siblings, 0 replies; 2+ messages in thread
From: Michael Monnerie @ 2008-12-17 01:18 UTC (permalink / raw)
To: pgsql-admin
On Mittwoch 03 Dezember 2008 Vladimir Rusinov wrote:
> Is there any way to disable dumping query parameters to query log? It
> would be ok for us, if this would be just UPDATE table SET data=$1
> WHERE id=$2 on log, we don't need full text on log files.
I'd like to have that info too. If you run a bayes database from
spamassassin, a single log entry can take 50+ lines. A restriction to
the number of lines, or length, would be very nice.
mfg zmi
--
// Michael Monnerie, Ing.BSc ----- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import"
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4
// Keyserver: www.keyserver.net Key-ID: 1C1209B4
Attachments:
signature.asc (application/pgp-signature, 196B) download
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-12-17 01:18 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-12-03 20:03 slow slow query log Vladimir Rusinov <vladimir@greenmice.info>
2008-12-17 01:18 ` Michael Monnerie <michael.monnerie@is.it-management.at>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox