| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
-----------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Karl O. Pinc | 2004-04-30 15:26:30 | Re: Plpgsql problem passing ROWTYPE to function |
| Previous Message | Thomas LeBlanc | 2004-04-30 14:16:51 | Calls to find Users and databases open... |