This topic describes monitoring metrics related to SQL execution plan types of an OceanBase Database tenant. These metrics are used to monitor the number of SQL execution plans executed per second in the current statistical period by type. You can specify a statistical period to query statistics about the SQL execution plan types in a single zone or on a single OBServer of an OceanBase Database tenant.
local
Definition
The number of local execution plans processed per second within the statistical period.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| local | sql_local_count | count |
Calculation expression
sum(rate(ob_sysstat{stat_id="40010",@LABELS}[@INTERVAL])) by (@GBLABELS)
remote
Definition
The number of remote execution plans processed per second within the statistical period.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| remote | sql_remote_count | count |
Calculation expression
sum(rate(ob_sysstat{stat_id="40011",@LABELS}[@INTERVAL])) by (@GBLABELS)
distributed
Definition
The number of distributed execution plans processed per second within the statistical period.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| distributed | sql_distributed_count | count |
Calculation expression
sum(rate(ob_sysstat{stat_id="40012",@LABELS}[@INTERVAL])) by (@GBLABELS)