Re: BUG #5370: Shortcut for currently connected users

Igor Moiseev wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5370
> Logged by: Igor Moiseev
> Email address: moiseev(dot)igor(at)gmail(dot)com
> PostgreSQL version: 8.3.9
> Operating system: Ubuntu
> Description: Shortcut for currently connected users
> Details:
>
> Dear developers, thank you for the perfect product!
>
> I'd like to request one shortcut in psql terminal. That would simplify a lot
> manual administrating of postgresql servers! The query I need always to
> execute is
>
> select * from pg_stat_activity ;
>
> That would be nice to have something like "\cu" as a shortcut for this
> query!!

Add this to your ~/.psqlrc:

\set mon 'SELECT * FROM pg_stat_activity';

and then you can use this in psql:

test=> :mon
datid | datname | procpid | usesysid | usename | application_name |
...

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

PG East: http://www.enterprisedb.com/community/nav-pg-east-2010.do