PostgreSQL Server Status

Lists: pgsql-novice
From: "M(dot) Bastin" <marcbastin(at)mindspring(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: PostgreSQL Server Status
Date: 2003-09-05 16:17:35
Message-ID: a06002007bb7e65d28189@[192.168.0.14]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-novice

Hi all,

I would like to know what the best queries are to get system status info like:

Number of connected users
List of connected user names with the database to which they are connected
List of used databases with number of currently connected users
Last startup date and time of PostgreSQL
IP address

etc. (If anybody can think of anything else)
I already know SELECT VERSION() ;-)

Thanks,

Marc (on version 7.3, on a client over TCP/IP)