PHPMem v2.0.1

Version
1.6.45
Uptime
16 days 22 hours 44 minutes 2 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 104
Rejected
0
llm:091e6be626b3e798e3ec1c4c9bcb28c979fc163d1dfc0528a0b0c16e24dc5bab
TTL 6 days 4 hours 36 minutes 15 seconds Size 1,35KB Export
Edit
{
    "action": "tool_call",
    "reasoning": "Time dimension = monthly tables Jan-May 2022. Compute per-month round counts and total/median disclosed amount. Amount is VARCHAR, so strip '$' and ',' and use TRY_CAST.",
    "tool": "query_sql",
    "args": {
        "sql": "WITH u AS (SELECT 1 AS m, 'Jan' AS month, \"Company Name\" AS c, Amount AS a FROM raw.\"Indian Startups _ Funding  Investors Data January 2022\" UNION ALL SELECT 2, 'Feb', \"Company Name\", Amount FROM raw.\"Indian Startups _ Funding  Investors Data February 2022\" UNION ALL SELECT 3, 'Mar', \"Company Name\", Amount FROM raw.\"Indian Startups _ Funding  Investors Data March 2022\" UNION ALL SELECT 4, 'Apr', \"Company Name\", Amount FROM raw.\"Indian Startups _ Funding  Investors Data April 2022\" UNION ALL SELECT 5, 'May', \"Company Name\", Amount FROM raw.\"Indian Startups _ Funding  Investors Data May 2022\"), p AS (SELECT m, month, c, a, TRY_CAST(REPLACE(REPLACE(a, '$', ''), ',', '') AS DOUBLE) AS amt FROM u) SELECT month, COUNT(c) AS rounds, COUNT(amt) AS rounds_with_amount, SUM(amt) AS total_usd, MEDIAN(amt) AS median_usd, COUNT(*) - COUNT(c) AS blank_rows FROM p GROUP BY m, month ORDER BY m",
        "purpose": "Monthly trend of funding rounds and disclosed amounts Jan-May 2022",
        "source": "raw"
    }
}