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 like to see a tool that is a little > more robust. maybe even a gui client or something? > > -----Original Message----- > From: Lonni J Friedman [mailto:[EMAIL PROTECTED] > 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 <[EMAIL PROTECTED]> 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 me meaningful reports. I want to > > be able to get reports on queries ove rthe last 2 weeks. Which ones were > > slow etc.. I dont want to have to read through 2 weeks worth of logs :-) > > > > > > -----Original Message----- > > From: Lonni J Friedman [mailto:[EMAIL PROTECTED] > > 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 <[EMAIL PROTECTED]> wrote: > > > I am looking for a tool in postgres to monitor present and past activity. > > > Foe example in SQLServer there is a tool that reports on all queries run > > > in the past say 2 weeks and tells you how long they took etc.. I know I > > > can use explain in postgres but I want to be able to track my queries > > > ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
