Search Postgresql Archives

Re: Spurious Stalls

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 6/12/2014 12:57 PM, Christopher Nielsen wrote:

With a problem like this, I am not exactly positive how to proceed. I am really looking forward to hearing your thoughts, and opinions, if you can share them.

keep a shell session open with a superuser role (eg, postgres), and next time its hammered, try SELECT * FROM PG_STAT_ACTIVITY

look for things that are waiting = t    and such.

also, if the server is 100% CPU bound, see what processes are using all that CPU. ps -auxw should show the sql commands in addition to 'postgres' or 'postmaster'. you can compare the PID shown in ps output with the pid (or procpid if an older release) in pg_stat_activity, too.



--
john r pierce                                      37N 122W
somewhere on the middle of the left coast




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux