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 details are as follows:
NoteYou can execute the |
| 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
tbl1table.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 setCheck whether the recycle bin is enabled.
obclient> SHOW VARIABLES LIKE 'recyclebin'; +---------------+-------+ | VARIABLE_NAME | VALUE | +---------------+-------+ | recyclebin | ON | +---------------+-------+ 1 row in setView 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 setUse
SHOW TRACEto 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