PHPMem v2.0.1

Version
1.6.45
Uptime
16 days 23 hours 20 minutes 19 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
16 / 1 024 max
Total
193 403
Rejected
0
llm:8bd43ed144c16aefca72706d527bc4a9c4dbd693c12804f444fa7629d4ba8dfa
TTL 6 days 3 hours 56 minutes 29 seconds Size 1,28KB Export
Edit
{
    "action": "tool_call",
    "reasoning": "Profile the format patterns of the Amount column (VARCHAR) across all five monthly tables in one query, to see how amounts are written before parsing them.",
    "tool": "query_sql",
    "args": {
        "sql": "WITH a AS (SELECT 'Jan' AS m, \"Company Name\" AS c, Amount, Stage FROM raw.\"Indian Startups _ Funding  Investors Data January 2022\" UNION ALL SELECT 'Feb', \"Company Name\", Amount, Stage FROM raw.\"Indian Startups _ Funding  Investors Data February 2022\" UNION ALL SELECT 'Mar', \"Company Name\", Amount, Stage FROM raw.\"Indian Startups _ Funding  Investors Data March 2022\" UNION ALL SELECT 'Apr', \"Company Name\", Amount, Stage FROM raw.\"Indian Startups _ Funding  Investors Data April 2022\" UNION ALL SELECT 'May', \"Company Name\", Amount, Stage FROM raw.\"Indian Startups _ Funding  Investors Data May 2022\") SELECT regexp_replace(regexp_replace(coalesce(Amount,'<NULL>'),'[0-9]+','9','g'),'[A-Za-z]+','a','g') AS amount_pattern, COUNT(*) AS n, MIN(Amount) AS ex_min, MAX(Amount) AS ex_max, COUNT(DISTINCT m) AS months FROM a GROUP BY 1 ORDER BY n DESC",
        "purpose": "Profile Amount format patterns across all months",
        "source": "raw"
    }
}