Search Postgresql Archives

Re: Are indexes blown?

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

 



On Sat, 16 Feb 2008, Phoenix Kiula wrote:

The top output shows httpd on top, and sometimes postmaster, but I don't know how to repeatedly capture it. Any suggestions?

Try this:

top -bc | tee topdata

That will save everything to a file called topdata while also letting you watch it scroll by. Not as easy to catch the bad periods that way, the output is going to be a huge data file, but you'll have a log to sort through of everything. Control-C to get out of there when you're bored.

--
* Greg Smith gsmith@xxxxxxxxxxxxx http://www.gregsmith.com Baltimore, MD

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

[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