information_schema.processlist.*| relation | column | mysql | mariadb | tidb | postgres | cockroachdb | mssql | |
|---|---|---|---|---|---|---|---|---|
processlist |
||||||||
command |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(16) NOT NULL:
| unsupported | unsupported | unsupported | ||
db |
VARCHAR NULL:
5.7-8
| NULL:
| VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
examined_rows |
unsupported | INT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
host |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NOT NULL:
| unsupported | unsupported | unsupported | ||
id |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
NULL:
| BIGINT(21) UNSIGNED NOT NULL:
| unsupported | unsupported | unsupported | ||
info |
LONGTEXT NULL:
5.7-8
| NULL:
| BINARY(512) NULL:
| unsupported | unsupported | unsupported | ||
info_binary |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
max_memory_used |
unsupported | BIGINT NOT NULL:
10.3-10.7
| unsupported | unsupported | unsupported | unsupported | ||
max_stage |
unsupported | TINYINT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
mem |
unsupported | unsupported | BIGINT(21) UNSIGNED NULL:
| unsupported | unsupported | unsupported | ||
memory_used |
unsupported | BIGINT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
progress |
unsupported | DECIMAL NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
query_id |
unsupported | BIGINT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
stage |
unsupported | TINYINT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
state |
VARCHAR NULL:
5.7-8
| NULL:
| VARCHAR(7) NULL:
| unsupported | unsupported | unsupported | ||
tid |
unsupported | BIGINT NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
time |
INT NOT NULL:
5.7-8
| INT NOT NULL:
NULL:
| INT(7) NOT NULL:
| unsupported | unsupported | unsupported | ||
time_ms |
unsupported | DECIMAL NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
txnstart |
unsupported | unsupported | VARCHAR(64) NOT NULL:
| unsupported | unsupported | unsupported | ||
user |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(16) NOT NULL:
| unsupported | unsupported | unsupported | ||