| 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: | Whole Thread | Raw Message | 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.
| 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? |