PHPMem v2.0.1
Version
1.6.45
Uptime
7 days 5 hours 23 minutes 4 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
60 715
Rejected
0
llm:e41d58feae4a39128fa3aa7791a2eef89a5241fadb3e9bc2b4d2b24f9b18a16f
Edit
```json
{
"classifications": [
{
"column": "id",
"label": "primary_key",
"confidence": 1.0,
"reason": "100% distinct (724/724), zero nulls, VARCHAR with 'nf_' prefix pattern indicating unique identifier"
},
{
"column": "dataset_id",
"label": "foreign_key",
"confidence": 1.0,
"reason": "76 distinct values in 724 rows (10.5%), zero nulls, 'd_' prefix pattern suggests reference to datasets table"
},
{
"column": "batch_id",
"label": "foreign_key",
"confidence": 1.0,
"reason": "76 distinct values in 724 rows (10.5%), zero nulls, 'batch_' prefix pattern suggests reference to batches table"
},
{
"column": "probe_kind",
"label": "none",
"confidence": 1.0,
"reason": "Only 8 distinct values, categorical attribute describing probe type"
},
{
"column": "probe_run_id",
"label": "foreign_key",
"confidence": 1.0,
"reason": "197 distinct values in 724 rows (27.2%), zero nulls, 'npr_' prefix pattern suggests reference to probe runs table"
},
{
"column": "fingerprint",
"label": "near_key",
"confidence": 0.95,
"reason": "659 distinct values in 724 rows (91.0%), zero nulls, high but not sufficient distinctness for primary key"
},
{
"column": "kind",
"label": "none",
"confidence": 1.0,
"reason": "Only 8 distinct values, categorical attribute describing finding kind"
},
{
"column": "severity",
"label": "none",
"confidence": 1.0,
"reason": "Only 3 distinct values (high/low/medium), categorical severity level"
},
{
"column": "target_table",
"label": "none",
"confidence": 1.0,
"reason": "100% null rate, no data present"
},
{
"column": "target_column",
"label": "none",
"confidence": 1.0,
"reason": "100% null rate, no data present"
},
{
"column": "summary",
"label": "none",
"confidence": 1.0,
"reason": "665 distinct text descriptions, descriptive attribute not a key"
},
{
"column": "evidence_json",
"label": "none",
"confidence": 1.0,
"reason": "684 distinct JSON blobs, descriptive evidence data not a key"
},
{
"column": "status",
"label": "none",
"confidence": 1.0,
"reason": "Only 2 distinct values (open/resolved), categorical status field"
},
{
"column": "first_seen_at",
"label": "none",
"confidence": 1.0,
"reason": "210 distinct timestamps, temporal attribute not a key"
},
{
"column": "last_seen_at",
"label": "none",
"confidence": 1.0,
"reason": "212 distinct timestamps, temporal attribute not a key"
},
{
"column": "resolved_at",
"label": "none",
"confidence": 1.0,
"reason": "Only 18 distinct values with 90.2% null rate, temporal attribute not a key"
},
{
"column": "confidence",
"label": "none",
"confidence": 1.0,
"reason": "Only 3 distinct numeric values (0.25, 0.95, 1.0), confidence score attribute"
},
{
"column": "recommended_action",
"label": "none",
"confidence": 1.0,
"reason": "536 distinct text recommendations, descriptive attribute not a key"
},
{
"column": "falsifier",
"label": "none",
"confidence": 1.0,
"reason": "572 distinct text values, descriptive attribute not a key"
},
{
"column": "source_table",
"label": "none",
"confidence": 1.0,
"reason": "129 distinct values, descriptive attribute indicating source table name"
},
{
"column": "group_axes",
"label": "none",
"confidence": 1.0,
"reason": "194 distinct values with 44.8% null rate, descriptive attribute not a key"
},
{
"column": "measure",
"label": "none",
"confidence": 1.0,
"reason": "278 distinct values with 0.8% null rate, descriptive measure name attribute"
},
{
"column": "reducer",
"label": "none",
"confidence": 1.0,
"reason": "Only 2 distinct values (mean/sum) with 50.1% null rate, categorical attribute"
},
{
"column": "reducer_permitted_by",
"label": "none",
"confidence": 1.0,
"reason": "Only 3 distinct values with 50.1% null rate, categorical attribute"
}
]
}
```