Setting the file. One moment.
Skill 103 · Querying PostHog Data
Subchapter 103.27
references/models-activity-logs.mdMarkdown3 KBView on GitHub
Activity logs track user and system actions across PostHog entities, providing an audit trail of changes to feature flags, insights, dashboards, experiments, and more.
Note: Only team-scoped activity logs are visible. Organisation-level logs (e.g. membership changes) are not included because they are not associated with a specific team.
| Column | Type | Nullable | Description |
|---|---|---|---|
id | String | NOT NULL | Activity log entry UUID. |
team_id | Integer | NOT NULL | |
activity | String | NOT NULL | Action performed, e.g. ‘created’, ‘updated’, ‘deleted’. |
item_id | String | NOT NULL | Id of the object the activity is about. |
scope | String | NOT NULL | Type of object affected, e.g. ‘Insight’, ‘FeatureFlag’, ‘Dashboard’. |
detail | JSON | NOT NULL | JSON detail of what changed (field-level diffs, context). |
created_at | DateTime | NOT NULL | When the activity occurred. |
{
"name": "My Feature Flag",
"short_id": "abc123",
"type": "FeatureFlag",
"changes": [
{
"type": "FeatureFlag",
"action": "changed",
"field": "active",
"before": false,
"after": true
}
]
}Field | Description
name | Display name of the entity
short_id | Short identifier (if applicable)
type | Entity type
changes | Array of individual field changes
changes[].type | Entity type for this change
changes[].action | changed, created, deleted, merged, split, exported, revoked, copied
changes[].field | Name of the field that changed
changes[].before | Previous value
changes[].after | New value
FeatureFlag, Insight, Dashboard, Experiment, Cohort, Survey, Notebook, Action,
HogFunction, Person, Replay, Comment, BatchExport, Team, Project,
ErrorTrackingIssue, EarlyAccessFeature, Annotation, AlertConfiguration
created, updated, deleted, exported, logged_in, logged_out
Find recent activity for a scope:
SELECT id, activity, item_id, detail, created_at
FROM system.activity_logs
WHERE scope = 'FeatureFlag'
ORDER BY created_at DESC
LIMIT 50Find all changes to a specific entity:
SELECT activity, detail, created_at
FROM system.activity_logs
WHERE scope = 'Insight' AND item_id = '42'
ORDER BY created_at DESCSearch for a specific change in detail JSON:
SELECT id, scope, activity, detail, created_at
FROM system.activity_logs
WHERE JSONExtractString(detail, 'name') ILIKE '%signup%'
ORDER BY created_at DESC
LIMIT 20