PHPMem v2.0.1

Version
1.6.45
Uptime
17 days 13 hours 14 minutes 11 seconds

Memory

Total
512MB
Used
12,72MB (2.48%)
Free
499,28MB

Keys

Current
14 060
Total (since start)
40 994
Evictions
0
Reclaimed
760
Expired Unfetched
0
Evicted Unfetched
0

Connections

Current
15 / 1 024 max
Total
239 128
Rejected
0
llm:7f41fd184beb2f1cf99fd98f2cf4fd58a84e0bfcb117a6456fcec70b561187d9
TTL 6 days 5 hours 20 minutes 44 seconds Size 2,26KB Export
Edit
The table has one identifier, six categorical dimensions, and nine numeric metrics, but only four of those metrics are stored as numbers. The only date/time column is a pipeline timestamp. This classification comes from the column profiles (`inspect_columns`) on `raw.AI_Usage_and_Impact_on_Students_and_Professionals`. **Identifier** - `User_ID` (VARCHAR) is a near-key, with about 287 distinct values across 300 rows, ranging from U0001 to U0288. It is not perfectly unique, so some IDs repeat. **Categorical dimensions** - `User_Type` has 2 values (Professional, Student). - `Gender` has about 12 distinct values, which suggests inconsistent spellings or casing. - `Education_Level` has about 17 distinct values, also likely inconsistent labels. - `AI_Tool` has about 16 values. - `AI_Purpose` has about 7 values. - `Would_Recommend` has about 4 values, with Yes among them. - `Country` has about 20 values and `Profession` about 110. The profiler tags both as "spatial", but they are really geographic and occupational categories. - `Tasks_Performed` is free text, with about 288 distinct values. It is descriptive rather than a usable dimension. **Numeric metrics** - Stored as numbers: - `Productivity_Score` (DOUBLE) ranges from 1.6 to 10.0 and has 16 nulls. - `Accuracy_Rating` (BIGINT) ranges from 2 to 5 and has 15 nulls. It behaves like an ordinal rating. - `Satisfaction_Score` (BIGINT) ranges from 3 to 10 and has 7 nulls. - Stored as text (VARCHAR) and needing cleaning before analysis: - `Age` - `Monthly_Income`, which is personally identifying, so aggregate it only. - `Monthly_AI_Cost` - `AI_Usage_Hours_Per_Day`, whose values include unit text such as "9.9 hrs". - `Time_Saved_Hours_Per_Week` - `Work_or_Study_Hours_Per_Day` **Dates and times** - There is no business date, such as a survey date or signup date, so time-trend analysis is not possible. - `_ingestion_timestamp` (TIMESTAMP) is the only temporal column. It holds a single value (2026-10-02 09:58:27), so it only records when the data was loaded. **Pipeline metadata, not analytical** - `_batch_id`, `_source_file` and `_source_system` each have one distinct value and can be ignored.