Funcionou, muito obrigado!

----- Original Message ----- 
From: "Leonardo Cezar" <[EMAIL PROTECTED]>
To: "Comunidade PostgreSQL Brasileira" <[email protected]>
Sent: Monday, June 25, 2007 4:17 PM
Subject: Re: [pgbr-geral] Conexoes simultaneas


On 6/25/07, Leonardo Cezar <[EMAIL PROTECTED]> wrote:
> On 6/25/07, Renan de Oliveira <[EMAIL PROTECTED]> wrote:
>
> > Como posso saber quantas conexoes simultaneas um determinado usuários
está
> > efetuando no postgres?
>
> postgres=# SELECT count(usename) from pg_stat_activity group by usename;

Antes que me apedrejem:

SELECT usename,count(usename) from pg_stat_activity group by usename;

-Leo
-- 
Leonardo Cezar
http://www.hostsystems.com.br
http://www.postgresql.org.br
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral


_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Responder a