// Query to retrieve completed queries:
SELECT
query, -- Query ID
user_name, -- User ID that executed the query
elapsed/1000000 AS execution_time_sec, -- Converts query execution time from microseconds to seconds
rows, -- Number of rows processed by the query
text -- Executed SQL query text
FROM svl_qlog
WHERE aborted = 0 -- Filters only successfully completed queries
ORDER BY execution_time_sec DESC;
// Query to retrieve the execution result of a specific query:
SELECT *
FROM svl_statementtext
WHERE query = <Query_ID>;
// If you want to reference the query ID from a previous task (example):
SELECT *
FROM svl_statementtext
WHERE query = {{a.query}}; -- Referencing with double curly braces
Execution Result
The execution result is returned in an array format, and the returned data values may vary depending on the query.
