information_schema.slow_query.*| relation | column | mysql | mariadb | tidb | postgres | cockroachdb | mssql | |
|---|---|---|---|---|---|---|---|---|
slow_query |
||||||||
backoff_time |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
backoff_types |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
commit_backoff_time |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
commit_time |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
compile_time |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
conn_id |
unsupported | unsupported | BIGINT(20) UNSIGNED NULL:
| unsupported | unsupported | unsupported | ||
cop_proc_addr |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
cop_proc_avg |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
cop_proc_max |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
cop_proc_p90 |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
cop_time |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
cop_wait_addr |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
cop_wait_avg |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
cop_wait_max |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
cop_wait_p90 |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
db |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
digest |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
disk_max |
unsupported | unsupported | BIGINT(20) NULL:
| unsupported | unsupported | unsupported | ||
get_commit_ts_time |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
host |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
index_names |
unsupported | unsupported | VARCHAR(100) NULL:
| unsupported | unsupported | unsupported | ||
is_internal |
unsupported | unsupported | TINYINT(1) NULL:
| unsupported | unsupported | unsupported | ||
local_latch_wait_time |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
lockkeys_time |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
mem_max |
unsupported | unsupported | BIGINT(20) NULL:
| unsupported | unsupported | unsupported | ||
optimize_time |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
parse_time |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
plan |
unsupported | unsupported | LONGBLOB NULL:
| unsupported | unsupported | unsupported | ||
plan_digest |
unsupported | unsupported | VARCHAR(128) NULL:
| unsupported | unsupported | unsupported | ||
plan_from_cache |
unsupported | unsupported | TINYINT(1) NULL:
| unsupported | unsupported | unsupported | ||
preproc_subqueries |
unsupported | unsupported | BIGINT(20) UNSIGNED NULL:
| unsupported | unsupported | unsupported | ||
preproc_subqueries_time |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
prev_stmt |
unsupported | unsupported | LONGBLOB NULL:
| unsupported | unsupported | unsupported | ||
prewrite_region |
unsupported | unsupported | BIGINT(22) NULL:
| unsupported | unsupported | unsupported | ||
prewrite_time |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
process_keys |
unsupported | unsupported | BIGINT(20) UNSIGNED NULL:
| unsupported | unsupported | unsupported | ||
process_time |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
query |
unsupported | unsupported | LONGBLOB NULL:
| unsupported | unsupported | unsupported | ||
query_time |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
request_count |
unsupported | unsupported | BIGINT(20) UNSIGNED NULL:
| unsupported | unsupported | unsupported | ||
resolve_lock_time |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
rewrite_time |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
stats |
unsupported | unsupported | VARCHAR(512) NULL:
| unsupported | unsupported | unsupported | ||
succ |
unsupported | unsupported | TINYINT(1) NULL:
| unsupported | unsupported | unsupported | ||
time |
unsupported | unsupported | TIMESTAMP(6) NULL:
| unsupported | unsupported | unsupported | ||
total_keys |
unsupported | unsupported | BIGINT(20) UNSIGNED NULL:
| unsupported | unsupported | unsupported | ||
txn_retry |
unsupported | unsupported | BIGINT(22) NULL:
| unsupported | unsupported | unsupported | ||
txn_start_ts |
unsupported | unsupported | BIGINT(20) UNSIGNED NULL:
| unsupported | unsupported | unsupported | ||
user |
unsupported | unsupported | VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
wait_prewrite_binlog_time |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
wait_time |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
wait_ts |
unsupported | unsupported | DOUBLE NULL:
| unsupported | unsupported | unsupported | ||
write_keys |
unsupported | unsupported | BIGINT(22) NULL:
| unsupported | unsupported | unsupported | ||
write_size |
unsupported | unsupported | BIGINT(22) NULL:
| unsupported | unsupported | unsupported | ||