SELECT user_id,
query_id,
transaction_id,
session_id,
status,
trim(database_name) AS database_name,
start_time,
end_time,
result_cache_hit,
elapsed_time,
queue_time,
execution_time,
planning_time,
trim(query_text) as query_text,
query_label
FROM sys_query_history
WHERE query_type = 'SELECT'
AND query_label = 'Monday'
AND result_cache_hit = 'false'
ORDER BY execution_time DESC
SELECT user_id,
query_id,
transaction_id,
session_id,
status,
trim(database_name) AS database_name,
start_time,
end_time,
result_cache_hit,
elapsed_time,
queue_time,
execution_time,
planning_time,
trim(query_text) as query_text,
query_label
FROM sys_query_history
WHERE query_type = 'SELECT'
AND query_label = 'Monday'
AND result_cache_hit = 'false'
ORDER BY start_time DESC limit 10