PHPMem v2.0.1

Version
1.6.45
Uptime
16 days 23 hours 58 minutes 25 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
193 813
Rejected
0
llm:c9976f99fef70f45c8a904734ebbcc9e48154b56b504cc349b07d9cc07142814
TTL 6 days 3 hours 8 minutes 13 seconds Size 1 000,00B Export
Edit
{
    "action": "tool_call",
    "reasoning": "Get top values and shares for the main categorical columns in one query over raw.startup_funding.",
    "tool": "query_sql",
    "args": {
        "sql": "WITH t AS (SELECT 'Industry Vertical' AS col, \"Industry Vertical\" AS v FROM raw.startup_funding UNION ALL SELECT 'SubVertical', \"SubVertical\" FROM raw.startup_funding UNION ALL SELECT 'City Location', \"City  Location\" FROM raw.startup_funding UNION ALL SELECT 'InvestmentnType', \"InvestmentnType\" FROM raw.startup_funding), c AS (SELECT col, v, COUNT(*) AS n FROM t GROUP BY col, v), r AS (SELECT col, v, n, ROUND(100.0 * n / SUM(n) OVER (PARTITION BY col), 1) AS pct, ROW_NUMBER() OVER (PARTITION BY col ORDER BY n DESC) AS rk FROM c) SELECT col, rk, v, n, pct FROM r WHERE rk <= 7 ORDER BY col, rk",
        "purpose": "Top values and frequencies for main categorical columns",
        "source": "raw"
    }
}