:hedgehog: PostHog is the leading platform for building self-driving products. Our developer tools – AI observability, analytics, session replay, flags, experiments, error tracking, logs, and more – capture all the context agents need to diagnose problems, uncover opportunities, and ship fixes. Steer it all from Slack, web, desktop, or the MCP.
Python ab-testingai-analyticsanalyticscdpdata-warehouseexperimentsfeature-flagsjavascriptproduct-analyticspythonreactsession-replaysurveystypescriptweb-analytics
/*
-- Tool call extraction is done at ingestion time.
-- The $ai_tools_called property contains comma-separated tool names.
-- See: nodejs/src/ingestion/ai/tools/extract-tool-calls.ts
--
-- Performance: this query only reads $ai_tools_called from the JSON properties blob.
-- solo_pct uses position() to check for commas instead of reading $ai_tool_call_count,
-- avoiding a second JSONExtractRaw + numeric cast per row.
*/
SELECT
arrayJoin(splitByChar(',', assumeNotNull(properties.$ai_tools_called))) as tool,
count() as total_calls,
countDistinctIf(properties.$ai_trace_id, properties.$ai_trace_id != '') as traces,
uniq(distinct_id) as users,
countDistinctIf(properties.$ai_session_id, properties.$ai_session_id != '') as sessions,
uniq(toDate(timestamp)) as days_seen,
round(countIf(position(properties.$ai_tools_called, ',') = 0) * 100 / count()) as single_pct,
min(timestamp) as first_seen,
max(timestamp) as last_seen
FROM events
WHERE event = '$ai_generation'
AND properties.$ai_tools_called != ''
AND tool != ''
AND {filters}
GROUP BY tool
ORDER BY __ORDER_BY__ __ORDER_DIRECTION__
LIMIT 100