Or maybe for reasons unknown, you want to see the average client request size in bytes for today, grouped by the Cloudflare edge colo ID.

SELECTavg(clientrequestbytes),edgecoloidFROM"cloudflare_logs"."cloudflare_logs"-- Assuming you are using the default date format with LogpushWHEREdate_trunc('day',from_iso8601_timestamp(edgestarttimestamp))=current_dateGROUPBYedgecoloidORDERBYavg(clientrequestbytes)ASC;

As you can imagine, the ways that you can slice and dice your Cloudflare HTTP logs is nearly limitless. Enjoy diving deep on your Cloudflare logs!