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 (view raw or flat )
Thread:
2005-04-30 22:10:30 from Cosimo Streppone <cosimo(at)streppone(dot)it>
2005-05-02 03:04:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-05-02 03:55:53 from Enrico Weigelt <weigelt(at)metux(dot)de>
2005-05-02 22:09:56 from Markus Schaber <schabi(at)logix-tt(dot)com>
2005-05-04 14:28:19 from Jeff - <threshar(at)torgo(dot)978(dot)org>
2005-05-02 23:23:29 from David Wheeler <david(at)kineticode(dot)com>
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
In response to
Responses
pgsql-announce by date
Next :From: David WheelerDate: 2005-05-02 23:23:29Subject : Re: [Dbdpg-general] [ANNOUNCE] pgtop, display PostgreSQL processes in `top' stylePrevious :From : Thomas F.O'ConnellDate : 2005-05-02 22:09:13Subject : Re: [ANNOUNCE] IMPORTANT: two new PostgreSQL security problems found
pgsql-sql by date
Next :From: David WheelerDate: 2005-05-02 23:23:29Subject : Re: [Dbdpg-general] [ANNOUNCE] pgtop, display PostgreSQL processes in `top' stylePrevious :From : Joel FradkinDate : 2005-05-02 21:10:45Subject : Re: Function or Field?
