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
pgbr-geral@listas.postgresql.org.br
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Responder a