Log Analytics

SELECT
Http_Request.request_url,
SUM(Http_Request.response_size) AS response_size
FROM
`logs__Default_US._Default`
WHERE
timestamp > TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 1 HOUR)
AND resource.type="http_load_balancer"
GROUP BY
Http_Request.request_url
ORDER BY
response_size DESC
LIMIT
10

SELECT
Http_Request.request_url, COUNT(*) AS count
FROM
`logs__Default_US._Default`
WHERE
timestamp > TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 1 HOUR) AND
resource.type="http_load_balancer"
group by Http_Request.request_url
ORDER BY count DESC
LIMIT 10