Re: High-water Mark for number of sessions/connections reached in Postgres

Поиск
Список
Период
Сортировка
Искать
От
Alvaro Herrera
Тема
Re: High-water Mark for number of sessions/connections reached in Postgres
Дата
Msg-id
1281393490-sup-5210@alvh.no-ip.org
Ответ на
Re: High-water Mark for number of sessions/connections reached in Postgres (Scott Marlowe)
Список
Дерево обсуждения
catalog corruption causes "Burgholzer, Robert (DEQ)" <Robert.Burgholzer@deq.virginia.gov>
Re: catalog corruption causes "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: catalog corruption causes "Burgholzer, Robert (DEQ)" <Robert.Burgholzer@deq.virginia.gov>
Re: catalog corruption causes Scott Marlowe <scott.marlowe@gmail.com>
Re: catalog corruption causes Scott Marlowe <scott.marlowe@gmail.com>
Re: catalog corruption causes "Burgholzer, Robert (DEQ)" <Robert.Burgholzer@deq.virginia.gov>
High-water Mark for number of sessions/connections reached in Postgres "Tomeh, Husam" <HTomeh@corelogic.com>
Re: High-water Mark for number of sessions/connections reached in Postgres "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: High-water Mark for number of sessions/connections reached in Postgres Scott Marlowe <scott.marlowe@gmail.com>
Re: High-water Mark for number of sessions/connections reached in Postgres Scott Marlowe <scott.marlowe@gmail.com>
Re: High-water Mark for number of sessions/connections reached in Postgres Alvaro Herrera <alvherre@commandprompt.com>
Re: High-water Mark for number of sessions/connections reached in Postgres "Tomeh, Husam" <HTomeh@corelogic.com>
Re: High-water Mark for number of sessions/connections reached in Postgres Rosser Schwarz <rosser.schwarz@gmail.com> 
Excerpts from Scott Marlowe's message of lun ago 09 18:29:58 -0400 2010:
> If you want a date stamp, you can change the ps ax stuff to look like this:
> 
> date +"%Y-%m-%d %H:%M:%S"|tr "\n" ":";ps ax|grep postgres:|grep -v grep|wc -l

FWIW the "grep" business is best solved by ps itself, something like 
ps ax -C postgres

date +"%Y-%m-%d %H:%M:%S"|tr "\n" ":";ps ax -C  postgres|wc -l

-- 
Álvaro Herrera 
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
В списке pgsql-admin по дате отправления
Предыдущее
От: Scott Marlowe
Дата:
Следующее
От: Tomeh, Husam
Дата:
FAQ