Skip to main content

Peliqan

PostHog

Average session duration by project

SQL query for PostHog

Calculate the average session duration for each project.

SELECT project_id, AVG(duration) FROM sessions GROUP BY project_id

PostHog data model

PostHog
Projects

PostHog
Actions

PostHog
Alerts

PostHog
Annotations

PostHog
Cohorts

PostHog
Dashboards

PostHog
Events

PostHog
Events Export

PostHog
Experiments

PostHog
Groups Types

PostHog
Notebooks

PostHog
Persons

PostHog
Subscriptions

PostHog
Surveys

PostHog
Activity Log

PostHog
Session Values

Ready to get instant access to all your company data ?​

Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.