PHPMem v2.0.1
Version
1.6.45
Uptime
15 days 22 hours 42 minutes 7 seconds
Memory
Total
512MB
Used
9,42MB (1.84%)
Free
502,58MB
Keys
Current
11 496
Total (since start)
35 126
Evictions
0
Reclaimed
738
Expired Unfetched
0
Evicted Unfetched
0
Connections
Current
14 / 1 024 max
Total
181 579
Rejected
0
llm:7e2cffe3a8ac82691568225a8b2ef6344ce4909951dbbefa5addab9660cfa871
Edit
```json
{
"queries": [
{
"query": "SELECT \"AETERM\", COUNT(*) AS event_count FROM \"ae\" GROUP BY \"AETERM\" ORDER BY event_count DESC LIMIT 10",
"description": "Top 10 most frequently reported adverse events in the study."
},
{
"query": "SELECT \"AESEV\", COUNT(*) AS count FROM \"ae\" WHERE \"AESEV\" IS NOT NULL GROUP BY \"AESEV\" ORDER BY count DESC",
"description": "Distribution of adverse events by severity level."
},
{
"query": "SELECT \"USUBJID\", \"AETERM\", \"AESEV\", \"AEDTC\" FROM \"ae\" WHERE \"AETERM\" = 'PRURITUS' ORDER BY \"AEDTC\" DESC LIMIT 20",
"description": "Recent pruritus adverse events with subject ID, severity, and date."
},
{
"query": "SELECT \"AEREL\", COUNT(*) AS count FROM \"ae\" WHERE \"AEREL\" IS NOT NULL GROUP BY \"AEREL\" ORDER BY count DESC",
"description": "Adverse events grouped by relationship to study treatment."
},
{
"query": "SELECT \"USUBJID\", COUNT(*) AS ae_count FROM \"ae\" GROUP BY \"USUBJID\" ORDER BY ae_count DESC LIMIT 15",
"description": "Subjects with the highest number of adverse events reported."
},
{
"query": "SELECT \"AEOUT\", COUNT(*) AS count FROM \"ae\" WHERE \"AEOUT\" IS NOT NULL GROUP BY \"AEOUT\" ORDER BY count DESC",
"description": "Outcomes of all adverse events in the study."
},
{
"query": "SELECT \"AETERM\", \"AESEV\", COUNT(*) AS count FROM \"ae\" WHERE \"AETERM\" = 'ERYTHEMA' GROUP BY \"AETERM\", \"AESEV\"",
"description": "Severity breakdown for erythema adverse events."
},
{
"query": "SELECT \"AESER\", COUNT(*) AS count FROM \"ae\" WHERE \"AESER\" IS NOT NULL GROUP BY \"AESER\" ORDER BY count DESC",
"description": "Count of serious versus non-serious adverse events."
},
{
"query": "SELECT \"AEDECOD\", COUNT(*) AS count FROM \"ae\" WHERE \"AEDECOD\" = 'APPLICATION SITE PRURITUS' GROUP BY \"AEDECOD\"",
"description": "Total count of application site pruritus events."
},
{
"query": "SELECT \"USUBJID\", \"AETERM\", \"AESTDTC\", \"AEENDTC\" FROM \"ae\" WHERE \"AETERM\" = 'RASH' LIMIT 15",
"description": "Sample of rash adverse events with subject ID and start/end dates."
}
]
}
```