John Siracusa <siracusa(at)mindspring(dot)com> writes:
> Process 20753 was hovering around 60-70% CPU usage for a long time.
> I tried to see what that postmaster was doing, but it appeared to be "idle"
> % ps -wwwx -p 20753
> PID TTY STAT TIME COMMAND
> 20753 pts/3 R 26:59 postgres: postgres pdm 192.168.0.35 idle
That seems odd to me too. What PG version is this exactly?
If it happens again, please see if you can get a stack trace from the
not-so-idle process:
$ gdb /path/to/postgres-executable
gdb> attach PID-of-process
gdb> bt
gdb> quit
regards, tom lane