PHPMem v2.0.1

Version
1.6.45
Uptime
16 days 5 hours 19 minutes 43 seconds

Memory

Total
512MB
Used
11,10MB (2.17%)
Free
500,90MB

Keys

Current
12 504
Total (since start)
39 318
Evictions
0
Reclaimed
758
Expired Unfetched
0
Evicted Unfetched
0

Connections

Current
13 / 1 024 max
Total
185 631
Rejected
0
llm:11e261d3ee55e5e86001b34ee0bae604780abfba9d16cc11f4a429ede6dfd0e0
TTL 6 days 21 hours 48 minutes 37 seconds Size 6,59KB Export
Edit
<antml:parameter name="action">tool_call</parameter> <parameter name="tool">query_sql</parameter> <parameter name="args">{"sql":"SELECT 'January' AS tbl, COUNT(*) AS n, COUNT(*)-COUNT(NULLIF(TRIM(CAST(\"Company Name\" AS VARCHAR)),'')) AS company_name, COUNT(*)-COUNT(NULLIF(TRIM(CAST(\"Founded\" AS VARCHAR)),'')) AS founded, COUNT(*)-COUNT(NULLIF(TRIM(\"Location\"),'')) AS location, COUNT(*)-COUNT(NULLIF(TRIM(\"Sector\"),'')) AS sector, COUNT(*)-COUNT(NULLIF(TRIM(\"What it does\"),'')) AS what_it_does, COUNT(*)-COUNT(NULLIF(TRIM(\"Founders\"),'')) AS founders, COUNT(*)-COUNT(NULLIF(TRIM(\"Investor\"),'')) AS investor, COUNT(*)-COUNT(NULLIF(TRIM(\"Amount\"),'')) AS amount, COUNT(*)-COUNT(NULLIF(TRIM(\"Stage\"),'')) AS stage FROM raw.\"Indian Startups _ Funding Investors Data January 2022\" UNION ALL SELECT 'February', COUNT(*), COUNT(*)-COUNT(NULLIF(TRIM(CAST(\"Company Name\" AS VARCHAR)),'')), COUNT(*)-COUNT(NULLIF(TRIM(CAST(\"Founded\" AS VARCHAR)),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Location\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Sector\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"What it does\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Founders\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Investor\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Amount\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Stage\"),'')) FROM raw.\"Indian Startups _ Funding Investors Data February 2022\" UNION ALL SELECT 'March', COUNT(*), COUNT(*)-COUNT(NULLIF(TRIM(CAST(\"Company Name\" AS VARCHAR)),'')), COUNT(*)-COUNT(NULLIF(TRIM(CAST(\"Founded\" AS VARCHAR)),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Location\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Sector\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"What it does\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Founders\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Investor\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Amount\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Stage\"),'')) FROM raw.\"Indian Startups _ Funding Investors Data March 2022\" UNION ALL SELECT 'April', COUNT(*), COUNT(*)-COUNT(NULLIF(TRIM(CAST(\"Company Name\" AS VARCHAR)),'')), COUNT(*)-COUNT(NULLIF(TRIM(CAST(\"Founded\" AS VARCHAR)),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Location\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Sector\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"What it does\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Founders\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Investor\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Amount\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Stage\"),'')) FROM raw.\"Indian Startups _ Funding Investors Data April 2022\" UNION ALL SELECT 'May', COUNT(*), COUNT(*)-COUNT(NULLIF(TRIM(CAST(\"Company Name\" AS VARCHAR)),'')), COUNT(*)-COUNT(NULLIF(TRIM(CAST(\"Founded\" AS VARCHAR)),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Location\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Sector\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"What it does\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Founders\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Investor\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Amount\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Stage\"),'')) FROM raw.\"Indian Startups _ Funding Investors Data May 2022\"","purpose":"Count null or blank values per business column in each monthly table directly from raw data","source":"raw"}</parameter> </invoke> Oops — wrong shape. Let me reply correctly. <antml:parameter name="action">tool_call</parameter> <parameter name="reasoning">The earlier metadata query returned nothing, which may just reflect how it was filtered. Verify directly on raw data, counting NULLs and blank strings per column in each table.</parameter> <parameter name="tool">query_sql</parameter> <parameter name="args">{"sql":"SELECT 'January' AS tbl, COUNT(*) AS n, COUNT(*)-COUNT(NULLIF(TRIM(CAST(\"Company Name\" AS VARCHAR)),'')) AS company_name, COUNT(*)-COUNT(NULLIF(TRIM(CAST(\"Founded\" AS VARCHAR)),'')) AS founded, COUNT(*)-COUNT(NULLIF(TRIM(\"Location\"),'')) AS location, COUNT(*)-COUNT(NULLIF(TRIM(\"Sector\"),'')) AS sector, COUNT(*)-COUNT(NULLIF(TRIM(\"What it does\"),'')) AS what_it_does, COUNT(*)-COUNT(NULLIF(TRIM(\"Founders\"),'')) AS founders, COUNT(*)-COUNT(NULLIF(TRIM(\"Investor\"),'')) AS investor, COUNT(*)-COUNT(NULLIF(TRIM(\"Amount\"),'')) AS amount, COUNT(*)-COUNT(NULLIF(TRIM(\"Stage\"),'')) AS stage FROM raw.\"Indian Startups _ Funding Investors Data January 2022\" UNION ALL SELECT 'February', COUNT(*), COUNT(*)-COUNT(NULLIF(TRIM(CAST(\"Company Name\" AS VARCHAR)),'')), COUNT(*)-COUNT(NULLIF(TRIM(CAST(\"Founded\" AS VARCHAR)),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Location\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Sector\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"What it does\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Founders\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Investor\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Amount\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Stage\"),'')) FROM raw.\"Indian Startups _ Funding Investors Data February 2022\" UNION ALL SELECT 'March', COUNT(*), COUNT(*)-COUNT(NULLIF(TRIM(CAST(\"Company Name\" AS VARCHAR)),'')), COUNT(*)-COUNT(NULLIF(TRIM(CAST(\"Founded\" AS VARCHAR)),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Location\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Sector\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"What it does\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Founders\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Investor\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Amount\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Stage\"),'')) FROM raw.\"Indian Startups _ Funding Investors Data March 2022\" UNION ALL SELECT 'April', COUNT(*), COUNT(*)-COUNT(NULLIF(TRIM(CAST(\"Company Name\" AS VARCHAR)),'')), COUNT(*)-COUNT(NULLIF(TRIM(CAST(\"Founded\" AS VARCHAR)),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Location\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Sector\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"What it does\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Founders\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Investor\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Amount\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Stage\"),'')) FROM raw.\"Indian Startups _ Funding Investors Data April 2022\" UNION ALL SELECT 'May', COUNT(*), COUNT(*)-COUNT(NULLIF(TRIM(CAST(\"Company Name\" AS VARCHAR)),'')), COUNT(*)-COUNT(NULLIF(TRIM(CAST(\"Founded\" AS VARCHAR)),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Location\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Sector\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"What it does\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Founders\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Investor\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Amount\"),'')), COUNT(*)-COUNT(NULLIF(TRIM(\"Stage\"),'')) FROM raw.\"Indian Startups _ Funding Investors Data May 2022\"","purpose":"Count null or blank values per business column in each monthly table directly from raw data","source":"raw"}</parameter> </invoke>