PHPMem v2.0.1
Version
1.6.45
Uptime
7 days 19 hours 46 seconds
Memory
Total
512MB
Used
8,15MB (1.59%)
Free
503,85MB
Keys
Current
6 252
Total (since start)
11 098
Evictions
0
Reclaimed
299
Expired Unfetched
0
Evicted Unfetched
0
Connections
Current
3 / 1 024 max
Total
72 520
Rejected
0
llm:df5be6f921a61ac283b67cad607f29f1218e494ade1daf10e2d2f06200b1b771
Edit
```json
{
"classifications": [
{
"column": "id",
"label": "primary_key",
"confidence": 1.0,
"reason": "100% distinct (1533257/1533257), zero nulls, uniquely identifies each row"
},
{
"column": "tables_catalog_id",
"label": "foreign_key",
"confidence": 1.0,
"reason": "References tables_catalog table, 19340 distinct values with repetition across 1533257 rows"
},
{
"column": "column_name",
"label": "none",
"confidence": 0.95,
"reason": "Only 7796 distinct values for 1533257 rows (0.5% distinct), descriptive attribute not a key"
},
{
"column": "ordinal",
"label": "none",
"confidence": 0.95,
"reason": "Only 423 distinct values, represents column position/order, not a key"
},
{
"column": "arrow_type",
"label": "none",
"confidence": 1.0,
"reason": "Only 10 distinct values, categorical type classification"
},
{
"column": "duckdb_type",
"label": "none",
"confidence": 1.0,
"reason": "Only 10 distinct values, categorical type classification"
},
{
"column": "sqlite_type",
"label": "none",
"confidence": 1.0,
"reason": "Only 3 distinct values, categorical type classification"
},
{
"column": "is_nullable",
"label": "none",
"confidence": 1.0,
"reason": "Only 1 distinct value, boolean flag"
},
{
"column": "null_count",
"label": "none",
"confidence": 1.0,
"reason": "Metric/measure column, 2570 distinct values"
},
{
"column": "distinct_count",
"label": "none",
"confidence": 1.0,
"reason": "Metric/measure column with 78.8% nulls"
},
{
"column": "min_value",
"label": "none",
"confidence": 1.0,
"reason": "Metric/measure column storing minimum values"
},
{
"column": "max_value",
"label": "none",
"confidence": 1.0,
"reason": "Metric/measure column storing maximum values"
},
{
"column": "semantic_role",
"label": "none",
"confidence": 1.0,
"reason": "Only 8 distinct values, categorical classification"
},
{
"column": "rough_kind",
"label": "none",
"confidence": 1.0,
"reason": "Only 5 distinct values, categorical classification with 99.5% nulls"
},
{
"column": "avg_value",
"label": "none",
"confidence": 1.0,
"reason": "Metric/measure column with 99.98% nulls"
},
{
"column": "avg_non_null",
"label": "none",
"confidence": 1.0,
"reason": "Metric/measure column with 99.97% nulls"
}
]
}
```