---
title: "SQL 执行阶段 - 云平台 OCP V4.3.0 | OceanBase 文档中心"
description: SQL 执行阶段 本节为您介绍 OceanBase 租户的监控指标 SQL 执行阶段，该指标细分为 13 个指标，分别为 in_parse（正在执行 SQL PARSE 的活跃会话数）、in_pl_parse（正在执行 PL PARSE 的活跃会话数）、in_plan_cache（正在访问 plan cache 的活…
image: https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*OSPzQ6GUQF4AAAAAQHAAAAgAeiGDAQ/original
---
切换语言

- 中文站 - 简体中文
- International - English
- 日本站 - 日本語

文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*lJTmRZ61jSUAAAAAAAAAAAAADiGDAQ/original) 云平台 OCPV 4.3.0

# SQL 执行阶段

更新时间：2026-04-14 11:55:54

[编辑](https://github.com/oceanbase/ocp-doc/edit/V4.3.0/zh-CN/1900.reference-guide/300.monitoring-indicator-reference/400.oceanbase-database-tenant/1540.sql-event.md)  

本节为您介绍 OceanBase 租户的监控指标 SQL 执行阶段，该指标细分为 13 个指标，分别为 in_parse（正在执行 SQL PARSE 的活跃会话数）、in_pl_parse（正在执行 PL PARSE 的活跃会话数）、in_plan_cache（正在访问 plan cache 的活跃会话数）、in_sql_optimize（正在执行 SQL 优化的活跃会话数）、in_sql_execution（正在执行 SQL 语句的活跃会话数）、in_px_execution（正在进行 PX SQL 并行执行的活跃会话数）、in_sequence_load（正在进行自增列或 SEQUENCE 取值的活跃会话数）、in_committing（正处于事务提交阶段的活跃会话数）、in_storage_read（正在执行存储层读的活跃会话数）、in_storage_write（正在执行存储层写的活跃会话数）、in_remote_das_execution（正在远程 DAS 执行的活跃会话数）、in_plsql_compilation（正在 PL 编译的活跃会话数）、in_plsql_execution（处于 plsql execution 状态的执行事件数）。您可指定统计范围，查询租户在单个 Zone 或 OBServer 节点的 **SQL 执行阶段** 数据。

## in_parse

### 指标介绍

统计范围内，正在执行 SQL PARSE 的活跃会话数。

### 指标参数说明

| **指标项** | **指标名称** | **单位** | **支持版本** |
| --- | --- | --- | --- |
| in_parse | sql_event_in_parse | - | OceanBase V4.2.0.0 ~ V4.3.0.0（不包括 V4.3.0.0） |

### 计算表达式

sum(ob_sql_event_in_parse{@LABELS}) by (@GBLABELS)

### 采集 SQL

- OceanBase V4.2.0.0 及以上、V4.2.1.0 以下版本：

  ```sql
  SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD FROM (select * from oceanbase.__all_virtual_ash WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from dba_ob_tenants) t on ash.tenant_id = t.tenant_id group by tenant_id

  ```
 - OceanBase V4.2.1.0 及以上、V4.2.2.0 以下版本：

  ```sql
  SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD, COALESCE(CAST(SUM(CASE WHEN IN_COMMITTING = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_COMMITTING, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_READ = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_READ, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_WRITE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_WRITE, COALESCE(CAST(SUM(CASE WHEN IN_REMOTE_DAS_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_REMOTE_DAS_EXECUTION FROM (select * from oceanbase.__all_virtual_ash WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from dba_ob_tenants) t on ash.tenant_id = t.tenant_id group by tenant_id

  ```
 - OceanBase V4.2.2.0 及以上、V4.3.0.0 以下版本：

  ```sql
  SELECT /*+ MONITOR_AGENT */ t.tenant_id tenant_id, COALESCE(CAST(SUM(CASE WHEN IN_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PL_PARSE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PL_PARSE, COALESCE(CAST(SUM(CASE WHEN IN_PLAN_CACHE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLAN_CACHE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_OPTIMIZE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_OPTIMIZE, COALESCE(CAST(SUM(CASE WHEN IN_SQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PX_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PX_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_SEQUENCE_LOAD = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_SEQUENCE_LOAD, COALESCE(CAST(SUM(CASE WHEN IN_COMMITTING = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_COMMITTING, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_READ = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_READ, COALESCE(CAST(SUM(CASE WHEN IN_STORAGE_WRITE = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_STORAGE_WRITE, COALESCE(CAST(SUM(CASE WHEN IN_REMOTE_DAS_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_REMOTE_DAS_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_PLSQL_COMPILATION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLSQL_COMPILATION, COALESCE(CAST(SUM(CASE WHEN IN_PLSQL_EXECUTION = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_PLSQL_EXECUTION, COALESCE(CAST(SUM(CASE WHEN IN_FILTER_ROWS = 1 THEN 1 ELSE 0 END) AS SIGNED INTEGER), 0) AS IN_FILTER_ROWS FROM (select * from oceanbase.__all_virtual_ash WHERE sample_time between now() - INTERVAL 1 SECOND and now()) ash right join (select distinct tenant_id from dba_ob_tenants) t on ash.tenant_id = t.tenant_id group by tenant_id

  ```

## in_pl_parse

### 指标介绍

统计范围内，正在执行 PL PARSE 的活跃会话数。

### 指标参数说明

| **指标项** | **指标名称** | **单位** | **支持版本** |
| --- | --- | --- | --- |
| in_pl_parse | sql_event_in_pl_parse | - | OceanBase V4.2.0.0 ~ V4.3.0.0（不包括 V4.3.0.0） |

### 计算表达式

sum(ob_sql_event_in_pl_parse{@LABELS}) by (@GBLABELS)

  ```

## in_plan_cache

### 指标介绍

统计范围内，正在访问 plan cache 的活跃会话数。

### 指标参数说明

| **指标项** | **指标名称** | **单位** | **支持版本** |
| --- | --- | --- | --- |
| in_plan_cache | sql_event_in_plan_cache | - | OceanBase V4.2.0.0 ~ V4.3.0.0（不包括 V4.3.0.0） |

### 计算表达式

sum(ob_sql_event_in_plan_cache{@LABELS}) by (@GBLABELS)

  ```

## in_sql_optimize

### 指标介绍

统计范围内，正在执行 SQL 优化的活跃会话数。

### 指标参数说明

| **指标项** | **指标名称** | **单位** | **支持版本** |
| --- | --- | --- | --- |
| in_sql_optimize | sql_event_in_sql_optimize | - | OceanBase V4.2.0.0 ~ V4.3.0.0（不包括 V4.3.0.0） |

### 计算表达式

sum(ob_sql_event_in_sql_optimize{@LABELS}) by (@GBLABELS)

  ```

## in_sql_execution

### 指标介绍

统计范围内，正在执行 SQL 语句的活跃会话数。

### 指标参数说明

| **指标项** | **指标名称** | **单位** | **支持版本** |
| --- | --- | --- | --- |
| in_sql_execution | sql_event_in_sql_execution | - | OceanBase V4.2.0.0 ~ V4.3.0.0（不包括 V4.3.0.0） |

### 计算表达式

sum(ob_sql_event_in_sql_execution{@LABELS}) by (@GBLABELS)

  ```

## in_px_execution

### 指标介绍

统计范围内，正在进行 PX SQL 并行执行的活跃会话数。

### 指标参数说明

| **指标项** | **指标名称** | **单位** | **支持版本** |
| --- | --- | --- | --- |
| in_px_execution | sql_event_in_px_execution | - | OceanBase V4.2.0.0 ~ V4.3.0.0（不包括 V4.3.0.0） |

### 计算表达式

sum(ob_sql_event_in_px_execution{@LABELS}) by (@GBLABELS)

  ```

## in_sequence_load

### 指标介绍

统计范围内，正在进行自增列或 SEQUENCE 取值的活跃会话数。

### 指标参数说明

| **指标项** | **指标名称** | **单位** | **支持版本** |
| --- | --- | --- | --- |
| in_sequence_load | sql_event_in_sequence_load | - | OceanBase V4.2.0.0 ~ V4.3.0.0（不包括 V4.3.0.0） |

### 计算表达式

sum(ob_sql_event_in_sequence_load{@LABELS}) by (@GBLABELS)

  ```

## in_committing

### 指标介绍

统计范围内，正处于事务提交阶段的活跃会话数。

### 指标参数说明

| **指标项** | **指标名称** | **单位** | **支持版本** |
| --- | --- | --- | --- |
| in_committing | sql_event_in_committing | - | OceanBase V4.2.1.0 ~ V4.3.0.0（不包括 V4.3.0.0） |

### 计算表达式

sum(ob_sql_event_in_committing{@LABELS}) by (@GBLABELS)

### 采集 SQL

- OceanBase V4.2.1.0 及以上、V4.2.2.0 以下版本：

  ```

## in_storage_read

### 指标介绍

统计范围内，正在执行存储层读的活跃会话数。

### 指标参数说明

| **指标项** | **指标名称** | **单位** | **支持版本** |
| --- | --- | --- | --- |
| in_storage_read | sql_event_in_storage_read | - | OceanBase V4.2.1.0 ~ V4.3.0.0（不包括 V4.3.0.0） |

### 计算表达式

sum(ob_sql_event_in_storage_read{@LABELS}) by (@GBLABELS)

  ```

## in_storage_write

### 指标介绍

统计范围内，正在执行存储层写的活跃会话数。

### 指标参数说明

| **指标项** | **指标名称** | **单位** | **支持版本** |
| --- | --- | --- | --- |
| in_storage_write | sql_event_in_storage_write | - | OceanBase V4.2.1.0 ~ V4.3.0.0（不包括 V4.3.0.0） |

### 计算表达式

sum(ob_sql_event_in_storage_write{@LABELS}) by (@GBLABELS)

  ```

## in_remote_das_execution

### 指标介绍

统计范围内，正在远程 DAS 执行的活跃会话数。

### 指标参数说明

| **指标项** | **指标名称** | **单位** | **支持版本** |
| --- | --- | --- | --- |
| in_remote_das_execution | sql_event_in_remote_das_execution | - | OceanBase V4.2.1.0 ~ V4.3.0.0（不包括 V4.3.0.0） |

### 计算表达式

sum(ob_sql_event_in_remote_das_execution{@LABELS}) by (@GBLABELS)

  ```

## in_plsql_compilation

### 指标介绍

统计范围内，正在 PL 编译的活跃会话数。

### 指标参数说明

| **指标项** | **指标名称** | **单位** | **支持版本** |
| --- | --- | --- | --- |
| in_plsql_compilation | sql_event_in_plsql_compilation | - | OceanBase V4.2.2.0 ~ V4.3.0.0（不包括 V4.3.0.0） |

### 计算表达式

sum(ob_sql_event_in_plsql_compilation{@LABELS}) by (@GBLABELS)

### 采集 SQL

OceanBase V4.2.2.0 及以上、V4.3.0.0 以下版本：

```

## in_plsql_execution

### 指标介绍

统计范围内，正在 PL 执行的活跃会话数。

### 指标参数说明

| **指标项** | **指标名称** | **单位** | **支持版本** |
| --- | --- | --- | --- |
| in_plsql_execution | sql_event_in_plsql_execution | - | OceanBase V4.2.2.0 ~ V4.3.0.0（不包括 V4.3.0.0） |

### 计算表达式

sum(ob_sql_event_in_plsql_execution{@LABELS}) by (@GBLABELS)

```

## in_filter_rows

### 指标介绍

统计范围内，正在执行算子下压的活跃会话数。

### 指标参数说明

| **指标项** | **指标名称** | **单位** | **支持版本** |
| --- | --- | --- | --- |
| in_filter_rows | sql_event_in_filter_rows | - | OceanBase V4.2.2.0 ~ V4.3.0.0（不包括 V4.3.0.0） |

### 计算表达式

sum(ob_sql_event_in_filter_rows{@LABELS}) by (@GBLABELS)

```

 上一篇 下一篇 ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线