RE: Finding number of current connections

Thanks, Tom!

I assume the fact you only mention 7.2 means the current versions have no
way to determine this.

Will 7.2 also be able to let you control how many connections each user is
using?  For instance, will I be able to limit one user to 5 database
connections and another one to 10?  Or will it only report how many are in
use?

Thanks,
Tauren



> Coming soon to a 7.2 near you:
>
> regression=# select * from pg_stat_activity;
>  datid  |  datname   | procpid | usesysid | usename  |
> current_query
> --------+------------+---------+----------+----------+------------
> ---------------------
>  400867 | regression |   29709 |      256 | postgres | select *
> from pg_stat_activity;
>  400867 | regression |     452 |      256 | postgres |
> (2 rows)
>
> (the second backend doesn't have collect_querystring turned on, so it's
> not reporting its current query...)
>
> Hopefully, Jan will get around to writing some documentation about
> this before release ;-)
>
>             regards, tom lane