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

2005-05-01 Thread Enrico Weigelt
* Cosimo Streppone <[EMAIL PROTECTED]> wrote: Hi, > I'm currently working on something like a `mytop' clone, > also written in Perl with DBI + DBD::Pg interface. > > mytop is a command line utility that displays mysql > server status and clients connected modeled after > `top' unix utility. (htt

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

2005-05-01 Thread Tom Lane
Cosimo Streppone <[EMAIL PROTECTED]> writes: > 1) is it possible to know Pg backend uptime with > SQL queries? Or must I look at postmaster.pid file? > or even something else? I suppose you mean postmaster uptime, not the lifespan of your own connection. We don't track that at the moment,

[SQL] pgtop, display PostgreSQL processes in `top' style

2005-04-30 Thread Cosimo Streppone
Hi everybody, I'm currently working on something like a `mytop' clone, also written in Perl with DBI + DBD::Pg interface. mytop is a command line utility that displays mysql server status and clients connected modeled after `top' unix utility. (http://mytop.sourceforge.net). What I'd like to achiev