Re: [GENERAL] log_destination = csvlog, line breaks interfere in analysis

2012-09-18 Thread Edson Richter
Em 18/09/2012 04:13, Albe Laurenz escreveu: Craig Ringer wrote: On 09/18/2012 03:21 AM, Edson Richter wrote: 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,0,"duração: 505.494 ms executar : select A, B

Re: [GENERAL] log_destination = csvlog, line breaks interfere in analysis

2012-09-18 Thread Albe Laurenz
Craig Ringer wrote: > On 09/18/2012 03:21 AM, Edson Richter wrote: >> 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,0,"duração: 505.494 ms executar >> : select A, B >> from C join D >>

Re: [GENERAL] log_destination = csvlog, line breaks interfere in analysis

2012-09-17 Thread Craig Ringer
On 09/18/2012 03:21 AM, Edson Richter wrote: 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,0,"duração: 505.494 ms executar : select A, B from C join D on C.id = D.c_id And so on. Yick.

Re: [GENERAL] log_destination = csvlog

2012-09-17 Thread Gavin Flower
On 18/09/12 08:45, Edson Richter wrote: Em 17/09/2012 16:32, Ryan Kelly escreveu: On Mon, Sep 17, 2012 at 04:20:14PM -0300, Edson Richter wrote: 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, an

Re: [GENERAL] log_destination = csvlog

2012-09-17 Thread Edson Richter
Em 17/09/2012 16:32, Ryan Kelly escreveu: On Mon, Sep 17, 2012 at 04:20:14PM -0300, Edson Richter wrote: 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) charac

Re: [GENERAL] log_destination = csvlog, line breaks interfere in analysis

2012-09-17 Thread Edson Richter
... Sorry, by mistake I've duplicated the mail. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] log_destination = csvlog

2012-09-17 Thread Ryan Kelly
On Mon, Sep 17, 2012 at 04:20:14PM -0300, Edson Richter wrote: > 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-0

Re: [GENERAL] log_destination = csvlog

2012-09-17 Thread Edson Richter
Em 17/09/2012 16:32, Ryan Kelly escreveu: On Mon, Sep 17, 2012 at 04:20:14PM -0300, Edson Richter wrote: 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) charac