PHPMem v2.0.1
Version
1.6.45
Uptime
7 days 10 hours 41 minutes 41 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
66 223
Rejected
0
llm:31b79cc0c67d126c35f74f1ea469168138a3f6d271276b2eae7e4f7f2ae90452
Edit
```json
{
"classifications": [
{
"column": "id",
"label": "primary_key",
"confidence": 1.0,
"reason": "100% distinct (5297/5297), zero nulls, VARCHAR with 'msg_' prefix pattern - uniquely identifies each message"
},
{
"column": "conversation_id",
"label": "foreign_key",
"confidence": 1.0,
"reason": "49.7% distinct (2631/5297), zero nulls, 'cnv_' prefix - references conversations table, values repeat as expected for FK"
},
{
"column": "dataset_id",
"label": "foreign_key",
"confidence": 1.0,
"reason": "1.7% distinct (90/5297), zero nulls, 'd_' prefix - references datasets table, many messages per dataset"
},
{
"column": "author_fingerprint",
"label": "foreign_key",
"confidence": 0.95,
"reason": "0.34% distinct (18/5297), zero nulls, UUID format - references users/authors, many messages per author"
},
{
"column": "role",
"label": "none",
"confidence": 1.0,
"reason": "Only 2 distinct values (assistant/user) - categorical dimension, not a key"
},
{
"column": "status",
"label": "none",
"confidence": 1.0,
"reason": "Only 3 distinct values (complete/failed/partial) - categorical status field"
},
{
"column": "content_md",
"label": "none",
"confidence": 1.0,
"reason": "35.4% distinct, zero nulls - text content field, not a key"
},
{
"column": "content_html",
"label": "none",
"confidence": 1.0,
"reason": "34.3% distinct, 50.2% nulls - text content field, not a key"
},
{
"column": "evidence_json",
"label": "none",
"confidence": 1.0,
"reason": "28.2% distinct, 50.2% nulls - JSON data field, not a key"
},
{
"column": "confidence",
"label": "none",
"confidence": 1.0,
"reason": "Only 3 distinct values, 50.2% nulls - categorical measure, not a key"
},
{
"column": "partial_reason",
"label": "none",
"confidence": 1.0,
"reason": "Only 5 distinct values, 96.1% nulls - categorical field, not a key"
},
{
"column": "stop_reason",
"label": "none",
"confidence": 1.0,
"reason": "Only 5 distinct values, 50.0% nulls - categorical field, not a key"
},
{
"column": "tokens_in",
"label": "none",
"confidence": 1.0,
"reason": "32.5% distinct, zero nulls - numeric measure, not a key"
},
{
"column": "tokens_out",
"label": "none",
"confidence": 1.0,
"reason": "27.3% distinct, zero nulls - numeric measure, not a key"
},
{
"column": "cost_usd",
"label": "none",
"confidence": 1.0,
"reason": "33.0% distinct, zero nulls - numeric measure, not a key"
},
{
"column": "models_json",
"label": "none",
"confidence": 1.0,
"reason": "Only 7 distinct values, 50.2% nulls - categorical JSON field, not a key"
},
{
"column": "created_at",
"label": "none",
"confidence": 1.0,
"reason": "100% distinct but timestamp field - temporal measure, not a business key"
},
{
"column": "blocks_json",
"label": "none",
"confidence": 1.0,
"reason": "28.2% distinct, 50.5% nulls - JSON data field, not a key"
},
{
"column": "author_ip",
"label": "none",
"confidence": 1.0,
"reason": "Only 7 distinct values, 97.2% nulls - sparse attribute, not a key"
},
{
"column": "author_geo",
"label": "none",
"confidence": 1.0,
"reason": "Only 3 distinct values, 99.7% nulls - sparse attribute, not a key"
},
{
"column": "error_json",
"label": "none",
"confidence": 1.0,
"reason": "51 distinct values, 99.0% nulls - sparse JSON field, not a key"
},
{
"column": "served_from_cache",
"label": "none",
"confidence": 1.0,
"reason": "Only 2 distinct values (0/1), zero nulls - boolean flag, not a key"
},
{
"column": "turn_cache_key",
"label": "none",
"confidence": 1.0,
"reason": "29.8% distinct, 54.9% nulls - cache identifier but not unique enough for primary key"
},
{
"column": "alternates_json",
"label": "none",
"confidence": 1.0,
"reason": "4.5% distinct, 95.5% nulls - sparse JSON field, not a key"
}
]
}
```