PHPMem v2.0.1

Version
1.6.45
Uptime
16 days 19 hours 33 minutes 29 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
14 / 1 024 max
Total
191 669
Rejected
0
llm:4dc3af3aaf2ff6766866da77c4b13e76e6a614cb2667ff691f2e6a39c0ec4199
TTL 6 days 7 hours 51 minutes 22 seconds Size 2,10KB Export
Edit
{
    "action": "tool_call",
    "reasoning": "My earlier draft cited figures I had not queried. I'll ground the answer by profiling all five monthly tables in one query: row counts, Amount formats, and null or blank rates for key columns.",
    "tool": "query_sql",
    "args": {
        "source": "raw",
        "purpose": "Profile row counts, Amount text formats and missing values per monthly table",
        "sql": "WITH u AS (SELECT 'Jan' AS m, \"Company Name\" AS c, Location AS l, Sector AS s, Amount AS a, Stage AS st, Investor AS inv FROM raw.\"Indian Startups _ Funding  Investors Data January 2022\" UNION ALL SELECT 'Feb', \"Company Name\", Location, Sector, Amount, Stage, Investor FROM raw.\"Indian Startups _ Funding  Investors Data February 2022\" UNION ALL SELECT 'Mar', \"Company Name\", Location, Sector, Amount, Stage, Investor FROM raw.\"Indian Startups _ Funding  Investors Data March 2022\" UNION ALL SELECT 'Apr', \"Company Name\", Location, Sector, Amount, Stage, Investor FROM raw.\"Indian Startups _ Funding  Investors Data April 2022\" UNION ALL SELECT 'May', \"Company Name\", Location, Sector, Amount, Stage, Investor FROM raw.\"Indian Startups _ Funding  Investors Data May 2022\") SELECT m AS month, COUNT(*) AS row_count, COUNT(DISTINCT c) AS distinct_companies, SUM(CASE WHEN c IS NULL OR TRIM(c)='' THEN 1 ELSE 0 END) AS blank_company, SUM(CASE WHEN a IS NULL OR TRIM(a)='' THEN 1 ELSE 0 END) AS blank_amount, SUM(CASE WHEN LOWER(a) LIKE '%undisclosed%' THEN 1 ELSE 0 END) AS undisclosed_amount, SUM(CASE WHEN a LIKE '$%' THEN 1 ELSE 0 END) AS dollar_prefixed, SUM(CASE WHEN a IS NOT NULL AND a NOT LIKE '$%' AND LOWER(a) NOT LIKE '%undisclosed%' AND TRIM(a)<>'' THEN 1 ELSE 0 END) AS other_format, SUM(CASE WHEN l IS NULL OR TRIM(l)='' THEN 1 ELSE 0 END) AS blank_location, SUM(CASE WHEN s IS NULL OR TRIM(s)='' THEN 1 ELSE 0 END) AS blank_sector, SUM(CASE WHEN st IS NULL OR TRIM(st)='' THEN 1 ELSE 0 END) AS blank_stage FROM u GROUP BY m ORDER BY CASE m WHEN 'Jan' THEN 1 WHEN 'Feb' THEN 2 WHEN 'Mar' THEN 3 WHEN 'Apr' THEN 4 ELSE 5 END"
    }
}