Steve Tucknott wrote:
> Is there a 'monitor' utility that shows connected sessions details (ie
> who is connected, what they are executing etc)?
If you want to see a current "snapshot" of connected clients
and their activity, it's quite simple, just look at the
pg_stat_activity system table. From the UNIX command line
you can type:
psql -c "SELECT * FROM pg_stat_activity" template1
For convenience, I made myself a shell alias for that. ;-)
Hope that helps.
Oliver Fromme, secnetix GmbH & Co KG, Oettingenstr. 2, 80538 München
Any opinions expressed in this message may be personal to the author
and may not necessarily reflect the opinions of secnetix in any way.
"And believe me, as a C++ programmer, I don't hesitate to question
the decisions of language designers. After a decent amount of C++
exposure, Python's flaws seem ridiculously small." -- Ville Vainio
In response to
pgsql-novice by date
|Next:||From: Kunal||Date: 2004-08-24 10:51:01|
|Subject: MySQL vs PostgreSQL|
|Previous:||From: Oliver Elphick||Date: 2004-08-24 09:39:34|
|Subject: Re: DBase Monitor|