PHPMem v2.0.1
Version
1.6.45
Uptime
7 days 12 hours 40 minutes 3 seconds
Memory
Total
512MB
Used
13,33MB (2.6%)
Free
498,67MB
Keys
Current
10 164
Total (since start)
11 094
Evictions
0
Reclaimed
157
Expired Unfetched
0
Evicted Unfetched
0
Connections
Current
4 / 1 024 max
Total
68 043
Rejected
0
llm:1db0cbc100e91fef41c77e40ffde9c7ae3eecfaecbb40991f92cb42ef989f995
Edit
```json
{
"classifications": [
{
"column": "user_id",
"label": "primary_key",
"confidence": 1.0,
"reason": "100% distinct (236969/236969), zero nulls, sequential integers 0-236968"
},
{
"column": "beer_first_rating",
"label": "none",
"confidence": 1.0,
"reason": "Timestamp of first beer rating, 8.9% nulls, not a key"
},
{
"column": "beer_last_rating",
"label": "none",
"confidence": 1.0,
"reason": "Timestamp of last beer rating, 8.9% nulls, not a key"
},
{
"column": "beer_rating_count",
"label": "none",
"confidence": 1.0,
"reason": "Aggregate count metric, only 2876 distinct values, not a key"
},
{
"column": "avg_beer_rating",
"label": "none",
"confidence": 1.0,
"reason": "Aggregate average metric, 8.9% nulls, not a key"
},
{
"column": "max_beer_rating",
"label": "none",
"confidence": 1.0,
"reason": "Aggregate max metric, only 51 distinct values, not a key"
},
{
"column": "min_beer_rating",
"label": "none",
"confidence": 1.0,
"reason": "Aggregate min metric, only 53 distinct values, not a key"
},
{
"column": "place_first_rating",
"label": "none",
"confidence": 1.0,
"reason": "Timestamp of first place rating, 88.1% nulls, not a key"
},
{
"column": "place_last_rating",
"label": "none",
"confidence": 1.0,
"reason": "Timestamp of last place rating, 88.1% nulls, not a key"
},
{
"column": "place_rating_count",
"label": "none",
"confidence": 1.0,
"reason": "Aggregate count metric, only 466 distinct values, not a key"
},
{
"column": "avg_place_rating",
"label": "none",
"confidence": 1.0,
"reason": "Aggregate average metric, 88.1% nulls, not a key"
},
{
"column": "max_place_rating",
"label": "none",
"confidence": 1.0,
"reason": "Aggregate max metric, only 59 distinct values, not a key"
},
{
"column": "min_place_rating",
"label": "none",
"confidence": 1.0,
"reason": "Aggregate min metric, only 65 distinct values, not a key"
},
{
"column": "favorite_count",
"label": "none",
"confidence": 1.0,
"reason": "Aggregate count metric, only 258 distinct values, not a key"
},
{
"column": "created_at",
"label": "none",
"confidence": 1.0,
"reason": "Timestamp field, 99.99% distinct but not a key column"
},
{
"column": "updated_at",
"label": "none",
"confidence": 1.0,
"reason": "Timestamp field, 99.99% distinct but not a key column"
},
{
"column": "total_activity_count",
"label": "none",
"confidence": 1.0,
"reason": "Aggregate count metric, only 2909 distinct values, not a key"
},
{
"column": "user_type",
"label": "none",
"confidence": 1.0,
"reason": "Categorical field with 4 values, not a key"
}
]
}
```