PHPMem v2.0.1

Version
1.6.45
Uptime
16 days 22 hours 1 minute 55 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
192 779
Rejected
0
llm:66143d47d249894a7cc57eb0d5d36dd9df1bbdc246b4b8966362a9b19eb449a9
TTL 6 days 5 hours 16 minutes 51 seconds Size 1,51KB Export
Edit
{
    "action": "tool_call",
    "reasoning": "Amount is the sole measure and is stored as text in every monthly table. I'll parse it to a number across all five tables and pull the top 5 and bottom 5 rounds.",
    "tool": "query_sql",
    "args": {
        "sql": "WITH a AS (SELECT 'Jan 2022' AS month, \"Company Name\" AS company, Sector, Stage, Amount FROM raw.\"Indian Startups _ Funding  Investors Data January 2022\" UNION ALL SELECT 'Feb 2022', \"Company Name\", Sector, Stage, Amount FROM raw.\"Indian Startups _ Funding  Investors Data February 2022\" UNION ALL SELECT 'Mar 2022', \"Company Name\", Sector, Stage, Amount FROM raw.\"Indian Startups _ Funding  Investors Data March 2022\" UNION ALL SELECT 'Apr 2022', \"Company Name\", Sector, Stage, Amount FROM raw.\"Indian Startups _ Funding  Investors Data April 2022\" UNION ALL SELECT 'May 2022', \"Company Name\", Sector, Stage, Amount FROM raw.\"Indian Startups _ Funding  Investors Data May 2022\"), p AS (SELECT *, TRY_CAST(REPLACE(REPLACE(Amount,'$',''),',','') AS DOUBLE) AS usd FROM a), r AS (SELECT *, ROW_NUMBER() OVER (ORDER BY usd DESC) AS rk_hi, ROW_NUMBER() OVER (ORDER BY usd ASC) AS rk_lo FROM p WHERE usd IS NOT NULL) SELECT CASE WHEN rk_hi<=5 THEN 'highest' ELSE 'lowest' END AS side, month, company, Sector, Stage, Amount, usd FROM r WHERE rk_hi<=5 OR rk_lo<=5 ORDER BY usd DESC",
        "purpose": "Top 5 and bottom 5 funding amounts across all months",
        "source": "raw"
    }
}