Thread: monitoring tools
I am looking for a tool in postgres to monitor present and past activity. Foe example in SQLServer there is a tool thatreports on all queries run in the past say 2 weeks and tells you how long they took etc.. I know I can use explain inpostgres but I want to be able to track my queries in a real enviroment while the apps are using them. Is there a toolthat can help me?
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 tool thatreports on all queries run in the past say 2 weeks and tells you how long they took etc.. I know I can use explain inpostgres but I want to be able to track my queries in a real enviroment while the apps are using them. Is there a toolthat can help me? -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ L. Friedman netllama@gmail.com LlamaLand http://netllama.linux-sxs.org
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 meaningfulreports. 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 tool thatreports on all queries run in the past say 2 weeks and tells you how long they took etc.. I know I can use explain inpostgres but I want to be able to track my queries in a real enviroment while the apps are using them. Is there a toolthat can help me? -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ L. Friedman netllama@gmail.com LlamaLand http://netllama.linux-sxs.org
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 tool thatreports on all queries run in the past say 2 weeks and tells you how long they took etc.. I know I can use explain inpostgres but I want to be able to track my queries > -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ L. Friedman netllama@gmail.com LlamaLand http://netllama.linux-sxs.org
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 tool thatreports on all queries run in the past say 2 weeks and tells you how long they took etc.. I know I can use explain inpostgres but I want to be able to track my queries > -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ L. Friedman netllama@gmail.com LlamaLand http://netllama.linux-sxs.org
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 > > >
pqa does exactly what your original question requested. Sounds like what you really want is a GUI for pqa. On Thu, 23 Dec 2004 10:09:51 -0600, Jason Tesser <JTesser@nbbc.edu> 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 -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ L. Friedman netllama@gmail.com LlamaLand http://netllama.linux-sxs.org
maybe We don't mind the command line but my college at work doesn't like to bring in other technologies where not neededand he feels like this woulr be doing that. it is ruby so if we need to modify it we need to learn ruby. I dont mindso much I was just looking to see if anyone else had some options. Our main platform is j2ee but we do flirt with phpas well. all and all though I liked pqa. Can it be run from windows? -----Original Message----- From: Lonni J Friedman [mailto:netllama@gmail.com] Sent: Thu 12/23/2004 10:39 AM To: Jason Tesser Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] monitoring tools pqa does exactly what your original question requested. Sounds like what you really want is a GUI for pqa. <snip>
I dunno, can ruby by used in windows? I haven't touched a windows box in about 10 years. On Thu, 23 Dec 2004 11:50:08 -0600, Jason Tesser <JTesser@nbbc.edu> wrote: > maybe We don't mind the command line but my college at work doesn't like to bring in other technologies where not neededand he feels like this woulr be doing that. it is ruby so if we need to modify it we need to learn ruby. I dont mindso much I was just looking to see if anyone else had some options. Our main platform is j2ee but we do flirt with phpas well. all and all though I liked pqa. Can it be run from windows? > > > -----Original Message----- > From: Lonni J Friedman [mailto:netllama@gmail.com] > Sent: Thu 12/23/2004 10:39 AM > To: Jason Tesser > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] monitoring tools > > pqa does exactly what your original question requested. Sounds like > what you really want is a GUI for pqa. > > > <snip> > > -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ L. Friedman netllama@gmail.com LlamaLand http://netllama.linux-sxs.org
* Lonni J Friedman <netllama@gmail.com> [1217 18:17]: > I dunno, can ruby by used in windows? I haven't touched a windows box > in about 10 years. Yup, see : http://rubyforge.org/projects/rubyinstaller/ -- 'Interesting. No, wait, the other thing - Tedious.' -- Bender Rasputin :: Jack of All Trades - Master of Nuns