pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Suspicious top output 3+ messages / 3 participants [nested] [flat]
* Suspicious top output @ 2008-04-22 18:34 Rafael Barrera Oro <rafael@akyasociados.com.ar> 2008-04-22 23:50 ` Re: Suspicious top output Ivan Voras <ivoras@geri.cc.fer.hr> 2008-04-23 05:43 ` Re: Suspicious top output Greg Smith <gsmith@gregsmith.com> 0 siblings, 2 replies; 3+ messages in thread From: Rafael Barrera Oro @ 2008-04-22 18:34 UTC (permalink / raw) To: pgsql-performance Hello, i have a postgresql server running and from time to time it gets painfully slow. When this happens i usually connect to the server and run a "top" command, the output i get is filled with lines like the following 71872 pgsql 1 4 0 48552K 42836K sbwait 1:41 4.79% postgres Are those connections that were not closed or something like that? should i worry? Thanks in advance, as always yours trully Rafael ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Suspicious top output 2008-04-22 18:34 Suspicious top output Rafael Barrera Oro <rafael@akyasociados.com.ar> @ 2008-04-22 23:50 ` Ivan Voras <ivoras@geri.cc.fer.hr> 1 sibling, 0 replies; 3+ messages in thread From: Ivan Voras @ 2008-04-22 23:50 UTC (permalink / raw) To: pgsql-performance Rafael Barrera Oro wrote: > Hello, i have a postgresql server running and from time to time it gets > painfully slow. When this happens i usually connect to the server and > run a "top" command, the output i get is filled with lines like the > following > > 71872 pgsql 1 4 0 48552K 42836K sbwait 1:41 4.79% > postgres > > Are those connections that were not closed or something like that? This looks like FreeBSD; "sbwait" state is socket buffer wait, and guessing from the CPU usage the process seems to be talking to another process. > should i worry? Don't know. Are you sure all client processes disconnect properly from the database? ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Suspicious top output 2008-04-22 18:34 Suspicious top output Rafael Barrera Oro <rafael@akyasociados.com.ar> @ 2008-04-23 05:43 ` Greg Smith <gsmith@gregsmith.com> 1 sibling, 0 replies; 3+ messages in thread From: Greg Smith @ 2008-04-23 05:43 UTC (permalink / raw) To: Rafael Barrera Oro <rafael@akyasociados.com.ar>; +Cc: pgsql-performance On Tue, 22 Apr 2008, Rafael Barrera Oro wrote: > Hello, i have a postgresql server running and from time to time it gets > painfully slow. The usual information you should always include when posting messages here is PostgreSQL and operating system versions. > When this happens i usually connect to the server and run a "top" > command The other thing you should fire up in another window is "vmstat 1" to figure out just what's going on in general. The great thing about those is you can save them when you're done and easily analyze the results later easily, which is trickier to do with top. > 71872 pgsql 1 4 0 48552K 42836K sbwait 1:41 4.79% > postgres Some searching found this interesting suggestion from Darcy about things stuck in sbwait: http://unix.derkeiler.com/Mailing-Lists/FreeBSD/performance/2004-03/0015.html -- * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2008-04-23 05:43 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2008-04-22 18:34 Suspicious top output Rafael Barrera Oro <rafael@akyasociados.com.ar> 2008-04-22 23:50 ` Ivan Voras <ivoras@geri.cc.fer.hr> 2008-04-23 05:43 ` Greg Smith <gsmith@gregsmith.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox