Subchapter 100.1

Finding Exceptions

references/finding-exceptions.mdMarkdown2 KBView on GitHub

Find exception occurrences

For an occurrence UUID, use posthog:execute-sql to select the exact $exception event by uuid.
For a UUID-shaped session ID, use posthog:execute-sql to select events with that exact . Start with a 30-day window and 21 rows. The extra row shows when the first 20 do not cover the session. Narrow or page through the window for a complete list.

Finding Exceptions · Linking Errors To Traces · PostHog/skills · Skills Docs

$exception

$session_id

posthog:execute-sql
SELECT
    uuid,
    issue_id,
    timestamp,
    properties.$session_id AS session_id,
    properties.$trace_id AS trace_id,
    properties.$span_id AS span_id
FROM events
WHERE event = '$exception'
    AND $session_id = '<session_uuid>'
    AND timestamp >= now() - INTERVAL 30 DAY
ORDER BY timestamp DESC
LIMIT 21

{
  "dateRange": { "date_from": "-30d" },
  "status": "all",
  "filterTestAccounts": false,
  "filterGroup": [{ "key": "$session_id", "type": "event", "operator": "exact", "value": "<session_id>" }],
  "limit": 20
}