pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
monitor sessions
2+ messages / 2 participants
[nested] [flat]

* monitor sessions
@ 2003-10-10 12:48 Chris Faulkner <chrisf@oramap.com>
  2003-10-10 13:43 ` Re: monitor sessions Franco Bruno Borghesi <franco@akyasociados.com.ar>
  0 siblings, 1 reply; 2+ messages in thread

From: Chris Faulkner @ 2003-10-10 12:48 UTC (permalink / raw)
  To: pgsql-sql

Hello

Can anyone tell me - is there a system table or view that I can query to
show all current sessions ?

Thanks


Chris





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: monitor sessions
  2003-10-10 12:48 monitor sessions Chris Faulkner <chrisf@oramap.com>
@ 2003-10-10 13:43 ` Franco Bruno Borghesi <franco@akyasociados.com.ar>
  0 siblings, 0 replies; 2+ messages in thread

From: Franco Bruno Borghesi @ 2003-10-10 13:43 UTC (permalink / raw)
  To: Chris Faulkner <chrisf@oramap.com>; +Cc: 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
> 

Attachments:

  signature.asc (application/pgp-signature, 186B) download

^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2003-10-10 13:43 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-10-10 12:48 monitor sessions Chris Faulkner <chrisf@oramap.com>
2003-10-10 13:43 ` Franco Bruno Borghesi <franco@akyasociados.com.ar>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox