On 9/14/06, Jérôme BENOIS <benois@argia-engineering.fr> wrote:
> PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
> 15667 postgres 25 0 536m 222m 532m R 98.8 11.0 1:39.29 postmaster
> 19533 postgres 25 0 535m 169m 532m R 92.9 8.3 0:38.68 postmaster
> 16278 postgres 25 0 537m 285m 532m R 86.3 14.1 1:37.56 postmaster
Enable stats_command_string and see which queries are running on these
backends by selecting on pg_stat_activity.
Do the queries finish? Do you have them in your query log?
--
Guillaume