Re: [ANNOUNCE] pgtop, display PostgreSQL processes in `top' style

Поиск
Список
Период
Сортировка
От Markus Schaber
Тема Re: [ANNOUNCE] pgtop, display PostgreSQL processes in `top' style
Дата
Msg-id 4276A534.7060607@logix-tt.com
обсуждение исходный текст
Ответ на pgtop, display PostgreSQL processes in `top' style  (Cosimo Streppone <cosimo@streppone.it>)
Ответы Re: [ANNOUNCE] pgtop, display PostgreSQL processes in `top' style
Список pgsql-sql
Hi, Cosimo,

Cosimo Streppone wrote:

> 1) is it possible to know Pg backend uptime with
>    SQL queries? Or must I look at postmaster.pid file?
>    or even something else?

In contrib, there's a function caled backend_pid() defined in
misc_utils.sql, it may be helpful for you.

markus

В списке pgsql-sql по дате отправления: