PHPMem v2.0.1

Version
1.6.45
Uptime
16 days 22 hours 2 minutes 5 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 787
Rejected
0
llm:56c582b94ee969f88b136668bd8268901a591da4f00b2b27c6527cd8a2be26de
TTL 6 days 5 hours 18 minutes 55 seconds Size 1,32KB Export
Edit
{
    "action": "tool_call",
    "reasoning": "The time dimension is the five monthly tables. Get row counts per month plus Amount fill rates and formats in one query.",
    "tool": "query_sql",
    "args": {
        "sql": "WITH u AS (SELECT '2022-01' m, \"Company Name\" c, Amount a, Stage s FROM raw.\"Indian Startups _ Funding  Investors Data January 2022\" UNION ALL SELECT '2022-02', \"Company Name\", Amount, Stage FROM raw.\"Indian Startups _ Funding  Investors Data February 2022\" UNION ALL SELECT '2022-03', \"Company Name\", Amount, Stage FROM raw.\"Indian Startups _ Funding  Investors Data March 2022\" UNION ALL SELECT '2022-04', \"Company Name\", Amount, Stage FROM raw.\"Indian Startups _ Funding  Investors Data April 2022\" UNION ALL SELECT '2022-05', \"Company Name\", Amount, Stage FROM raw.\"Indian Startups _ Funding  Investors Data May 2022\") SELECT m, COUNT(*) AS total_rows, COUNT(c) AS rows_with_company, COUNT(a) AS rows_with_amount, SUM(CASE WHEN a LIKE '$%' THEN 1 ELSE 0 END) AS dollar_amounts, SUM(CASE WHEN a IS NOT NULL AND a NOT LIKE '$%' THEN 1 ELSE 0 END) AS non_dollar_amounts, MIN(a) AS min_a, MAX(a) AS max_a FROM u GROUP BY m ORDER BY m",
        "purpose": "Monthly row counts and amount fill rates",
        "source": "raw"
    }
}