You can translate the question and the replies:

Running Queries

Do we have any metadata procedure to check running queries in Denodo ?
user
30-09-2022 03:18:40 -0400
code

1 Answer

Hi In order to retrieve the queries that are currently running, I would make use of the **GET_SESSIONS()** predefined Stored Procedure in the Denodo Platform. It will return all the information about the open sessions including the currently running queries. To view only the active queries I would use the following query.. select * from GET_SESSIONS() where query_running is not null; Here, **‘query_running’ **is the column which indicates the query which is currently running in the Virtual DataPort Server, once the query completes the value of this column will become NULL. Hence the application of filter **‘query_running is not null’.** Additionally, you could filter the results based on columns such as ‘database_name’, ‘user_name’, ‘user_agent’, ‘access_interface’, etc. For more information you could take a look at the [GET_SESSIONS](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/stored_procedures/predefined_stored_procedures/get_sessions) section of Virtual DataPort VQL Guide. Hope this helps!
Denodo Team
30-09-2022 08:14:57 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here