'show queries' cannot list the executing queries

[localvar]

Describe the bug（Bug 描述）

According to this document, I tried to list the executing queries using 'ts-cli' but failed.

To Reproduce（Bug 复现步骤）

1. import data from https://docs.opengemini.org/zh/guide/reference/sample_data.html
2. from the 1st 'ts-cli' shell, execute: select mean(water_level) from h2o_feet group by time(30s)
3. while the above query is executing, from the 2nd 'ts-clishell, execute:show queries`, the output is:

> SHOW QUERIES
+-----+-------+----------+----------+--------+------+
| qid | query | database | duration | status | host |
+-----+-------+----------+----------+--------+------+
+-----+-------+----------+----------+--------+------+
6 columns, 0 rows in set

Expected behavior（期望结果）

No response

Screenshots（屏幕截图）

No response

Logs（完整的错误日志）

No response

Additional context（其他的一些补充内容）

No response

[xiangyu5632]

the show queries command aims to query the slow queries.
if a query is executed and returns soon, show queries will no more data return.

[localvar]

I'm not sure if my query is slow or not, but I'm using a 30s interval (I even tried 10s interval just now), and the query do takes some time to finish.
while the query is executing, I kept executing show queries, but always saw an empty result.