ZenPacks.zenoss.PostgreSQL-4.2.5_1.0.8dev-1.lbn13.noarch

Once the PostgreSQL ZenPack is installed you will have the following new zProperties which should be set either for device classes or individual devices.

• zPostgreSQLPort - Port where PostgreSQL is listening. Default: 5432 zPostgreSQLUseSSL - Whether to use SSL or not. Default: False zPostgreSQLUsername - Must be a superuser. Default: postgres * zPostgreSQLPassword - Password for user. No default.

In addition to setting these properties you must add the zenoss.PostgreSQL modeler plugin to a device class or individual device. This modeler plugin will discover all databases and tables using the connectivity information provided through the above settings. Each database and table will automatically be monitored.

The following elements are discovered:

• Databases * Tables The following performance metrics are collected.
• Server Summaries of all databases and tables. Databases Latencies Connection SELECT 1 Connections Total Active Idle Durations Active Transactions (min/avg/max) Idle Transactions (min/avg/max) Queries (min/avg/max) Size Backends Efficiencies Transaction Rollback Percentage Tuple Fetch Percentage Transaction Rates Commits/sec Rollbacks/sec Tuple Rates Returned/sec Fetched/sec Inserted/sec Updated/sec Deleted/sec Locks Total Granted Waiting Exclusive AccessExclusive Summaries of all tables. Tables Scan Rates Sequential/sec Indexed/sec Tuple Rates Sequentially Read/sec Index Fetched/sec Inserted/sec Updated/sec Hot Updated/sec Deleted/sec Tuples Live Dead