PHPMem v2.0.1
Version
1.6.45
Uptime
7 days 7 hours 17 minutes 18 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
62 584
Rejected
0
llm:f0d6a361e18120dd7b6f44cd14c0927376579801681c5d87b7d7f3694a390eb3
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 (~508 logs per job), zero nulls, references job table"
},
{
"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"
},
{
"column": "batch_id",
"label": "foreign_key",
"confidence": 0.9,
"reason": "138 distinct values, 98.1% null rate but when present references batch table"
},
{
"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, but timestamp - not a verified 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 indicating code module"
},
{
"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": "Numeric metric with 98.6% null rate - measurement, not a key"
},
{
"column": "details_json",
"label": "none",
"confidence": 1.0,
"reason": "JSON payload with 92.5% null rate - supplementary data, not a key"
},
{
"column": "exception_json",
"label": "none",
"confidence": 1.0,
"reason": "JSON payload with 99.7% null rate - error details, not a key"
},
{
"column": "file_path",
"label": "none",
"confidence": 1.0,
"reason": "54 distinct values - source code file path, categorical attribute"
},
{
"column": "function_name",
"label": "none",
"confidence": 1.0,
"reason": "95 distinct values - source code function name, categorical attribute"
},
{
"column": "line_no",
"label": "none",
"confidence": 1.0,
"reason": "398 distinct values - source code line number, not a key"
},
{
"column": "process_id",
"label": "none",
"confidence": 1.0,
"reason": "Only 5 distinct values (0-9) - process identifier, categorical attribute"
},
{
"column": "thread_id",
"label": "none",
"confidence": 1.0,
"reason": "3606 distinct values - thread identifier, categorical attribute"
}
]
}
```