PHPMem v2.0.1
Version
1.6.45
Uptime
7 days 14 hours 49 minutes 23 seconds
Memory
Total
512MB
Used
13,15MB (2.57%)
Free
498,85MB
Keys
Current
10 030
Total (since start)
11 096
Evictions
0
Reclaimed
196
Expired Unfetched
0
Evicted Unfetched
0
Connections
Current
3 / 1 024 max
Total
70 077
Rejected
0
llm:67b81ba245989480b3c43774a05b0fecec5cb326618712e4af13ba8cf996ac13
Edit
```json
{
"classifications": [
{"column": "log_id", "role": "identifier", "confidence": 1.0, "reason": "Primary key with unique values per row (303822 distinct = row_count)"},
{"column": "job_id", "role": "identifier", "confidence": 1.0, "reason": "Foreign key referencing jobs, used for JOINs (598 distinct values)"},
{"column": "job_type", "role": "dimension", "confidence": 1.0, "reason": "Low-cardinality categorical field (8 types) for grouping/filtering"},
{"column": "dataset_id", "role": "identifier", "confidence": 1.0, "reason": "Foreign key referencing datasets (112 distinct values)"},
{"column": "batch_id", "role": "identifier", "confidence": 1.0, "reason": "Foreign key referencing batches (138 distinct values)"},
{"column": "tables_catalog_id", "role": "identifier", "confidence": 0.9, "reason": "Foreign key field (100% null but structurally an identifier)"},
{"column": "ts", "role": "dimension", "confidence": 1.0, "reason": "Timestamp for filtering and time-based grouping"},
{"column": "level", "role": "dimension", "confidence": 1.0, "reason": "Log level category (4 values: DEBUG, ERROR, INFO, WARN) for filtering"},
{"column": "phase", "role": "dimension", "confidence": 1.0, "reason": "Medium-cardinality categorical field (364 phases) for grouping"},
{"column": "event_type", "role": "dimension", "confidence": 1.0, "reason": "Low-cardinality categorical field (10 types) for grouping/filtering"},
{"column": "source_module", "role": "dimension", "confidence": 1.0, "reason": "Medium-cardinality categorical field (54 modules) for grouping"},
{"column": "message", "role": "attribute", "confidence": 1.0, "reason": "High-cardinality free-form text (83383 distinct) for display only"},
{"column": "duration_ms", "role": "measure", "confidence": 1.0, "reason": "Numeric quantity to aggregate (sum/avg) for performance analysis"},
{"column": "details_json", "role": "attribute", "confidence": 1.0, "reason": "Semi-structured JSON content for display, not aggregated"},
{"column": "exception_json", "role": "attribute", "confidence": 1.0, "reason": "Semi-structured JSON error details for display, not aggregated"},
{"column": "file_path", "role": "dimension", "confidence": 1.0, "reason": "Medium-cardinality categorical field (54 paths) for grouping/filtering"},
{"column": "function_name", "role": "dimension", "confidence": 1.0, "reason": "Medium-cardinality categorical field (95 functions) for grouping"},
{"column": "line_no", "role": "dimension", "confidence": 0.9, "reason": "Numeric code representing source line (398 distinct) for filtering/grouping"},
{"column": "process_id", "role": "dimension", "confidence": 1.0, "reason": "Low-cardinality numeric code (5 processes) for grouping"},
{"column": "thread_id", "role": "dimension", "confidence": 0.8, "reason": "High-cardinality numeric code (3606 threads) for filtering/grouping"}
]
}
```