Jeff Davis <pgsql@xxxxxxxxxxx> writes: > On Wed, 2010-10-20 at 14:44 -0400, Dimi Paun wrote: >> 23425 postgres 20 0 22008 10m 10m R 99.9 0.5 21:45.87 postmaster >> >> I'd like to figure out what it is doing. How can I figure out what >> statement causes the problem? > It seems strange that the postmaster is eating 99% cpu. Is there a > chance that it's flooded with connection attempts? It's probably a backend process, not the postmaster --- I suspect the OP is using a version of ps that only tells you the original process name by default. "ps auxww" or "ps -ef" (depending on platform) is likely to be more informative. Looking into pg_stat_activity, even more so. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
