PHPMem v2.0.1

Version
1.6.45
Uptime
17 days 1 hour 34 minutes 33 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
194 673
Rejected
0
llm:9d2e8e418ebda6735a95222938f0b86a9d7a9b716f86bea64d7796c60f3971f0
TTL 6 days 1 hour 37 minutes 54 seconds Size 2,52KB Export
Edit
{
    "action": "tool_call",
    "reasoning": "The earlier reply cannot be used because I have no tool results in evidence to back its numbers. I'll recompute missing rates (NULL or blank) per column and per month in one query.",
    "tool": "query_sql",
    "args": {
        "sql": "WITH a AS (SELECT 'January' AS m, \"Company Name\" AS c, CAST(Founded AS VARCHAR) AS f, Location AS l, Sector AS s, \"What it does\" AS w, Founders AS fo, Investor AS i, Amount AS am, Stage AS st FROM raw.\"Indian Startups _ Funding  Investors Data January 2022\" UNION ALL SELECT 'February', \"Company Name\", CAST(Founded AS VARCHAR), Location, Sector, \"What it does\", Founders, Investor, Amount, Stage FROM raw.\"Indian Startups _ Funding  Investors Data February 2022\" UNION ALL SELECT 'March', \"Company Name\", CAST(Founded AS VARCHAR), Location, Sector, \"What it does\", Founders, Investor, Amount, Stage FROM raw.\"Indian Startups _ Funding  Investors Data March 2022\" UNION ALL SELECT 'April', \"Company Name\", CAST(Founded AS VARCHAR), Location, Sector, \"What it does\", Founders, Investor, Amount, Stage FROM raw.\"Indian Startups _ Funding  Investors Data April 2022\" UNION ALL SELECT 'May', \"Company Name\", Founded, Location, Sector, \"What it does\", Founders, Investor, Amount, Stage FROM raw.\"Indian Startups _ Funding  Investors Data May 2022\") SELECT m AS month, COUNT(*) AS n_rows, ROUND(100.0*SUM(CASE WHEN c IS NULL OR TRIM(c) IN ('','[]') THEN 1 ELSE 0 END)/COUNT(*),1) AS pct_company, ROUND(100.0*SUM(CASE WHEN f IS NULL OR TRIM(f) IN ('','[]') THEN 1 ELSE 0 END)/COUNT(*),1) AS pct_founded, ROUND(100.0*SUM(CASE WHEN l IS NULL OR TRIM(l) IN ('','[]') THEN 1 ELSE 0 END)/COUNT(*),1) AS pct_location, ROUND(100.0*SUM(CASE WHEN s IS NULL OR TRIM(s) IN ('','[]') THEN 1 ELSE 0 END)/COUNT(*),1) AS pct_sector, ROUND(100.0*SUM(CASE WHEN w IS NULL OR TRIM(w) IN ('','[]') THEN 1 ELSE 0 END)/COUNT(*),1) AS pct_what_it_does, ROUND(100.0*SUM(CASE WHEN fo IS NULL OR TRIM(fo) IN ('','[]') THEN 1 ELSE 0 END)/COUNT(*),1) AS pct_founders, ROUND(100.0*SUM(CASE WHEN i IS NULL OR TRIM(i) IN ('','[]') THEN 1 ELSE 0 END)/COUNT(*),1) AS pct_investor, ROUND(100.0*SUM(CASE WHEN am IS NULL OR TRIM(am) IN ('','[]') THEN 1 ELSE 0 END)/COUNT(*),1) AS pct_amount, ROUND(100.0*SUM(CASE WHEN st IS NULL OR TRIM(st) IN ('','[]') THEN 1 ELSE 0 END)/COUNT(*),1) AS pct_stage FROM a GROUP BY ROLLUP(m) ORDER BY n_rows",
        "purpose": "Missing (NULL/blank) rate per column per month and overall"
    }
}