29 lines
1.1 KiB
Plaintext
29 lines
1.1 KiB
Plaintext
DESC sys.statements_with_temp_tables;
|
|
Field Type Null Key Default Extra
|
|
query longtext YES NULL
|
|
db varchar(64) YES NULL
|
|
exec_count bigint(20) unsigned NO NULL
|
|
total_latency text YES NULL
|
|
memory_tmp_tables bigint(20) unsigned NO NULL
|
|
disk_tmp_tables bigint(20) unsigned NO NULL
|
|
avg_tmp_tables_per_query decimal(21,0) NO 0
|
|
tmp_tables_to_disk_pct decimal(24,0) NO 0
|
|
first_seen timestamp(6) NO 0000-00-00 00:00:00.000000
|
|
last_seen timestamp(6) NO 0000-00-00 00:00:00.000000
|
|
digest varchar(64) YES NULL
|
|
SELECT * FROM sys.statements_with_temp_tables;
|
|
DESC sys.x$statements_with_temp_tables;
|
|
Field Type Null Key Default Extra
|
|
query longtext YES NULL
|
|
db varchar(64) YES NULL
|
|
exec_count bigint(20) unsigned NO NULL
|
|
total_latency bigint(20) unsigned NO NULL
|
|
memory_tmp_tables bigint(20) unsigned NO NULL
|
|
disk_tmp_tables bigint(20) unsigned NO NULL
|
|
avg_tmp_tables_per_query decimal(21,0) NO 0
|
|
tmp_tables_to_disk_pct decimal(24,0) NO 0
|
|
first_seen timestamp(6) NO 0000-00-00 00:00:00.000000
|
|
last_seen timestamp(6) NO 0000-00-00 00:00:00.000000
|
|
digest varchar(64) YES NULL
|
|
SELECT * FROM sys.x$statements_with_temp_tables;
|