oci-grafana-metrics icon indicating copy to clipboard operation
oci-grafana-metrics copied to clipboard

Feature request: Query database systems

Open Maros112358 opened this issue 9 months ago • 4 comments

Hello, we are using the OCI Grafana Plugin to visualize metrics for databases and pluggable databases in Grafana. We would like to template our dashboards with variables for databases and database systems so that we can then filter using those variables as dimensions. However, I do not see how to query database systems and databases when creating template variables in Templating Docs.

When creating dashboard query variable using OCI Grafana Plugin, I would expect the Query for database systems variable db_system to be something like:

database_systems($region,$tenancy)

For database variable database:

databases($region,$tenancy)

Then I could reference these variable in the in the raw query like:

CpuUtilization[1m]{resourceType="PDB", instanceName="$database", hostName="$database_system"}.mean()

As a workaround, I was thinking about using resourceId somehow to be more reusable, but I don't see how to query it using Templating Docs. Referencing database systems and databases directly seems more elegant.

Maros112358 avatar May 13 '24 09:05 Maros112358