| From: | Markus Schaber <schabi(at)logix-tt(dot)com> |
|---|---|
| To: | Cosimo Streppone <cosimo(at)streppone(dot)it> |
| Cc: | pgsql-announce(at)postgresql(dot)org, "\"\"DBD:\"(at)svr1(dot)postgresql(dot)org\"(at)logix-tt(dot)com:Pg list" <dbdpg-general(at)gborg(dot)postgresql(dot)org>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: [ANNOUNCE] pgtop, display PostgreSQL processes in `top' style |
| Date: | 2005-05-02 22:09:56 |
| Message-ID: | 4276A534.7060607@logix-tt.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-announce 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Wheeler | 2005-05-02 23:23:29 | Re: [Dbdpg-general] [ANNOUNCE] pgtop, display PostgreSQL processes in `top' style |
| Previous Message | Thomas F.O'Connell | 2005-05-02 22:09:13 | Re: [ANNOUNCE] IMPORTANT: two new PostgreSQL security problems found |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Wheeler | 2005-05-02 23:23:29 | Re: [Dbdpg-general] [ANNOUNCE] pgtop, display PostgreSQL processes in `top' style |
| Previous Message | Joel Fradkin | 2005-05-02 21:10:45 | Re: Function or Field? |