
* | SELECT SUM(rpm) AS "总请求数", COUNT(*) AS "IP分钟样本数", approx_distinct(ip) AS "独立IP数", round(approx_percentile(CAST(rpm AS double), 0.50)) AS "P50单IP每分钟", round(approx_percentile(CAST(rpm AS double), 0.95)) AS "P95单IP每分钟", round(approx_percentile(CAST(rpm AS double), 0.99)) AS "P99单IP每分钟", round(approx_percentile(CAST(rpm AS double), 0.999)) AS "P999单IP每分钟", MAX(rpm) AS "单IP分钟峰值", round(approx_percentile(CAST(rpm AS double), 0.999) * 3) AS "建议60秒阈值" FROM ( SELECT COALESCE(NULLIF(real_client_ip, ''), src_ip) AS ip,