Re: [HACKERS] Postgresql log analyzer

2001-08-21 Thread Andrew McMillan
Gilles DAROLD wrote: > > Hi all, > > Here is a first draft generated by a log analyzer for postgres I've wrote today: > > http://www.samse.fr/GPL/log_report/ > > In all this html report there is what I'm able to extract minus the statistics. > > I need to know what people want to see repo

Re: [HACKERS] Postgresql log analyzer

2001-08-21 Thread Gilles DAROLD
Hi all, Here is a first draft generated by a log analyzer for postgres I've wrote today: http://www.samse.fr/GPL/log_report/ In all this html report there is what I'm able to extract minus the statistics. I need to know what people want to see reported to have a powerfull log analyzer, I

Re: [HACKERS] Postgresql log analyzer

2001-08-21 Thread Peter Eisentraut
Gilles DAROLD writes: > Is it possible to have it into the last line as we have the information of > the database > shutdown timestamp in the first line ? We not just turn time stamping on? > Also, an other question is why using timestamp into the other log instead of > the value > of time in

[HACKERS] Postgresql log analyzer

2001-08-21 Thread Gilles DAROLD
Hi all, I'm currently trying to develop a log analyzer for PostgreSQL logs and at the first stage I'm finding a little problem with the postgresql.conf option log_timestamp. The problem is that if this option is set to false we have no idea of when the backend is started: DEBUG: database syste