PHPMem v2.0.1
Version
1.6.45
Uptime
15 days 16 hours 12 minutes 45 seconds
Memory
Total
512MB
Used
9,38MB (1.83%)
Free
502,62MB
Keys
Current
11 436
Total (since start)
35 066
Evictions
0
Reclaimed
738
Expired Unfetched
0
Evicted Unfetched
0
Connections
Current
14 / 1 024 max
Total
176 270
Rejected
0
llm:63c797f6bed0d53ebdd89199fc4280eda2964e29592c4587867c811148e9b5eb
Edit
<invoke name="query_sql">
<parameter name="sql">WITH s AS (SELECT Species, quantile_cont(SepalLengthCm,0.25) q1a, quantile_cont(SepalLengthCm,0.75) q3a, quantile_cont(SepalWidthCm,0.25) q1b, quantile_cont(SepalWidthCm,0.75) q3b, quantile_cont(PetalLengthCm,0.25) q1c, quantile_cont(PetalLengthCm,0.75) q3c, quantile_cont(PetalWidthCm,0.25) q1d, quantile_cont(PetalWidthCm,0.75) q3d FROM raw.Iris GROUP BY Species)
SELECT i.Id, i.Species, i.SepalLengthCm, i.SepalWidthCm, i.PetalLengthCm, i.PetalWidthCm,
(i.SepalLengthCm < q1a-1.5*(q3a-q1a) OR i.SepalLengthCm > q3a+1.5*(q3a-q1a)) AS sl_out,
(i.SepalWidthCm < q1b-1.5*(q3b-q1b) OR i.SepalWidthCm > q3b+1.5*(q3b-q1b)) AS sw_out,
(i.PetalLengthCm < q1c-1.5*(q3c-q1c) OR i.PetalLengthCm > q3c+1.5*(q3c-q1c)) AS pl_out,
(i.PetalWidthCm < q1d-1.5*(q3d-q1d) OR i.PetalWidthCm > q3d+1.5*(q3d-q1d)) AS pw_out
FROM raw.Iris i JOIN s USING (Species)
WHERE (i.SepalLengthCm < q1a-1.5*(q3a-q1a) OR i.SepalLengthCm > q3a+1.5*(q3a-q1a))
OR (i.SepalWidthCm < q1b-1.5*(q3b-q1b) OR i.SepalWidthCm > q3b+1.5*(q3b-q1b))
OR (i.PetalLengthCm < q1c-1.5*(q3c-q1c) OR i.PetalLengthCm > q3c+1.5*(q3c-q1c))
OR (i.PetalWidthCm < q1d-1.5*(q3d-q1d) OR i.PetalWidthCm > q3d+1.5*(q3d-q1d))
ORDER BY i.Id</parameter>
<parameter name="purpose">Find within-species IQR outliers across the four measurements</parameter>
</invoke>