Internal statistics of the database are the second source of the system health information, next to the logs. The combination of two data sources (logs and statistics) provides access to the full picture of the cluster operations.
The standard implementation of the statistics collector built into PostgreSQL is unnatural and troublesome to use. Therefore, EuroDB has been equipped with an efficient database analysis module based on the statistics collector built into the PostgreSQL engine. The statistics analyzer provided by EuroDB generates readable reports ready for use by administrators, developers, and business departments.
Collected statistics allow for verification of the status of the cluster in the selected dates and date ranges. Average and peak values as well as activity trends are returned. An important advantage of the analyzer is the ability to compare data from selected periods. It is an invaluable help in the analysis of all types of irregularities.