PHPMem v2.0.1
Version
1.6.45
Uptime
7 days 9 hours 42 minutes 19 seconds
Memory
Total
512MB
Used
13,32MB (2.6%)
Free
498,68MB
Keys
Current
10 162
Total (since start)
11 092
Evictions
0
Reclaimed
157
Expired Unfetched
0
Evicted Unfetched
0
Connections
Current
2 / 1 024 max
Total
65 201
Rejected
0
llm:646bea2cdfd7974751bee66106a3f42b4f152d91573199b66cde69a654ce9b30
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."
}
]
}
```