PHPMem v2.0.1
Version
1.6.45
Uptime
7 days 5 hours 24 minutes 34 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
60 781
Rejected
0
llm:d3cce8c1bf7fa205fa610c63698760aa9d94f5ec483d8f8944ef3e734255acfe
Edit
```json
{
"classifications": [
{
"column": "log_id",
"label": "primary_key",
"confidence": 1.0,
"reason": "100% distinct (303822/303822), zero nulls, BIGINT type - uniquely identifies each log entry"
},
{
"column": "job_id",
"label": "foreign_key",
"confidence": 0.95,
"reason": "598 distinct values across 303822 rows, zero nulls, references job table with pattern j_*"
},
{
"column": "job_type",
"label": "none",
"confidence": 1.0,
"reason": "Only 8 distinct values - categorical attribute, not a key"
},
{
"column": "dataset_id",
"label": "foreign_key",
"confidence": 0.95,
"reason": "112 distinct values across 303822 rows, zero nulls, references dataset table with pattern d_*"
},
{
"column": "batch_id",
"label": "foreign_key",
"confidence": 0.9,
"reason": "138 distinct values, 98% null rate but references batch table with pattern batch_*"
},
{
"column": "tables_catalog_id",
"label": "none",
"confidence": 1.0,
"reason": "100% null, no data - cannot be a key"
},
{
"column": "ts",
"label": "near_key",
"confidence": 0.98,
"reason": "100% distinct (303822/303822), zero nulls - timestamp uniqueness suggests near-key but not intended as primary key"
},
{
"column": "level",
"label": "none",
"confidence": 1.0,
"reason": "Only 4 distinct values (DEBUG, ERROR, INFO, WARN) - categorical attribute"
},
{
"column": "phase",
"label": "none",
"confidence": 1.0,
"reason": "364 distinct values but 77.6% null rate - descriptive attribute, not a key"
},
{
"column": "event_type",
"label": "none",
"confidence": 1.0,
"reason": "Only 10 distinct values - categorical attribute"
},
{
"column": "source_module",
"label": "none",
"confidence": 1.0,
"reason": "54 distinct values - categorical attribute for module names"
},
{
"column": "message",
"label": "none",
"confidence": 1.0,
"reason": "83383 distinct values but free-text log messages, not a key"
},
{
"column": "duration_ms",
"label": "none",
"confidence": 1.0,
"reason": "2378 distinct values, 98.6% null rate - metric attribute, not a key"
},
{
"column": "details_json",
"label": "none",
"confidence": 1.0,
"reason": "8939 distinct values, 92.5% null rate - JSON payload attribute, not a key"
},
{
"column": "exception_json",
"label": "none",
"confidence": 1.0,
"reason": "199 distinct values, 99.7% null rate - JSON error details, not a key"
},
{
"column": "file_path",
"label": "none",
"confidence": 1.0,
"reason": "54 distinct values - categorical attribute for source file paths"
},
{
"column": "function_name",
"label": "none",
"confidence": 1.0,
"reason": "95 distinct values - categorical attribute for function names"
},
{
"column": "line_no",
"label": "none",
"confidence": 1.0,
"reason": "398 distinct values - line number attribute, not a key"
},
{
"column": "process_id",
"label": "none",
"confidence": 1.0,
"reason": "Only 5 distinct values (0-9) - process identifier attribute, not a key"
},
{
"column": "thread_id",
"label": "none",
"confidence": 1.0,
"reason": "3606 distinct values - thread identifier attribute, not a key"
}
]
}
```