From: | Edson Richter <edsonrichter(at)hotmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | log_destination = csvlog |
Date: | 2012-09-17 19:20:14 |
Message-ID: | BLU0-SMTP381CE3D2CD01B6B13C66151CF950@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dear all,
I've started collecting log information in CSV format, but I need a way
to customize it.
Problem is that I'm collecting slow statements, and the statements have
\n (newline) character, and the piece of
2012-09-17 14:25:33.150
BRT,"thedb","thedb",15660,"10.10.20.1:33485",5054d3ab.3d2c,1,"SELECT",2012-09-15
16:14:51 BRT,10/204822,0,LOG,00000,"duração: 505.494 ms executar
<unnamed>: select A, B
from C join D
on C.id = D.c_id
And so on.
It's not possible to change the application (hours of testing after
changes will not be feasible for 2 million LOC).
How can I tell PostgreSQL that it should remove the line breaks (and
change them into whitespace character) from SQL statements? Or there is
an "regexp" I can use for this purpose?
Thanks,
Edson
From | Date | Subject | |
---|---|---|---|
Next Message | Edson Richter | 2012-09-17 19:21:04 | log_destination = csvlog, line breaks interfere in analysis |
Previous Message | Ryan Kelly | 2012-09-17 19:01:40 | Re: Official C++ API for postgresql? |