PHPMem v2.0.1
Version
1.6.45
Uptime
7 days 8 hours 59 minutes 40 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
2 / 1 024 max
Total
64 601
Rejected
0
llm:13770ca589c6b03541bbd13a0ed5f5956ed5a351723d19c74ea85814306bf26b
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 joining (598 distinct jobs)"},
{"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 datasets)"},
{"column": "batch_id", "role": "identifier", "confidence": 1.0, "reason": "Foreign key referencing batches (138 distinct batches)"},
{"column": "tables_catalog_id", "role": "identifier", "confidence": 0.9, "reason": "Foreign key (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 (364 phases) for grouping/filtering"},
{"column": "event_type", "role": "dimension", "confidence": 1.0, "reason": "Low-cardinality categorical (10 types) for grouping/filtering"},
{"column": "source_module", "role": "dimension", "confidence": 1.0, "reason": "Medium-cardinality categorical (54 modules) for grouping/filtering"},
{"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 duration in milliseconds)"},
{"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 (54 paths) for grouping/filtering"},
{"column": "function_name", "role": "dimension", "confidence": 1.0, "reason": "Medium-cardinality categorical (95 functions) for grouping/filtering"},
{"column": "line_no", "role": "dimension", "confidence": 0.9, "reason": "Low-cardinality numeric code (398 values) for filtering/grouping by source location"},
{"column": "process_id", "role": "dimension", "confidence": 1.0, "reason": "Low-cardinality numeric code (5 processes) for grouping/filtering"},
{"column": "thread_id", "role": "dimension", "confidence": 0.8, "reason": "High-cardinality (3606) but used for grouping by thread, not aggregation"}
]
}
```