OCI Database with PostgreSQL
Using the OCI Database with PostgreSQL subject area, you can create reports about OCI Database with PostgreSQL resources. With these reports, you can track the different attributes and metrics for OCI Database with PostgreSQL resources across tenancies and compartments.
Business Questions
The subject area can answer the following business questions:
- Which PostgreSQL database systems are deployed in each compartment and tenancy?
- What are the current lifecycle states (for example, ACTIVE, INACTIVE) of all PostgreSQL databases?
- List all PostgreSQL databases running a specific major or minor PostgreSQL version.
- Which PostgreSQL databases are deployed in a specific region or availability domain?
- Show configuration details (CPU, memory) for all PostgreSQL database systems.
- List all PostgreSQL databases configured with standby nodes.
- Which databases were created or deleted within a specific time window?
- Which PostgreSQL databases are attached to a specific VCN or subnet?
- For each PostgreSQL database, show current used storage.
- For each PostgreSQL database, indicate the storage IOPS performance tier selected.
- For each PostgreSQL database, show the associated backups and their most recent backup timestamp.
- What are the network endpoints (IP addresses, hostnames) for all PostgreSQL database systems?
- List all PostgreSQL databases with cross-region replication enabled.
- List PostgreSQL databases by tag.
- Which PostgreSQL databases have automatic backups enabled?
Logical Model
The OCI Database with PostgreSQL subject area is based on a relationship-driven logical model.
This diagram shows how the PostgreSQL Backup fact table is related to the following dimension tables:
This diagram shows how the PostgreSQL DB Instance fact table is related to the following dimension tables:
This diagram shows how the PostgreSQL DB System fact table is related to the following dimension tables:
Metric Details
The fact folders in this subject area show the following metrics:
| Fact | Metric | Description |
|---|---|---|
| Postgresql Backup | Backup Size In Gbs | Size of the backup in GB. |
| Postgresql Db System | Instance Count | Number of instances in the database system. |
| Postgresql Db System | Instance Memory In Gbs | The amount of memory allocated to the instances of the database system, in gigabytes. |
| Postgresql Db System | Ocpu Count | The number of OCPU cores to be made available to the instances of the database system. |