Postgres Enterprise Manager™ Capacity Planning and Forecasting
Capacity Planning and Forecasting
Capacity Manager shines a bright light on your hardware utilization by allowing you to specify the automatic collection of desired performance statistics. Then, you can customize which metrics to analyze, including a historical trend analysis over specified blocks of time. The collected data and subsequent analysis allow you to forecast your resource consumption trends and help plan your data center upgrades or expansion. Capacity Manager also gives you the ability to customize your reports, viewing in graphs and tabular data.
![]() |
Visual Database Management
Postgres Enterprise Manager provides you with a single management console that allows you to visually manage all aspects of your PostgreSQL servers. You can start and stop PostgreSQL instances, visually change configuration parameters, manage user accounts and security, create and maintain databases, handle all storage management functions tables and associated objects, develop SQL code in a smart editor, perform general backup and restore operations, and register new servers re-using registration for all clients. Postgres Enterprise Manager is the only tool available with so many features and the ability to apply it graphically and easily over large PostgreSQL installations.
Sample Metrics
| Availability | ||
| Historical/current database availability in a timeline | ||
| Performance | ||
| Long Running Queries | ||
| Idle Transactions | ||
| Last Vacuum/Analyze | ||
| Throughput | ||
| Blocks Read/Buffer Hits | ||
| WAL files | ||
| Row Inserts,Updates, Deletes per minute |
||
| Utilization | ||
| Connections, Locks Held | ||
| Database Size and Age | ||
| # of Databases & Schemas | ||
| # of Tables, Views, Functions | ||
| # of Sequences | ||
| # of Prepared Transactions | ||
| # of Tuples Returned, Inserted, Updated, Deleted | ||
| Sequential/Index scans | ||
| Heap/Index Sizes | ||
| # of Rows, Columns, Indexes, Rules and Triggers | ||
| Table and Index bloat | ||
| Previous Page | Next Page |
For Inquiries and product purchases call:
US +1 781-357-3390
or +1 877-377-4352
EMEA +31 70 891 8451
Japan +81 3 5488 6007
UK +44 (0) 1235 227276
India +91 20 30589500/01







