How to identify which query is running - reg.

From: Shanmugasundaram Doraisamy <shan(at)ceedees(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to identify which query is running - reg.
Date: 2004-08-11 07:02:53
Message-ID: 4119C49D.6000100@ceedees.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear Group,
We have a java front-end for postgresql 3.4. When
we monitor the system usage using top we find couple of postmasters
taking up close to 90% of the CPU time in total. I would like to know
which are the queries that are currently running at this point of time.
How do we do this?? Another thing that I have noticed is that when I
give df -h, I find there is a partition /dev/shm which is somewhere in
the range of about 128MB and never used. What is this supposed to be.
Is it being not used a good sign or am I loosing on my performance? How
do we get it to be used by the database if it will help improve the
performance. Thanks in advance.

Yours sincerely,
Shan.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Hurst 2004-08-11 07:18:28 Returning a varchar from a functions
Previous Message Peter Eisentraut 2004-08-11 07:02:41 Re: psql: immediately exit after an error?