I pipe my postgresql output to apaches log rotator, and use perl or php
or even shell commands (cut, sort, uniq, etc...) to munge the data for
pretty viewing. I'll see what I've got laying around, but right now I'm
working on three or four other projects at work, and monitoring won't be
an issue for us for another month or two.
On Thu, 2004-12-23 at 10:09, Jason Tesser wrote:
> Does anyone else know of any other tool that can do what I am talking about. I can get this one to work but I would
liketo see a tool that is a little more robust. maybe even a gui client or something?
>
> -----Original Message-----
> From: Lonni J Friedman [mailto:netllama@gmail.com]
> Sent: Thu 12/23/2004 8:50 AM
> To: Jason Tesser
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] monitoring tools
>
> Checkout pqa
>
>
> On Thu, 23 Dec 2004 08:14:41 -0600, Jason Tesser <JTesser@nbbc.edu> wrote:
> > But that will just st in a huge tet sticks all data in text filess. I need a tool that will take that data and give
memeaningful reports. I want to be able to get reports on queries ove rthe last 2 weeks. Which ones were slow etc.. I
dontwant to have to read through 2 weeks worth of logs :-)
> >
> >
> > -----Original Message-----
> > From: Lonni J Friedman [mailto:netllama@gmail.com]
> > Sent: Thu 12/23/2004 8:11 AM
> > To: Jason Tesser
> > Cc: pgsql-general@postgresql.org
> > Subject: Re: [GENERAL] monitoring tools
> >
> > Sure, in postgresql.conf uncomment log_min_duration_statement and set
> > it to whatever value you want to log. This, of course, assumes that
> > you're already logging for the DB.
> >
> > On Thu, 23 Dec 2004 07:27:22 -0600, Jason Tesser <JTesser@nbbc.edu> wrote:
> > > I am looking for a tool in postgres to monitor present and past activity. Foe example in SQLServer there is a
toolthat reports on all queries run in the past say 2 weeks and tells you how long they took etc.. I know I can use
explainin postgres but I want to be able to track my queries
> >
>
