Overview
Unless specified otherwise, UQL queries are executed as real-time processes. The results of processes are returned to the client once execution is complete and are not stored on the server.
Showing Processes
To retrieve currently running processes in the database:
top()
It returns the following information for each process:
Field |
Description |
---|---|
process_id |
ID of the process. |
process_uql |
UQL query of the process. |
duration |
The duration in seconds for which the process has been running. |
status |
Current state of the process, which can only be RUNNING . |
Stopping Processes
To stop all currently running processes in the database:
kill("*")
To stop a currently running process with id 2097156
in the database:
kill("2097156")