PHPMem v2.0.1
Version
1.6.45
Uptime
7 days 5 hours 25 minutes 25 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
3 / 1 024 max
Total
60 848
Rejected
0
llm:05361f6d7162f278f0dabff5b1ca32781ea7bb98f4b19ac7b1b822dfc92336c0
Edit
```json
{
"classifications": [
{
"column": "Unnamed: 0",
"label": "primary_key",
"confidence": 0.95,
"reason": "Integer column with 127 distinct values in 127 rows, no nulls, typical auto-increment index"
},
{
"column": "f_boxer",
"label": "none",
"confidence": 0.9,
"reason": "Only 11 distinct values in 127 rows (8.7%), represents repeating boxer names, not a key"
},
{
"column": "s_boxer",
"label": "near_key",
"confidence": 0.85,
"reason": "106 distinct values in 127 rows (83.5%), high but not sufficient for primary key, no nulls"
},
{
"column": "f_boxer_result",
"label": "none",
"confidence": 1.0,
"reason": "Only 2 distinct values (won/lost), categorical outcome field"
},
{
"column": "f_boxer_stance",
"label": "none",
"confidence": 1.0,
"reason": "Only 3 distinct values, categorical attribute"
},
{
"column": "f_boxer_age",
"label": "none",
"confidence": 1.0,
"reason": "20 distinct values with 9.4% nulls, numeric attribute not a key"
},
{
"column": "f_boxer_height",
"label": "none",
"confidence": 1.0,
"reason": "Only 8 distinct values, physical measurement attribute"
},
{
"column": "f_boxer_reach",
"label": "none",
"confidence": 1.0,
"reason": "Only 7 distinct values with 10.2% nulls, physical measurement"
},
{
"column": "f_boxer_won",
"label": "none",
"confidence": 1.0,
"reason": "63 distinct values, numeric statistic not a key"
},
{
"column": "f_boxer_lost",
"label": "none",
"confidence": 1.0,
"reason": "Only 6 distinct values, numeric statistic"
},
{
"column": "f_boxer_drawn",
"label": "none",
"confidence": 1.0,
"reason": "Only 2 distinct values, numeric statistic"
},
{
"column": "f_boxer_KOs",
"label": "none",
"confidence": 1.0,
"reason": "54 distinct values with 9.4% nulls, numeric statistic"
},
{
"column": "f_boxer_ranking",
"label": "none",
"confidence": 1.0,
"reason": "Only 5 distinct values with 55.9% nulls, ranking attribute"
},
{
"column": "s_boxer_ranking",
"label": "none",
"confidence": 1.0,
"reason": "23 distinct values with 72.4% nulls, ranking attribute"
},
{
"column": "s_boxer_age",
"label": "none",
"confidence": 1.0,
"reason": "22 distinct values with 9.4% nulls, numeric attribute"
},
{
"column": "s_boxer_stance",
"label": "none",
"confidence": 1.0,
"reason": "Only 9 distinct values, categorical attribute"
},
{
"column": "s_boxer_reach",
"label": "none",
"confidence": 1.0,
"reason": "17 distinct values with 35.4% nulls, physical measurement"
},
{
"column": "s_boxer_height",
"label": "none",
"confidence": 1.0,
"reason": "24 distinct values, physical measurement attribute"
},
{
"column": "s_boxer_won",
"label": "none",
"confidence": 1.0,
"reason": "41 distinct values, numeric statistic"
},
{
"column": "s_boxer_lost",
"label": "none",
"confidence": 1.0,
"reason": "26 distinct values, numeric statistic"
},
{
"column": "s_boxer_drawn",
"label": "none",
"confidence": 1.0,
"reason": "Only 6 distinct values, numeric statistic"
},
{
"column": "s_boxer_KOs",
"label": "none",
"confidence": 1.0,
"reason": "35 distinct values with 9.4% nulls, numeric statistic"
},
{
"column": "rounds",
"label": "none",
"confidence": 0.9,
"reason": "67 distinct values but contains mixed text data, appears to be descriptive field"
},
{
"column": "s_boxer_result",
"label": "none",
"confidence": 1.0,
"reason": "Only 2 distinct values (won/lost), categorical outcome field"
},
{
"column": "matchRounds",
"label": "none",
"confidence": 1.0,
"reason": "Only 10 distinct values with 8.7% nulls, numeric attribute"
},
{
"column": "fightEnd",
"label": "none",
"confidence": 1.0,
"reason": "Only 5 distinct values, categorical outcome attribute"
}
]
}
```