Avaya Analytics™ 4.3 release supports monitoring the Crunchy database using the Grafana reporting system.
The following reports are supported:
CrunchyData Clusters Backup Details: This report looks into the pgBackrest repository and provides information on full and incremental backups, including size and time taken to create. It also includes information on WAL file archiving.
CrunchyData CRUD Operations Details: This report tracks database usage from the Create, Read, Update, and Delete statements. It helps to identify operations that are costly on the system.
CrunchyData Database Activity Details: This report details many items, including active connections, idle time, DB cache usage, locks, commits, and replication lag.
CrunchyData Database Query Statistics: This report monitors queries on the system and helps to isolate particular queries that take time or consume a lot of system memory.
CrunchyData Pods Resource Usage: This report provides kubernetes-level information narrowed down for Crunchy-specific pods. It tracks memory, CPU, and disk usage for Crunchy pods.
CrunchyData Postgresql Service Health: This report shows an overview of the system covering resource usage and system errors.
You can also view the PostgreSQL and Crunchy Container Dashboard in the Grafana reporting system.
Note:
You can use these reports to monitor all the Crunchy instances within the kubernetes cluster. By default, there is analyticsdb and authdbservice for reporting. You must select which instance you are interested in from the drop-down menu at the top of each report. You can also select the individual pod or database from a drop-down menu as per your requirement.
