PHPMem v2.0.1
Version
1.6.45
Uptime
7 days 19 hours 43 seconds
Memory
Total
512MB
Used
8,15MB (1.59%)
Free
503,85MB
Keys
Current
6 252
Total (since start)
11 098
Evictions
0
Reclaimed
299
Expired Unfetched
0
Evicted Unfetched
0
Connections
Current
3 / 1 024 max
Total
72 487
Rejected
0
llm:f15c40804c81e61a93cc0a875ba18791994f8ba52289bdb12de05ea57eddaff9
Edit
```json
{
"queries": [
{
"query": "SELECT \"Species\", COUNT(*) AS count FROM \"Iris\" GROUP BY \"Species\" ORDER BY count DESC",
"description": "Number of samples for each iris species in the dataset."
},
{
"query": "SELECT \"Species\", AVG(\"PetalLengthCm\") AS avg_petal_length FROM \"Iris\" GROUP BY \"Species\" ORDER BY avg_petal_length DESC",
"description": "Average petal length by species, longest first."
},
{
"query": "SELECT \"Species\", AVG(\"SepalLengthCm\") AS avg_sepal_length, AVG(\"SepalWidthCm\") AS avg_sepal_width FROM \"Iris\" GROUP BY \"Species\"",
"description": "Average sepal dimensions for each iris species."
},
{
"query": "SELECT * FROM \"Iris\" WHERE \"Species\" = 'Iris-setosa' ORDER BY \"PetalLengthCm\" DESC LIMIT 10",
"description": "Top 10 Iris-setosa samples with the longest petals."
},
{
"query": "SELECT \"Species\", MIN(\"PetalWidthCm\") AS min_width, MAX(\"PetalWidthCm\") AS max_width FROM \"Iris\" GROUP BY \"Species\"",
"description": "Minimum and maximum petal width for each species."
},
{
"query": "SELECT * FROM \"Iris\" WHERE \"PetalLengthCm\" > 5.0 AND \"Species\" = 'Iris-virginica' LIMIT 15",
"description": "Iris-virginica samples with petal length exceeding 5 cm."
},
{
"query": "SELECT \"Species\", AVG(\"PetalLengthCm\" * \"PetalWidthCm\") AS avg_petal_area FROM \"Iris\" GROUP BY \"Species\" ORDER BY avg_petal_area DESC",
"description": "Average petal area by species, calculated from length times width."
},
{
"query": "SELECT * FROM \"Iris\" WHERE \"SepalLengthCm\" IS NOT NULL ORDER BY \"SepalLengthCm\" DESC LIMIT 10",
"description": "Top 10 iris samples with the longest sepals."
},
{
"query": "SELECT \"Species\", COUNT(*) AS count FROM \"Iris\" WHERE \"PetalLengthCm\" > 4.0 GROUP BY \"Species\"",
"description": "Count of samples per species with petal length greater than 4 cm."
},
{
"query": "SELECT AVG(\"SepalLengthCm\") AS avg_sepal, AVG(\"PetalLengthCm\") AS avg_petal FROM \"Iris\" WHERE \"Species\" = 'Iris-versicolor'",
"description": "Average sepal and petal lengths for Iris-versicolor species."
}
]
}
```