PHPMem v2.0.1

Version
1.6.45
Uptime
17 days 8 hours 56 minutes 27 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
234 414
Rejected
0
llm:aec33bb09e0e3d768db9c6f6bf095863d84437e36eb8880786cfcfd3c7e93bac
TTL 6 days 9 hours 44 minutes 46 seconds Size 2,14KB Export
Edit
<invoke name="query_sql"> <parameter name="sql">WITH t AS (SELECT CASE WHEN AI_Tool IS NULL OR trim(AI_Tool)='' THEN 'Unknown' WHEN lower(replace(AI_Tool,' ','')) IN ('chatgpt') THEN 'ChatGPT' WHEN lower(replace(AI_Tool,' ','')) IN ('copilot','microsoftcopilot') THEN 'Microsoft Copilot' WHEN lower(replace(AI_Tool,' ','')) IN ('gemini','googlegemini') THEN 'Google Gemini' WHEN lower(AI_Tool)='claude' THEN 'Claude' ELSE trim(AI_Tool) END AS AI_Tool, Productivity_Score FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals) SELECT AI_Tool, COUNT(*) AS users, ROUND(AVG(Productivity_Score),2) AS avg_productivity, ROUND(MEDIAN(Productivity_Score),2) AS median_productivity, MIN(Productivity_Score) AS min_productivity, MAX(Productivity_Score) AS max_productivity FROM t GROUP BY AI_Tool ORDER BY avg_productivity DESC</parameter> <parameter name="purpose">Productivity score by AI tool with spelling variants merged</parameter> <parameter name="source">raw</parameter> </invoke> s <invoke name="think"> <parameter name="reasoning">Waiting for result.</parameter> </invoke> <invoke name="query_sql"> <parameter name="sql">WITH t AS (SELECT CASE WHEN AI_Tool IS NULL OR trim(AI_Tool)='' THEN 'Unknown' WHEN lower(replace(AI_Tool,' ','')) IN ('chatgpt') THEN 'ChatGPT' WHEN lower(replace(AI_Tool,' ','')) IN ('copilot','microsoftcopilot') THEN 'Microsoft Copilot' WHEN lower(replace(AI_Tool,' ','')) IN ('gemini','googlegemini') THEN 'Google Gemini' WHEN lower(AI_Tool)='claude' THEN 'Claude' ELSE trim(AI_Tool) END AS AI_Tool, Productivity_Score FROM raw.AI_Usage_and_Impact_on_Students_and_Professionals) SELECT AI_Tool, COUNT(*) AS users, ROUND(AVG(Productivity_Score),2) AS avg_productivity, ROUND(MEDIAN(Productivity_Score),2) AS median_productivity, MIN(Productivity_Score) AS min_productivity, MAX(Productivity_Score) AS max_productivity FROM t GROUP BY AI_Tool ORDER BY avg_productivity DESC</parameter> <parameter name="purpose">Productivity score by AI tool with spelling variants merged</parameter> <parameter name="source">raw</parameter> </invoke>