master.stats table
The master.stats table stores timing information about the alerts.status, alerts.details, and alerts.journal tables. This timing information is gathered if the stats_triggers trigger group is enabled. The stats_triggers trigger group is disabled by default in the automation.sql file.
The following table describes the columns in the master.stats table.
| Column name | Data type | Description |
|---|---|---|
| StatTime | time | The time that the statistics are collected. |
| NumClients | integer | The total number of clients (for example, desktops) connected to the ObjectServer. |
| NumRealtime | integer | The number of real-time clients connected to the ObjectServer. Desktops and gateways use IDUC and are real-time connections. |
| NumProbes | integer | The number of probes connected to the ObjectServer. |
| NumGateways | integer | The number of gateways connected to the ObjectServer. |
| NumMonitors | integer | The number of monitors connected to the ObjectServer. |
| NumProxys | integer | The number of proxy servers connected to the ObjectServer. |
| EventCount | integer | The current number of entries in the alerts.status table. |
| JournalCount | integer | The current number of entries in the alerts.journal table. |
| DetailCount | integer | The current number of entries in the alerts.details table. |
| StatusInserts | integer | The total number of inserts into the alerts.status table. |
| StatusNewInserts | integer | The number of new inserts into the alerts.status table. |
| StatusDedups | integer | The number of reinserts into the alerts.status table. |
| JournalInserts | integer | The number of inserts into the alerts.journal table. |
| DetailsInserts | integer | The number of inserts into the alerts.details table. |
| StatusUpdates | integer | The number of updates to the alerts.status table. |