Re: How to identify which query is running - reg.

Hi Shan,
please, check your postgresql.conf and find "shared_buffers" and
"log_statement". I am not 100% sure, if statements are logged before
executing.

Regards,
pajout

Shanmugasundaram Doraisamy wrote:

> 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.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>