This topic describes performance metrics related to the response time of SQL statements within an OceanBase Database tenant. The response time is the time consumed by the OBServer in processing a single SQL statement. To be specific, the response time refers to the period from the time when the OBServer receives an SQL statement to the time when the SQL statement is executed. You can specify a statistical period to query statistics about the response time of SQL statements within a tenant in a single zone or on a single OB server.
all
Definition
The average time consumed by the OBServer in processing each SQL statement.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| all | sql_all_rt | Milliseconds |
Calculation expression
(sum(rate(ob_sysstat{stat_id="40001",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="40003",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="40005",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="40007",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="40009",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="40019",@LABELS}[@INTERVAL])) by (@GBLABELS)) / (sum(rate(ob_sysstat{stat_id="40000",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="40002",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="40004",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="40006",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="40008",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id="40018",@LABELS}[@INTERVAL])) by (@GBLABELS))
select
Definition
The average time consumed by the OBServer in processing each SELECT statement.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| select | sql_select_rt | Milliseconds |
Calculation expression
sum(rate(ob_sysstat{stat_id="40001",@LABELS}[@INTERVAL])) by (@GBLABELS) / sum(rate(ob_sysstat{stat_id="40000",@LABELS}[@INTERVAL])) by (@GBLABELS)
insert
Definition
The average time consumed by the OBServer in processing each INSERT statement.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| insert | sql_insert_rt | Milliseconds |
Calculation expression
sum(rate(ob_sysstat{stat_id="40003",@LABELS}[@INTERVAL])) by (@GBLABELS) / sum(rate(ob_sysstat{stat_id="40002",@LABELS}[@INTERVAL])) by (@GBLABELS)
update
Definition
The average time consumed by the OBServer in processing each UPDATE statement.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| update | sql_update_rt | Milliseconds |
Calculation expression
sum(rate(ob_sysstat{stat_id="40007",@LABELS}[@INTERVAL])) by (@GBLABELS) / sum(rate(ob_sysstat{stat_id="40006",@LABELS}[@INTERVAL])) by (@GBLABELS)
replace
Definition
The average time consumed by the OBServer in processing each REPLACE statement.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| replace | sql_replace_rt | Milliseconds |
Calculation expression
sum(rate(ob_sysstat{stat_id="40005",@LABELS}[@INTERVAL])) by (@GBLABELS) / sum(rate(ob_sysstat{stat_id="40004",@LABELS}[@INTERVAL])) by (@GBLABELS)
delete
Definition
The average time consumed by the OBServer in processing each DELETE statement.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| delete | sql_delete_rt | Milliseconds |
Calculation expression
sum(rate(ob_sysstat{stat_id="40009",@LABELS}[@INTERVAL])) by (@GBLABELS) / sum(rate(ob_sysstat{stat_id="40008",@LABELS}[@INTERVAL])) by (@GBLABELS)
other
Definition
The average time consumed by the OBServer in processing each of other statements such as data definition language (DDL), data control language (DCL), and data transaction language (DTL) statements.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| other | sql_other_rt | Milliseconds |
Calculation expression
sum(rate(ob_sysstat{stat_id="40019",@LABELS}[@INTERVAL])) by (@GBLABELS) / sum(rate(ob_sysstat{stat_id="40000",@LABELS}[@INTERVAL])) by (@GBLABELS)