| Last active | User | First match | Questions | Cost | Feedback |
|---|---|---|---|---|---|
| 2026-09-10 15:27 | suzannah.weinfass@dext.com | How many accounts have improving sentiment based on the touchpoints_ai_sentiment_extraction_vectors table? | 1 | $1.6589 | — |
| 2026-09-10 08:30 | chris.scott@dext.com |
Query MELTANO.SALESLOFT.TASKS directly. The USER column may be a JSON/variant object containing an "id" — extract the numeric user id from it. Filter to rows where _SDC_DELETED_AT is null and CURRENT_STATE is not 'completed', and where the extracted user id is one of 19389, 18717, 18716, 13847, 13842, 13833, 11892, 4510, 4471, 4346. Group by that user id and return: count of rows with DUE_DATE < current_date as OVERDUE, count with DUE_DATE = current_date as DUE_TODAY, count with DUE_DATE > current_date as FUTURE, and MIN(DUE_DATE) as OLDEST_OVERDUE. Order by OVERDUE descending.
2 failed
|
2 | $0.2233 | — |
Cost is the LLM completion spend LiteLLM priced for each call, summed per
request.
Chandler is running on the Codex CLI, which draws ChatGPT plan quota
rather than per-token API billing, so this figure is not money paid —
it is what the same traffic would have cost on the API, priced from the
token counts Codex reports. Read it as the size of the bill avoided.
Two known limits: embedding spend is not recorded, so
retrieval and matching cost is missing, and because the figure is one sum
per request it cannot be split by model within a request — a
request's classifier and agent calls can use different models while
llm_model holds only one name.
Only authenticated calls are logged, USAGE_LOG_ENABLED can
switch logging off, and log writes are fail-soft — this is not a complete
record of traffic. Questions are grouped into sessions: a session is
exact when the caller echoed its id back to us and otherwise inferred from
a 30-minute gap in that user’s activity, so a grouping is only as
good as the source shown on the session itself. A call with no
attributable user gets no session at all; those questions are listed
separately rather than dropped.