Real time query analyzer - Mailing list pgsql-general

From Adrian Suciu
Subject Real time query analyzer
Date
Msg-id 4533A0DA.3070603@netopia-system.com
Whole thread Raw
Responses Re: Real time query analyzer
Re: Real time query analyzer
List pgsql-general
Hi everybody!
I ask you for your help on a problem I have.
I have a postgresql 7.4 running on a dual 4 GB RAM server, but I have
some VERY memory intense queries, that put processor up to 40%. I see
all this info in unix "top" command or ps -aux
Unfortunately they don't show me the query itsself.

Is there a tool for postgres that can show me the queries and the time
they take and the amount of processor is consuming (as Oracle has) ?
I appreciate any help.

Thank you,

Adrian


pgsql-general by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Dates rejected
Next
From: Andreas Kretschmer
Date:
Subject: Re: Real time query analyzer