NAME
pcurse - Monitor Postgres databases
SYNOPSIS
$ pcurse [options] [dbname] [user]
for example:
$ pcurse template1 john --passwd appleoptions
--dbname Default is template1
--host Default is localhost
--user Default is getlogin()
--passwd Default is read from ~/.pgpass
--port Default is 5432DESCRIPTION
pcurse(1) monitors a Postgres database cluster. It shows statistics on tables, indexes, vacuuming, buffers, etc,.
INVOCATION
USAGE
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. Keep pressing 'd' to view more details on results. 'D' key displays records of a table (CAUTION: no safe for long tables) 'A' key attemps to analyze the table, or database 'V' key attemps to vacume the table, or database TBB (or 'l') takes you back to the starting menu.
4. Press 'q' to quit the program
SEE ALSO
AUTHOR
Ioannis Tambouras, <ioannis@cpan.org>
COPYRIGHT AND LICENSE
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