PHPMem v2.0.1
Version
1.6.45
Uptime
7 days 17 hours 14 minutes 59 seconds
Memory
Total
512MB
Used
8,23MB (1.61%)
Free
503,77MB
Keys
Current
6 304
Total (since start)
11 096
Evictions
0
Reclaimed
298
Expired Unfetched
0
Evicted Unfetched
0
Connections
Current
3 / 1 024 max
Total
71 394
Rejected
0
llm:0ef43037e07d4091da1a0808f7b5c6b770e5d65dfd3a60ac01c1913ba7da6e3d
Edit
```json
{
"classifications": [
{
"column": "rating_id",
"role": "identifier",
"confidence": 1.0,
"reason": "Primary key with unique values for each row (14.3M distinct in 14.3M rows)"
},
{
"column": "user_id",
"role": "identifier",
"confidence": 1.0,
"reason": "Foreign key referencing users table, used for joins"
},
{
"column": "beer_id",
"role": "identifier",
"confidence": 1.0,
"reason": "Foreign key referencing beers table, used for joins"
},
{
"column": "aroma",
"role": "measure",
"confidence": 1.0,
"reason": "Numeric rating scale (0-10) that would be aggregated with avg/sum"
},
{
"column": "flavor",
"role": "measure",
"confidence": 1.0,
"reason": "Numeric rating scale (0-10) that would be aggregated with avg/sum"
},
{
"column": "mouthfeel",
"role": "measure",
"confidence": 1.0,
"reason": "Numeric rating scale (0-5) that would be aggregated with avg/sum"
},
{
"column": "appearance",
"role": "measure",
"confidence": 1.0,
"reason": "Numeric rating scale (0-5) that would be aggregated with avg/sum"
},
{
"column": "overall",
"role": "measure",
"confidence": 1.0,
"reason": "Numeric rating scale (0-20) that would be aggregated with avg/sum"
},
{
"column": "total_score",
"role": "measure",
"confidence": 1.0,
"reason": "Numeric score (0.1-5.0) that would be aggregated with avg/sum"
},
{
"column": "comments",
"role": "attribute",
"confidence": 1.0,
"reason": "Free-form text content for display, not grouped or aggregated (12M distinct values)"
},
{
"column": "created_at",
"role": "dimension",
"confidence": 1.0,
"reason": "Timestamp used for filtering, grouping by time periods, and slicing data"
},
{
"column": "updated_at",
"role": "dimension",
"confidence": 1.0,
"reason": "Timestamp used for filtering, grouping by time periods, and slicing data"
},
{
"column": "description_score",
"role": "measure",
"confidence": 1.0,
"reason": "Numeric score that would be aggregated with avg/sum"
},
{
"column": "language",
"role": "dimension",
"confidence": 1.0,
"reason": "Categorical field (82 distinct values) used for grouping and filtering"
},
{
"column": "availability_id",
"role": "identifier",
"confidence": 1.0,
"reason": "Foreign key referencing availability table, used for joins"
}
]
}
```