pcurse - Monitor Postgres databases
$ pcurse [options] [dbname] [user] for example: $ pcurse -h localhost template1 john --passwd apple
--passwd Default is read from ~/.pgpass --dbname Default is template1 --host Default is localhost --user Default is getlogin() --port Default is 5432
pcurse(1) monitors a Postgres database cluster. It shows statistics on tables, indexes, vacuuming, buffers, etc,.
It is too simple:
1. Select a 'MODE' from the menu. To navigate, use arrow keys, the vi keys (j ,k , m ), or ENTER . TAB (or 'l') moves you to the next window.
2. Most modes requires to select a namespace from the the 'Schemas' listbox. Use arrows, vi keys, ENTER (or SPACE, or ' ' ) seals the selection. Press 'd' to view more acl permissions on schema TAB (or 'l') moves you to the button window.
3. The results are displayed in the bottom window. Use arrows, vi keys, ENTER (or SPACE, or ' ' ) seals the selection. Pressing 'd' to view more results. Ctrl-H displays Help screen Ctrl-F appends the contents of the bottom display to /tmp/pcurse.out In tables mode Ctrl-L displays the last 20 updates in table In tables and database mode Ctrl-A analyses at table or database In tables and database mode Ctrl-V analyses at table or database Press 'd' to exit from any of the above tables. TBB (or 'l') takes you back to the starting menu.
4. Press 'q' to quit the program. Thank you for flying Pcurse!
Ioannis Tambouras, <ioannis@cpan.org>
Copyright (C) 2008 by Ioannis Tambouras
This library is free software; you can redistribute it and/or modify it under the same terms of GPLv3
To install Pg::Pcurse, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Pg::Pcurse
CPAN shell
perl -MCPAN -e shell install Pg::Pcurse
For more information on module installation, please visit the detailed CPAN module installation guide.