PHPMem v2.0.1
Version
1.6.45
Uptime
7 days 3 hours 53 minutes 36 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
4 / 1 024 max
Total
57 996
Rejected
0
llm:2ffc1e744d053eb2d885beb0506cd90c360495a6c3834de50416cc671b022757
Edit
```json
{
"classifications": [
{"column": "beer_id", "label": "primary_key", "confidence": 1.0, "reason": "100% distinct (1191662/1191662), zero nulls, sequential integer ID"},
{"column": "name", "label": "none", "confidence": 0.95, "reason": "99.93% distinct but not a key - beer names with some duplicates"},
{"column": "name_plain", "label": "none", "confidence": 0.95, "reason": "99.95% distinct but not a key - plain text version of names"},
{"column": "brewer_id", "label": "foreign_key", "confidence": 1.0, "reason": "References brewers table, 48725 distinct values with repetition"},
{"column": "style_id", "label": "foreign_key", "confidence": 1.0, "reason": "References beer styles table, only 147 distinct values with high repetition"},
{"column": "alcohol_pct", "label": "none", "confidence": 1.0, "reason": "Measurement attribute, 1385 distinct values"},
{"column": "ibu", "label": "none", "confidence": 1.0, "reason": "Measurement attribute, 282 distinct values, 60.8% nulls"},
{"column": "is_seasonal", "label": "none", "confidence": 1.0, "reason": "Boolean flag attribute"},
{"column": "description", "label": "none", "confidence": 1.0, "reason": "Text content field, 789532 distinct values"},
{"column": "created_at", "label": "none", "confidence": 1.0, "reason": "Timestamp attribute, 99.9% distinct but temporal metadata"},
{"column": "created_by", "label": "foreign_key", "confidence": 0.95, "reason": "References users table, 13109 distinct values with repetition"},
{"column": "view_count", "label": "none", "confidence": 1.0, "reason": "Metric attribute, 882 distinct values"},
{"column": "avg_rating", "label": "none", "confidence": 1.0, "reason": "Calculated metric, 61677 distinct values"},
{"column": "rating_count", "label": "none", "confidence": 1.0, "reason": "Count metric, 1588 distinct values"},
{"column": "Unrateable", "label": "none", "confidence": 1.0, "reason": "Boolean flag (0/1), 2 distinct values"},
{"column": "is_one_off", "label": "none", "confidence": 1.0, "reason": "Boolean flag attribute"},
{"column": "is_alias", "label": "none", "confidence": 1.0, "reason": "Boolean flag attribute"},
{"column": "real_avg_rating", "label": "none", "confidence": 1.0, "reason": "Calculated metric, 37369 distinct values"},
{"column": "is_verified", "label": "none", "confidence": 1.0, "reason": "Boolean flag attribute"},
{"column": "is_retired", "label": "none", "confidence": 1.0, "reason": "Boolean flag attribute, only 1 distinct value"},
{"column": "rating_std_dev", "label": "none", "confidence": 1.0, "reason": "Statistical metric, 3367 distinct values, 93.9% nulls"},
{"column": "overall_percentile", "label": "none", "confidence": 1.0, "reason": "Calculated percentile metric, 1983 distinct values"},
{"column": "style_percentile", "label": "none", "confidence": 1.0, "reason": "Calculated percentile metric, 2042 distinct values"},
{"column": "tags", "label": "none", "confidence": 1.0, "reason": "HTML/text content field, 302132 distinct values"},
{"column": "last_9m_avg", "label": "none", "confidence": 1.0, "reason": "Time-windowed metric, 5774 distinct values"},
{"column": "last_9m_count", "label": "none", "confidence": 1.0, "reason": "Time-windowed count metric, 97 distinct values"},
{"column": "updated_by", "label": "foreign_key", "confidence": 0.95, "reason": "References users table, 1221 distinct values with repetition"},
{"column": "updated_at", "label": "none", "confidence": 1.0, "reason": "Timestamp attribute, 68.9% distinct but temporal metadata"},
{"column": "admin_note", "label": "none", "confidence": 1.0, "reason": "Text content field, 5518 distinct values"},
{"column": "has_pic", "label": "none", "confidence": 1.0, "reason": "Boolean flag attribute"},
{"column": "straight_avg_rating", "label": "none", "confidence": 1.0, "reason": "Calculated metric, 63545 distinct values"},
{"column": "straight_rating_count", "label": "none", "confidence": 1.0, "reason": "Count metric, 1817 distinct values"},
{"column": "year4_avg", "label": "none", "confidence": 1.0, "reason": "Time-windowed metric, 23591 distinct values"},
{"column": "year4_overall", "label": "none", "confidence": 1.0, "reason": "Time-windowed percentile metric, 10000 distinct values"},
{"column": "year4_style", "label": "none", "confidence": 1.0, "reason": "Time-windowed percentile metric, 48283 distinct values"},
{"column": "year4_count", "label": "none", "confidence": 1.0, "reason": "Time-windowed count metric, 475 distinct values"}
]
}
```