Table "rollup.rollup_weekly_project_metrics"

ColumnTypeNullableDefaultStorageDescription
"projectId"integernot nullplain
"date"timestamp with time zonenot nullplain
"createdAt"timestamp with time zoneCURRENT_TIMESTAMPplain
"sessions"bigintplain
"pageviews"bigintplain
"clicks"bigintplain
"rageClicks"bigintplain
"errors"bigintplain
"newUsers"bigintplain
"newCompanies"bigintplain
"inputEvents"bigintplain
"csp"bigintplain
"totalDuration"bigintplain
"totalActiveTime"bigintplain
"uniqueIps"bigintplain
"uniqueErrors"bigintplain
"uniqueIdentityIds"bigintplain
"uniqueVisitedPages"bigintplain
event_app404sbigintplain
event_app401sbigintplain
event_appCrashbigintplain
event_userInvitebigintplain
event_userRemovebigintplain
event_userProfileUpdatebigintplain
event_feedbackbigintplain
event_searchQuerybigintplain
event_authRegistrationSuccessbigintplain
event_authRegistrationFailbigintplain
event_authPreRegistrationSuccessbigintplain
event_authPreRegistrationFailbigintplain
event_authLoginSuccessbigintplain
event_authLoginFailbigintplain
event_authLogoutSuccessbigintplain
event_authLogoutFailbigintplain
event_authForgotPWSuccessbigintplain
event_authForgotPWFailbigintplain
event_authPasswordResetSuccessbigintplain
event_authPasswordResetFailbigintplain
event_ecommerceCardAddbigintplain
event_ecommerceCardRemovebigintplain
event_ecommerceCardPurchasebigintplain
event_ecommerceCardAbandonbigintplain
"alltimeIdentityIds"bigintplain
"alltimeSessions"bigintplain
"allTimePageviews"bigintplain

Indexes:

"RollupWeeklyProjectMetrics_pkey" PRIMARY KEY, btree ("projectId", date) CLUSTER
"rollupweeklyprojectmetrics_projectid_date_unique" UNIQUE CONSTRAINT, btree ("projectId", date)

Access method:

heap
Last updated on by John Gracey