Skip site navigation (1) Skip section navigation (2)

Re: Calls to find Users and databases open...

From: Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar>
To: "Thomas LeBlanc" <thomasatiem(at)hotmail(dot)com>,pgsql-general(at)postgresql(dot)org
Subject: Re: Calls to find Users and databases open...
Date: 2004-04-30 14:47:57
Message-ID: 200404301147.58626.martin@bugs.unl.edu.ar (view raw or flat)
Thread:
Lists: pgsql-general
El Vie 30 Abr 2004 11:16, Thomas LeBlanc escribió:
> What are the SQL commands to find who is logged on a server, what database
> he/she has open, etc?
>
> Where is this information in the help file or documentation?

select * from pg_stat_activity;

-- 
 11:47:01 up 1 day, 17:09,  3 users,  load average: 0.21, 0.65, 0.89
-----------------------------------------------------------------
Martín Marqués        | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica  |  DBA, Programador, Administrador
             Universidad Nacional
                  del Litoral
-----------------------------------------------------------------

In response to

pgsql-general by date

Next:From: Karl O. PincDate: 2004-04-30 15:26:30
Subject: Re: Plpgsql problem passing ROWTYPE to function
Previous:From: Thomas LeBlancDate: 2004-04-30 14:16:51
Subject: Calls to find Users and databases open...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group