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 |