Igor Moiseev wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5370
> Logged by: Igor Moiseev
> Email address: moiseev.igor@gmail.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@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
PG East: http://www.enterprisedb.com/community/nav-pg-east-2010.do