Table "rollup.rollup_daily_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
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
"uniqueErrors"bigintplain
"uniqueIdentityIds"bigintplain
"uniqueVisitedPages"bigintplain
"uniqueIpAddresses"bigintplain
"uniqueHllIpAddresses"hll(13,6,-1,1)external
"uniqueHllErrors"hll(11,5,-1,1)external
"uniqueHllIdentityIds"hll(13,6,-1,1)external
"uniqueHllVisitedPages"hll(11,5,-1,1)external
lostUsers7DaysHllhll(12,5,-1,1)external
lostUsers14DaysHllhll(12,5,-1,1)external
lostUsers30DaysHllhll(12,5,-1,1)external
lostUsers30Daysbigintplain
lostUsers30DaysCumulativebigintplain

Indexes:

"RollupDailyProjectMetrics_pkey" PRIMARY KEY, btree ("projectId", date) CLUSTER
"rollupdailyprojectmetrics_projectid_date_unique" UNIQUE CONSTRAINT, btree ("projectId", date)
"rollupdailyprojectmetrics_projectid_date_pageviews_index" btree ("projectId", date, pageviews)
"rollupdailyprojectmetrics_projectid_date_sessions_index" btree ("projectId", date, sessions)

Access method:

heap
Last updated on by John Gracey