Returning Structured Data - PostgreSQL Server Programming - page 94

appname
FROM running_queries
ORDER BY 1 DESC
LIMIT rows;
END;
$$
LANGUAGE plpgsql
SECURITY DEFINER;