Database Observability
Purpose
The Database Observability module monitors PostgreSQL and brings database clusters and instances into Search Anywhere Framework operations. It links database telemetry with Inventory assets, the Service Monitor Toolkit health model, and Incident Manager cards.
Database Support
In Search Anywhere Framework 6.2, the module supports PostgreSQL. The collection architecture, data models, and analytics content are designed to support other database systems. Support for additional database sources is planned for future versions.
The module performs the following tasks:
- monitors instance availability, connection saturation, and collection completeness
- analyzes query cost, errors, locks, and long-running transactions
- monitors physical replication, slots, Patroni, and PgBouncer
- shows database, table, and index growth, XID consumption, and autovacuum activity
- collects PostgreSQL logs and
pgauditevents - creates incidents with runbooks, asset links, and SLA policies
Architecture
Package Contents
| Component | Contents |
|---|---|
| Content module | 8 dashboards, 28 jobs, 9 indexes, 2 ISM policies, and 12 tags |
| Installation utility | data templates, 6 lookups, 3 asset configurations, 8 Service Monitor Toolkit metrics, a health model, an incident type, 2 SLA policies, and service objects |
| PostgreSQL data collection configurations | 13 configurations for collecting metrics and state, plus a SAF Beat application for logs |
Documentation Sections
Data Sources
Database Observability sources, collection configurations, indexes, data model, and compatibility.
Database Observability: Module Installation
4 items
Database Observability: Features
5 items