PHPMem v2.0.1
Version
1.6.45
Uptime
7 days 4 hours 54 minutes 49 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
60 458
Rejected
0
llm:8eb0a288836b3c762d8392777cab43e6fd35d956a4af976b6385d8ec69d9fd4e
Edit
```json
{
"classifications": [
{
"column": "query_id",
"role": "identifier",
"confidence": 1.0,
"reason": "Primary key with unique values per row (2544 distinct for 2544 rows), VARCHAR format aq_*"
},
{
"column": "tenant_id",
"role": "dimension",
"confidence": 1.0,
"reason": "Categorical field for grouping/filtering by tenant, only 1 distinct value ('default')"
},
{
"column": "dataset_id",
"role": "identifier",
"confidence": 1.0,
"reason": "Foreign key referencing datasets, used for joins (83 distinct values, format d_*)"
},
{
"column": "batch_id",
"role": "identifier",
"confidence": 1.0,
"reason": "Foreign key for batch grouping, used for joins (104 distinct values, format batch_*)"
},
{
"column": "source",
"role": "dimension",
"confidence": 1.0,
"reason": "Categorical field for grouping/filtering by source system (2 distinct values: nia, nia_prelude)"
},
{
"column": "actor",
"role": "dimension",
"confidence": 0.9,
"reason": "Categorical field for user/actor, currently all null but intended for grouping"
},
{
"column": "prompt",
"role": "attribute",
"confidence": 1.0,
"reason": "Free-form text content describing user queries, displayed but not aggregated"
},
{
"column": "generated_sql",
"role": "attribute",
"confidence": 1.0,
"reason": "Free-form SQL text content, displayed but not aggregated (1630 distinct values)"
},
{
"column": "engine",
"role": "dimension",
"confidence": 1.0,
"reason": "Categorical field for grouping by database engine (1 distinct value: duckdb)"
},
{
"column": "mode",
"role": "dimension",
"confidence": 1.0,
"reason": "Categorical field for grouping by execution mode (1 distinct value: analytics)"
},
{
"column": "status",
"role": "dimension",
"confidence": 1.0,
"reason": "Categorical field for grouping/filtering by query status (4 distinct values)"
},
{
"column": "row_count",
"role": "measure",
"confidence": 1.0,
"reason": "Numeric quantity representing rows returned, suitable for aggregation (sum/avg)"
},
{
"column": "truncated",
"role": "dimension",
"confidence": 0.95,
"reason": "Boolean flag (0/1) for filtering/grouping, though currently only 1 value"
},
{
"column": "elapsed_ms",
"role": "measure",
"confidence": 1.0,
"reason": "Numeric quantity for execution time in milliseconds, suitable for aggregation (avg/sum)"
},
{
"column": "tokens_input",
"role": "measure",
"confidence": 1.0,
"reason": "Numeric quantity for input tokens, suitable for aggregation (sum/avg)"
},
{
"column": "tokens_output",
"role": "measure",
"confidence": 1.0,
"reason": "Numeric quantity for output tokens, suitable for aggregation (sum/avg)"
},
{
"column": "cost_usd",
"role": "measure",
"confidence": 1.0,
"reason": "Numeric monetary amount suitable for aggregation (sum/avg)"
},
{
"column": "error_text",
"role": "attribute",
"confidence": 1.0,
"reason": "Free-form error message text, displayed but not aggregated"
},
{
"column": "warnings_json",
"role": "attribute",
"confidence": 1.0,
"reason": "Free-form JSON content, displayed but not aggregated (currently all null)"
},
{
"column": "created_at",
"role": "dimension",
"confidence": 1.0,
"reason": "Timestamp for grouping/filtering by time (2544 distinct values, used for time-based analysis)"
}
]
}
```