Re: monitor sessions

From: Franco Bruno Borghesi <franco(at)akyasociados(dot)com(dot)ar>
To: Chris Faulkner <chrisf(at)oramap(dot)com>
Cc: Pgsql-Sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: monitor sessions
Date: 2003-10-10 13:43:16
Message-ID: 1065793395.7220.9.camel@taz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

SELECT * FROM pg_stat_activity;

On Fri, 2003-10-10 at 09:48, Chris Faulkner wrote:

> Hello
>
> Can anyone tell me - is there a system table or view that I can query to
> show all current sessions ?
>
> Thanks
>
>
> Chris
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Ian Barwick 2003-10-10 19:08:59 Re: [postgres] Copy Timestamp NULL
Previous Message Bram 2003-10-10 12:50:18 Inquiry From Form [pgsql]