SHOW|V4.3.0| docs|Distributed Database

SHOW

Last Updated：2024-04-19 08:42:50 Updated

Purpose

You can use this statement to query information about database objects.

Syntax

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']
};

Parameters

Parameter	Description
TABLE STATUS	Queries the details about all tables of the current user.
VARIABLES [like 'variable_name']	Queries the information about a variable. If `like 'variable_name'` is not specified, the information about all system variables is displayed. `variable_name` indicates the name of a variable.
CHARSET \| CHARACTER SET	Queries supported character sets.
COLLATION	Queries supported collations.
PARAMETERS	Queries all system parameters.
TABLEGROUPS	Queries table groups.
CREATE TABLEGROUP tablegroup_name	Queries the `CREATE TABLEGROUP` statement. `tablegroup_name` indicates the name of the table group.
CREATE TABLE table_name	Queries the `CREATE TABLE` statement. `table_name` indicates the name of the table.
CREATE VIEW view_name	Queries the `CREATE VIEW` statement. `view_name` indicates the name of the view.
ERRORS	Queries errors.
GRANTS	Queries the privileges of the current user.
PRIVILEGES	Queries the description of privileges.
RECYCLEBIN	Queries the recycle bin.
[FULL] PROCESSLIST	Queries the list of processes in the current tenant. The following options are supported: `SHOW PROCESSLIST` displays the brief list of processes with the following information: `ID`: the ID of the process, that is, the client session ID of the current session. This ID is the unique identifier of the session in the client. `USER`: the username used for database connection. `HOST`: the IP address and port number of the client. If an OceanBase Data Proxy (ODP) is used to connect to the database, the IP address and port number of the ODP are displayed here. `DB`: the name of the connected database. `COMMAND`: the type of the command being executed, such as `Query` and `Sleep`. `TIME`: the execution time of the current command, in seconds. If the command is retried, the time is reset and recalculated. `STATE`: the status of the current session, such as `SLEEP` and `ACTIVE`. `INFO`: the content of the command being executed. A maximum of 100 characters can be displayed and the exceeding part is truncated. `SHOW FULL PROCESSLIST` displays the complete list of processes with the following information: `ID`: the ID of the process, that is, the client session ID of the current session. This ID is the unique identifier of the session in the client. `USER`: the username used for database connection. `TENANT`: the connected tenant. `HOST`: the IP address and port number of the client. If an ODP is used to connect to the database, the IP address and port number of the ODP are displayed here. `DB`: the name of the connected database. `COMMAND`: the type of the command being executed, such as `Query` and `Sleep`. `TIME`: the execution time of the current command, in seconds. If the command is retried, the time is reset and recalculated. `STATE`: the status of the current session, such as `SLEEP` and `ACTIVE`. `INFO`: the content of the command being executed. `IP`: the IP address of the server. `PORT`: the SQL port number. Note You can execute the `SHOW PROCESSLIST` statement to query the quantity and IDs of sessions in the current database. For more information, see View tenant sessions.
TRACE [FORMAT='JSON']	Queries the execution status of SQL statements. You can choose to output the results in JSON format.

Examples

View the information about the creation of the tbl1 table.

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

Check whether the recycle bin is enabled.

obclient> SHOW VARIABLES LIKE 'recyclebin';
+---------------+-------+
| VARIABLE_NAME | VALUE |
+---------------+-------+
| recyclebin    | ON    |
+---------------+-------+
1 row in set

View the objects in the recycle bin.

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

Use SHOW TRACE to query the execution information of an SQL statement and output the results in the JSON format.

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

SHOW

Purpose

Syntax

Parameters

Note

Examples