monitoring tools
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 in a real enviroment while the apps are using them. Is there a tool that 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 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 in a real enviroment while the apps are using them. Is there a tool that 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 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: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 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 in a real enviroment while the apps are using them. Is there a tool that can help me?
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman netllama@gmail.com
LlamaLand http://netllama.linux-sxs.org
Import Notes
Resolved by subject fallback
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 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:netllama@gmail.com]
Sent: Thu 12/23/2004 8:11 AM
To: Jason Tesser
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] monitoring toolsSure, 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 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
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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 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: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 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:netllama@gmail.com]
Sent: Thu 12/23/2004 8:11 AM
To: Jason Tesser
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] monitoring toolsSure, 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 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
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman netllama@gmail.com
LlamaLand http://netllama.linux-sxs.org
Import Notes
Resolved by subject fallback
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.
Show quoted text
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:netllama@gmail.com]
Sent: Thu 12/23/2004 8:50 AM
To: Jason Tesser
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] monitoring toolsCheckout 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 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:netllama@gmail.com]
Sent: Thu 12/23/2004 8:11 AM
To: Jason Tesser
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] monitoring toolsSure, 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 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
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 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:netllama@gmail.com]
Sent: Thu 12/23/2004 8:50 AM
To: Jason Tesser
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] monitoring toolsCheckout 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 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:netllama@gmail.com]
Sent: Thu 12/23/2004 8:11 AM
To: Jason Tesser
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] monitoring toolsSure, 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 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
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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 needed and 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 mind so much I was just looking to see if anyone else had some options. Our main platform is j2ee but we do flirt with php as 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>
Import Notes
Resolved by subject fallback
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 needed and 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 mind so much I was just looking to see if anyone else had some options. Our main platform is j2ee but we do flirt with php as 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 toolspqa 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