PostgreSQL Analytics from The PostgreSQL Company -- Command Prompt, Inc. -- bring forth the underlying statistics of PostgreSQL to provide the DBA vital information about your PostgreSQL infrastructure.
- How long is our current database server going to last?
- Which indexes are being used on this relation (table)?
- How many transactions are we really doing?
- How much data are we really pulling over the wire?
- What is our most heavily used index?
This information, provided at predetermined intervals allows companies using PostgreSQL to know which indexes are being used, transaction velocity, which relations (tables) aren't using indexes and much, much more!
Click here for a PDF of some sample reports.
- Web based, no software to install
- Works with firewalls (needs SSH)
- Provides vital information, when you need it
- Variable duration