monitoring database activity on solaris
| От | David Parker |
|---|---|
| Тема | monitoring database activity on solaris |
| Дата | |
| Msg-id | 07FDEE0ED7455A48AC42AC2070EDFF7C5CF512@corpsrv2.tazznetworks.com обсуждение исходный текст |
| Ответы |
Re: monitoring database activity on solaris
|
| Список | pgsql-general |
According to the 7.4 doc section on monitoring database activity, one should be able to see the current activity happening in a given postgres process. It mentions that on Solaris (which we are running on) you need to use /usr/ucb/ps, and it also says
" your original invocation of the postmaster command must have a shorter ps status display than that provided by each server process "
All I seem to get in my ps is the full postmaster command with all its invocation parameters, and I don't see the postgres process itself. I can't seem to get that full path + parameters out of the postmaster display, if that is even the problem....
I realize that this might be more a Solaris question than a postgres one, but we have a recurring situation where we have a lot of processes chewing up cpu long after all clients have gone away, and that process display would help a great deal! I'd be grateful to anybody running Solaris for any advice.
Thanks.
- DAP
----------------------------------------------------------------------------------
David Parker Tazz Networks (401) 709-5130
В списке pgsql-general по дате отправления: