active_queries

Name

SinceVersion dev

active_queries

description

Table-Value-Function, generate a temporary table named active_queries. This tvf is used to view the information of running queries in doris cluster.

This function is used in FROM clauses.

syntax

active_queries()

active_queries() table schema：

1. mysql [(none)]> desc function active_queries();
2. +------------------------+--------+------+-------+---------+-------+
3. | Field                  | Type   | Null | Key   | Default | Extra |
4. +------------------------+--------+------+-------+---------+-------+
5. | BeHost                 | TEXT   | No   | false | NULL    | NONE  |
6. | BePort                 | BIGINT | No   | false | NULL    | NONE  |
7. | QueryId                | TEXT   | No   | false | NULL    | NONE  |
8. | StartTime              | TEXT   | No   | false | NULL    | NONE  |
9. | QueryTimeMs            | BIGINT | No   | false | NULL    | NONE  |
10. | WorkloadGroupId        | BIGINT | No   | false | NULL    | NONE  |
11. | QueryCpuTimeMs         | BIGINT | No   | false | NULL    | NONE  |
12. | ScanRows               | BIGINT | No   | false | NULL    | NONE  |
13. | ScanBytes              | BIGINT | No   | false | NULL    | NONE  |
14. | BePeakMemoryBytes      | BIGINT | No   | false | NULL    | NONE  |
15. | CurrentUsedMemoryBytes | BIGINT | No   | false | NULL    | NONE  |
16. | Database               | TEXT   | No   | false | NULL    | NONE  |
17. | FrontendInstance       | TEXT   | No   | false | NULL    | NONE  |
18. | Sql                    | TEXT   | No   | false | NULL    | NONE  |
19. +------------------------+--------+------+-------+---------+-------+
20. 14 rows in set (0.00 sec)

example

1. mysql [(none)]>select * from active_queries();
2. +------------+--------+----------------------------------+---------------------+-------------+-----------------+----------------+----------+------------+-------------------+------------------------+----------+------------------+-------+
3. | BeHost     | BePort | QueryId                          | StartTime           | QueryTimeMs | WorkloadGroupId | QueryCpuTimeMs | ScanRows | ScanBytes  | BePeakMemoryBytes | CurrentUsedMemoryBytes | Database | FrontendInstance | Sql   |
4. +------------+--------+----------------------------------+---------------------+-------------+-----------------+----------------+----------+------------+-------------------+------------------------+----------+------------------+-------+
5. | 127.0.0.1 |   6090 | 71fd11b7b0e438c-bc98434b97b8cb98 | 2024-01-16 16:21:15 |        7260 |           10002 |           8392 | 16082249 | 4941889536 |         360470040 |              360420915 | hits     | localhost   | SELECT xxxx |
6. +------------+--------+----------------------------------+---------------------+-------------+-----------------+----------------+----------+------------+-------------------+------------------------+----------+------------------+-------+
7. 1 row in set (0.01 sec)

keywords

1. active_queries