getRunningQueries

Syntax

getRunningQueries()

Arguments

None

Details

Return descriptive information about the SQL queries that are being executed on the local node. It returns a table with the following columns:

Name Meaning
userID the user ID
sessionID the session ID
jobID the job ID
rootID the root job ID
level the level of jobs. The root job starts from level 0, the tasks broken down from the root job are marked as level 1, and subtasks level 2, and so on.
startTime the start time of a query (of NANOTIMESTAMP type)
endTime the end time of a query (of NANOTIMESTAMP type)
jobDesc the job description
errorMsg error messages
remoteIP the IP address of the client that initiates a query

To use this function, we must set perfMonitoring=1 in the configuration file to enable performance monitoring.

Examples

getRunningQueries();
userID sessionID jobID rootID level startTime endTime jobDesc errorMsg remoteIP
admin 738481026 88e738a8-a749-4dcb-9cfe-740df2d9ce7d 88e738a8-a749-4dcb-9cfe-740df2d9ce7d 0 2019.02.07T19:02:26.809905612 select count(*) as count from pt 192.168.1.106