--- title: "SHOW - OceanBase 数据库 V4.3.4 | OceanBase 文档中心" description: "SHOW 描述 该语句用于展示数据库对象的信息。 语法 SHOW { | TABLE STATUS | VARIABLES [like 'variable_name'] | CHARSET | CHARACTER SET | COLLATION | PARAMETERS | TABLEGROUPS | CREATE …" --- 切换语言 - 中文站 - 简体中文 - International - English - 日本站 - 日本語 文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*P8CuR4UJ_FkAAAAAAAAAAAAADiGDAQ/original) OceanBase 数据库分布式版 - V 4.3.4 # SHOW 更新时间：2024-12-04 23:00:00 [编辑](https://github.com/oceanbase/oceanbase-doc/edit/V4.3.4/zh-CN/700.reference/500.sql-reference/100.sql-syntax/300.common-tenant-of-oracle-mode/900.sql-statement-of-oracle-mode/300.dcl-of-oracle-mode/3600.show-of-oracle-mode.md) ## 描述 该语句用于展示数据库对象的信息。 ## 语法 ```sql SHOW { | TABLE STATUS | VARIABLES [like 'variable_name'] | CHARSET | CHARACTER SET | COLLATION | PARAMETERS | TABLEGROUPS | CREATE TABLEGROUP tablegroup_name | CREATE TABLE table_name | CREATE VIEW view_name | ERRORS | GRANTS | PRIVILEGES | RECYCLEBIN | [FULL] PROCESSLIST | TRACE [FORMAT='JSON'] }; ``` ## 参数解释 | 参数 | 描述 | | --- | --- | | TABLE STATUS | 展示当前用户中所有表的详细信息。 | | VARIABLES [like 'variable_name'] | 显示变量信息。如果不指定 `like 'variable_name'`，则显示所有系统变量信息。`variable_name` 为变量名称。 | | CHARSET \| CHARACTER SET | 展示支持的字符集。 | | COLLATION | 展示支持的字符序。 | | PARAMETERS | 展示所有系统配置项。 | | TABLEGROUPS | 展示表组信息。 | | CREATE TABLEGROUP tablegroup_name | 查看创建表组的语句。`tablegroup_name` 为表组名称。 | | CREATE TABLE table_name | 查看创建表的语句。`table_name` 为表名。 | | CREATE VIEW view_name | 查看创建视图的语句。`view_name` 为视图名称。 | | ERRORS | 查看错误信息。 | | GRANTS | 查看当前用户的权限。 | | PRIVILEGES | 查看各项权限的描述。 | | RECYCLEBIN | 查看回收站。 | | [FULL] PROCESSLIST | 查看当前租户进程列表。具体如下： - `SHOW PROCESSLIST` 显示简要的进程列表，具体如下： - `ID`：进程的 ID，即当前会话的 Client Session ID，该 ID 是会话在客户端中的唯一标识。 - `USER`：连接的用户名。 - `HOST`：客户端 IP 和端口（通过 ODP 连接则为 ODP 的 IP 和端口）。 - `DB`：访问的 Database 名称。 - `COMMAND`：当前执行的命令类型，取值 `Query`、`Sleep` 等。 - `TIME`：当前命令执行时间，单位是秒。如果命令发生重试，会清零后重新计算。 - `STATE`：当前会话状态，取值 `SLEEP`、`ACTIVE` 等。 - `INFO`：展示当前正在执行的命令，长度限制为 100 个字符，超出部分截断。 - `SHOW FULL PROCESSLIST`：显示完整的进程列表，包括每个进程的详细信息，具体如下： - `ID`：进程的 ID，即当前会话的 Client Session ID，该 ID 是会话在客户端中的唯一标识。 - `USER`：连接的用户名。 - `TENANT`：连接的租户。 - `HOST`：客户端 IP 和端口（通过 ODP 连接则为 ODP 的 IP 和端口）。 - `DB`：访问的 Database 名称。 - `COMMAND`：当前执行的命令类型，取值 `Query`、`Sleep` 等。 - `TIME`：当前命令执行时间，单位是秒。如果命令发生重试，会清零后重新计算。 - `STATE`：当前会话状态，取值 `SLEEP`、`ACTIVE` 等。 - `INFO`：展示当前正在执行的命令。 - `IP`：服务器 IP 地址。 - `PORT`：SQL 端口号。 #### 说明 通过 `SHOW PROCESSLIST` 语句查询当前数据库中会话的数量和会话的 ID 的详细信息，请参见 [查看租户会话](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000001573776)。 | | TRACE [FORMAT='JSON'] | 展示 SQL 语句的执行情况。可以选择以 JSON 的格式输出。 | ## 示例 - 查看表 `tbl1` 的创建信息。 ```sql obclient> SHOW CREATE TABLE tbl1; +-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | TABLE | CREATE TABLE | +-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | TBL1 | CREATE TABLE "TBL1" ( "COL1" NUMBER(38), "COL2" NUMBER(38) ) COMPRESS FOR ARCHIVE REPLICA_NUM = 2 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0 | +-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set ``` - 查看回收站是否开启。 ```sql obclient> SHOW VARIABLES LIKE 'recyclebin'; +---------------+-------+ | VARIABLE_NAME | VALUE | +---------------+-------+ | recyclebin | ON | +---------------+-------+ 1 row in set ``` - 查看回收站中的内容。 ```sql obclient> SHOW RECYCLEBIN; +-----------------------------------+---------------+-------+------------------------------+ | OBJECT_NAME | ORIGINAL_NAME | TYPE | CREATETIME | +-----------------------------------+---------------+-------+------------------------------+ | RECYCLE_$_100004_1634807168766392 | TBL1 | TABLE | 21-OCT-21 05.06.08.767109 PM | | RECYCLE_$_100004_1634807177792816 | V1 | VIEW | 21-OCT-21 05.06.17.791967 PM | +-----------------------------------+---------------+-------+------------------------------+ 2 rows in set ``` - 使用 `SHOW TRACE` 查看某一 SQL 的执行信息，并以 JSON 的格式输出。 ```shell obclient> SET ob_enable_show_trace = 1; Query OK, 0 rows affected obclient> CREATE TABLE t1(c1 INT,c2 INT,c3 INT); Query OK, 0 rows affected obclient> INSERT INTO t1 VALUES(1,1,1); Query OK, 1 rows affected obclient> INSERT INTO t1 VALUES(2,2,2); Query OK, 1 rows affected obclient> SELECT/*+PARALLEL(2)*/ COUNT(*) FROM t1; +----------+ | COUNT(*) | +----------+ | 2 | +----------+ 1 row in set obclient> SHOW TRACE FORMAT='JSON'\G *************************** 1. row *************************** SHOW_TRACE_JSON: [{"logs":null,"tags":[[{"sess_id":3221487706},{"action_name":""},{"module_name":""},{"client_info":""},{"receive_ts":1686736593090296},{"log_trace_id":"YB42AC1E87DE-0005FDE6754F77C2-0-0"}]],"elapse":14829,"end_ts":"14-JUN-23 05.56.33.105170 PM","parent":"0005fe13-f775-f6ae-7a1d-f670fd124e4b","span_id":"0005fe13-f775-f725-9e96-fff3072b9b9a","start_ts":"14-JUN-23 05.56.33.090341 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"com_query_process","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":null,"elapse":14810,"end_ts":"14-JUN-23 05.56.33.105157 PM","parent":"0005fe13-f775-f725-9e96-fff3072b9b9a","span_id":"0005fe13-f775-f72b-0b95-3f2260bf1134","start_ts":"14-JUN-23 05.56.33.090347 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"mpquery_single_stmt","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":[[{"sql_text":"SHOW TRACE FORMAT='JSON'"}],[{"hit_plan":false}],[{"sql_id":"D2A6E68D54F4B888F9443FD4EABB490C"},{"database_id":201006},{"plan_hash":10171894614078661866}]],"elapse":3023,"end_ts":"14-JUN-23 05.56.33.093385 PM","parent":"0005fe13-f775-f72b-0b95-3f2260bf1134","span_id":"0005fe13-f775-f73a-97f4-8cf1d45a057d","start_ts":"14-JUN-23 05.56.33.090362 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"sql_compile","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":null,"elapse":6,"end_ts":"14-JUN-23 05.56.33.090372 PM","parent":"0005fe13-f775-f73a-97f4-8cf1d45a057d","span_id":"0005fe13-f775-f73e-81df-abe0749fb2dc","start_ts":"14-JUN-23 05.56.33.090366 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"pc_get_plan","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":null,"elapse":2953,"end_ts":"14-JUN-23 05.56.33.093369 PM","parent":"0005fe13-f775-f73a-97f4-8cf1d45a057d","span_id":"0005fe13-f775-f770-5f63-c6244ec2d2bd","start_ts":"14-JUN-23 05.56.33.090416 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"hard_parse","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":null,"elapse":27,"end_ts":"14-JUN-23 05.56.33.090444 PM","parent":"0005fe13-f775-f770-5f63-c6244ec2d2bd","span_id":"0005fe13-f775-f771-097e-2e4df274b94d","start_ts":"14-JUN-23 05.56.33.090417 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"parse","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":null,"elapse":1029,"end_ts":"14-JUN-23 05.56.33.091497 PM","parent":"0005fe13-f775-f770-5f63-c6244ec2d2bd","span_id":"0005fe13-f775-f7a4-b2f9-37444f7eaa75","start_ts":"14-JUN-23 05.56.33.090468 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"resolve","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":null,"elapse":983,"end_ts":"14-JUN-23 05.56.33.092530 PM","parent":"0005fe13-f775-f770-5f63-c6244ec2d2bd","span_id":"0005fe13-f775-fbdb-ad93-a44d9f9c1b6b","start_ts":"14-JUN-23 05.56.33.091547 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"rewrite","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":null,"elapse":498,"end_ts":"14-JUN-23 05.56.33.093046 PM","parent":"0005fe13-f775-f770-5f63-c6244ec2d2bd","span_id":"0005fe13-f775-ffc4-6b32-0a4236bfb075","start_ts":"14-JUN-23 05.56.33.092548 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"optimize","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":null,"elapse":180,"end_ts":"14-JUN-23 05.56.33.093242 PM","parent":"0005fe13-f775-f770-5f63-c6244ec2d2bd","span_id":"0005fe13-f776-01c6-3512-e03078f5b661","start_ts":"14-JUN-23 05.56.33.093062 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"code_generate","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":null,"elapse":11691,"end_ts":"14-JUN-23 05.56.33.105088 PM","parent":"0005fe13-f775-f72b-0b95-3f2260bf1134","span_id":"0005fe13-f776-0315-b92a-3917bb7eb16e","start_ts":"14-JUN-23 05.56.33.093397 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"sql_execute","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":null,"elapse":37,"end_ts":"14-JUN-23 05.56.33.093434 PM","parent":"0005fe13-f776-0315-b92a-3917bb7eb16e","span_id":"0005fe13-f776-0315-80dd-31db8fd59a4c","start_ts":"14-JUN-23 05.56.33.093397 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"open","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":null,"elapse":11559,"end_ts":"14-JUN-23 05.56.33.105002 PM","parent":"0005fe13-f776-0315-b92a-3917bb7eb16e","span_id":"0005fe13-f776-0343-0d09-20e62196e201","start_ts":"14-JUN-23 05.56.33.093443 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"response_result","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":null,"elapse":60,"end_ts":"14-JUN-23 05.56.33.093512 PM","parent":"0005fe13-f776-0343-0d09-20e62196e201","span_id":"0005fe13-f776-034c-ca80-255b49724557","start_ts":"14-JUN-23 05.56.33.093452 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"do_local_das_task","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":[[{"sql_text":"START TRANSACTION WITH CONSISTENT SNAPSHOT"}],[{"sql_id":"7F33FD22651F99E8AB2BAC5428623BCD"},{"database_id":201001}],[{"hit_plan":false}]],"elapse":111,"end_ts":"14-JUN-23 05.56.33.094108 PM","parent":"0005fe13-f776-0343-0d09-20e62196e201","span_id":"0005fe13-f776-056d-f2aa-701742ef8bfe","start_ts":"14-JUN-23 05.56.33.093997 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"sql_compile","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":null,"elapse":7,"end_ts":"14-JUN-23 05.56.33.094005 PM","parent":"0005fe13-f776-056d-f2aa-701742ef8bfe","span_id":"0005fe13-f776-056e-88fb-dba1544109d5","start_ts":"14-JUN-23 05.56.33.093998 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"pc_get_plan","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":null,"elapse":65,"end_ts":"14-JUN-23 05.56.33.094097 PM","parent":"0005fe13-f776-056d-f2aa-701742ef8bfe","span_id":"0005fe13-f776-0590-0540-58a0bf5fe462","start_ts":"14-JUN-23 05.56.33.094032 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"hard_parse","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":null,"elapse":23,"end_ts":"14-JUN-23 05.56.33.094055 PM","parent":"0005fe13-f776-0590-0540-58a0bf5fe462","span_id":"0005fe13-f776-0590-099e-6e48209edfab","start_ts":"14-JUN-23 05.56.33.094032 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"parse","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":null,"elapse":10,"end_ts":"14-JUN-23 05.56.33.094085 PM","parent":"0005fe13-f776-0590-0540-58a0bf5fe462","span_id":"0005fe13-f776-05bb-b66a-bf3b9895c04d","start_ts":"14-JUN-23 05.56.33.094075 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"resolve","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":null,"elapse":34,"end_ts":"14-JUN-23 05.56.33.094180 PM","parent":"0005fe13-f776-0343-0d09-20e62196e201","span_id":"0005fe13-f776-0602-16e1-b249aecff1d9","start_ts":"14-JUN-23 05.56.33.094146 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"open","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":null,"elapse":25,"end_ts":"14-JUN-23 05.56.33.094171 PM","parent":"0005fe13-f776-0602-16e1-b249aecff1d9","span_id":"0005fe13-f776-0602-a4d5-c18a35861355","start_ts":"14-JUN-23 05.56.33.094146 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"cmd_open","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":[[{"trans_id":0}]],"elapse":1,"end_ts":"14-JUN-23 05.56.33.094148 PM","parent":"0005fe13-f776-0602-a4d5-c18a35861355","span_id":"0005fe13-f776-0603-9b42-705d94f589e5","start_ts":"14-JUN-23 05.56.33.094147 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"end_transaction","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":null,"elapse":1,"end_ts":"14-JUN-23 05.56.33.094202 PM","parent":"0005fe13-f776-0343-0d09-20e62196e201","span_id":"0005fe13-f776-0639-1902-8ebfa41d0abd","start_ts":"14-JUN-23 05.56.33.094201 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"close","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":null,"elapse":1150,"end_ts":"14-JUN-23 05.56.33.095400 PM","parent":"0005fe13-f776-0343-0d09-20e62196e201","span_id":"0005fe13-f776-066a-7b64-42f9c85d5f57","start_ts":"14-JUN-23 05.56.33.094250 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"inner_execute_read","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":[[{"sql_text":"SELECT svr_ip, svr_port, tenant_id, trace_id, request_id, span_id, parent_span_id, span_name, ref_type, start_ts, end_ts, tags, logs FROM __all_virtual_trace_span_info WHERE tenant_id = 1004 AND trace_id = '0005fe13-f62f-e8cd-fad7-64c5c4fa3de4'"}],[{"sql_id":"9B307250A34F95FE531FDC05F9F87300"},{"database_id":201001},{"plan_hash":13345609059733987708},{"hit_plan":true}]],"elapse":98,"end_ts":"14-JUN-23 05.56.33.094360 PM","parent":"0005fe13-f776-066a-7b64-42f9c85d5f57","span_id":"0005fe13-f776-0676-d9f4-b4878c00d329","start_ts":"14-JUN-23 05.56.33.094262 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"sql_compile","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":null,"elapse":76,"end_ts":"14-JUN-23 05.56.33.094339 PM","parent":"0005fe13-f776-0676-d9f4-b4878c00d329","span_id":"0005fe13-f776-0677-e2f1-d2ec6292745b","start_ts":"14-JUN-23 05.56.33.094263 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"pc_get_plan","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":null,"elapse":5,"end_ts":"14-JUN-23 05.56.33.094375 PM","parent":"0005fe13-f776-066a-7b64-42f9c85d5f57","span_id":"0005fe13-f776-06e2-3f34-7d006345e36c","start_ts":"14-JUN-23 05.56.33.094370 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"open","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":null,"elapse":41,"end_ts":"14-JUN-23 05.56.33.094439 PM","parent":"0005fe13-f776-066a-7b64-42f9c85d5f57","span_id":"0005fe13-f776-06fe-51d8-da0d02773219","start_ts":"14-JUN-23 05.56.33.094398 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"do_local_das_task","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":null,"elapse":28,"end_ts":"14-JUN-23 05.56.33.096273 PM","parent":"0005fe13-f776-0343-0d09-20e62196e201","span_id":"0005fe13-f776-0e35-874a-f30554d6aaa5","start_ts":"14-JUN-23 05.56.33.096245 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"close","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":null,"elapse":12,"end_ts":"14-JUN-23 05.56.33.096259 PM","parent":"0005fe13-f776-0e35-874a-f30554d6aaa5","span_id":"0005fe13-f776-0e37-77fe-804fdfe8d3e5","start_ts":"14-JUN-23 05.56.33.096247 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"close_das_task","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":null,"elapse":129,"end_ts":"14-JUN-23 05.56.33.096417 PM","parent":"0005fe13-f776-0343-0d09-20e62196e201","span_id":"0005fe13-f776-0e60-c6c4-1bc243b72c60","start_ts":"14-JUN-23 05.56.33.096288 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"inner_commit","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":[[{"sql_id":"1D0BA376E273B9D622641124D8C59264"},{"database_id":201001}],[{"sql_text":"COMMIT"}]],"elapse":47,"end_ts":"14-JUN-23 05.56.33.096343 PM","parent":"0005fe13-f776-0e60-c6c4-1bc243b72c60","span_id":"0005fe13-f776-0e68-7082-78d6d27ff6b3","start_ts":"14-JUN-23 05.56.33.096296 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"sql_compile","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":null,"elapse":40,"end_ts":"14-JUN-23 05.56.33.096337 PM","parent":"0005fe13-f776-0e68-7082-78d6d27ff6b3","span_id":"0005fe13-f776-0e69-86ed-974f57a2f1bf","start_ts":"14-JUN-23 05.56.33.096297 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"hard_parse","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":null,"elapse":8,"end_ts":"14-JUN-23 05.56.33.096306 PM","parent":"0005fe13-f776-0e69-86ed-974f57a2f1bf","span_id":"0005fe13-f776-0e6a-cf72-65f53acbe223","start_ts":"14-JUN-23 05.56.33.096298 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"parse","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":null,"elapse":5,"end_ts":"14-JUN-23 05.56.33.096326 PM","parent":"0005fe13-f776-0e69-86ed-974f57a2f1bf","span_id":"0005fe13-f776-0e81-49fb-8ed91cbaf8d8","start_ts":"14-JUN-23 05.56.33.096321 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"resolve","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":null,"elapse":32,"end_ts":"14-JUN-23 05.56.33.096385 PM","parent":"0005fe13-f776-0e60-c6c4-1bc243b72c60","span_id":"0005fe13-f776-0ea1-af05-045e858dee98","start_ts":"14-JUN-23 05.56.33.096353 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"open","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":null,"elapse":27,"end_ts":"14-JUN-23 05.56.33.096380 PM","parent":"0005fe13-f776-0ea1-af05-045e858dee98","span_id":"0005fe13-f776-0ea1-6e52-5c0a2cda5830","start_ts":"14-JUN-23 05.56.33.096353 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"cmd_open","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":[[{"trans_id":643503}]],"elapse":16,"end_ts":"14-JUN-23 05.56.33.096370 PM","parent":"0005fe13-f776-0ea1-6e52-5c0a2cda5830","span_id":"0005fe13-f776-0ea2-e9aa-723fc5771a26","start_ts":"14-JUN-23 05.56.33.096354 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"end_transaction","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":null,"elapse":0,"end_ts":"14-JUN-23 05.56.33.096398 PM","parent":"0005fe13-f776-0e60-c6c4-1bc243b72c60","span_id":"0005fe13-f776-0ece-38ab-2587028fd24c","start_ts":"14-JUN-23 05.56.33.096398 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"close","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":null,"elapse":58,"end_ts":"14-JUN-23 05.56.33.105077 PM","parent":"0005fe13-f776-0315-b92a-3917bb7eb16e","span_id":"0005fe13-f776-307b-7ddf-d182c73d91c2","start_ts":"14-JUN-23 05.56.33.105019 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"close","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882},{"logs":null,"tags":null,"elapse":15,"end_ts":"14-JUN-23 05.56.33.105036 PM","parent":"0005fe13-f776-307b-7ddf-d182c73d91c2","span_id":"0005fe13-f776-307d-9ca8-e6153b7afdbe","start_ts":"14-JUN-23 05.56.33.105021 PM","trace_id":"0005fe13-f62f-e8cd-fad7-64c5c4fa3de4","span_name":"close_das_task","tenant_id":1004,"rec_svr_ip":"172.xx.xxx.xxx","rec_svr_port":2882}] 1 row in set ``` 上一篇 下一篇 ![有帮助](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) 咨询热线