-- start_ignore
SELECT s.groupid, s.num_running, s.num_queueing, s.num_queued, s.num_executed
FROM pg_resgroup_get_status(NULL::oid) s(groupid, num_running, num_queueing, num_queued, num_executed, total_queue_duration, cpu_usage, memory_usage);
-- end_ignore
CREATE TEMP TABLE resgroup_function_test(LIKE gp_toolkit.gp_resgroup_status);

INSERT INTO resgroup_function_test(groupid, num_running, num_queueing, num_queued, num_executed)
SELECT s.groupid, s.num_running, s.num_queueing, s.num_queued, s.num_executed
FROM pg_resgroup_get_status(NULL::oid) s(groupid, num_running, num_queueing, num_queued, num_executed, total_queue_duration, cpu_usage, memory_usage) LIMIT 1;

SELECT count(num_executed)>0 FROM resgroup_function_test WHERE num_executed IS NOT NULL;
