Table "atomic.session"

ColumnTypeNullableDefaultStorageDescription
"projectId"integernot nullplain
"sessionId"character varying(37)not nullextended
"identityId"character varying(80)extended
"anonymousId"character varying(37)extendedFor tracking when no identityId is known. Used for stitching sessions.
"tags"text[]extended
"deviceId"character varying(37)extended
"visitId"character varying(37)extended
"tabId"character varying(37)extendedUsed for external page path analysis
"pageId"character varying(37)extendedHandles static pages and socket reconnects
"sessionStart"timestamp with time zonenot nullplain
"sessionEnd"timestamp with time zonenot nullplain
"duration"integernot nullplain
"activeTime"integerplain
"localStartTime"time without time zoneplain
"timezoneOffset"integerplain
"timezoneIANA"character varying(255)extended
"clockSkew"integerplain
"browserFingerprint"character varying(80)extended
"deviceFingerprint"character varying(80)extended
"ipAddress"inetmain
"countryCode"character varying(4)extended
"region"character varying(32)extended
"city"character varying(32)extended
"isBot"booleanplain
"userAgent"character varying(160)extended
"browserVersion"integerplain
"browserName"character varying(32)extended
"engineName"character varying(24)extended
"deviceCategory"character varying(24)extended
"deviceVendor"character varying(24)extended
"deviceType"character varying(24)extended
"deviceModel"character varying(32)extended
"osName"character varying(24)extended
"maxTouchPoints"smallintplain
"screenWidth"smallintplain
"screenHeight"smallintplain
"requestedLanguage"character varying(2)extended
"requestedRegion"character varying(2)extended
"translatedLanguage"character varying(12)extended
"utmCampaign"text[]extended
"utmMedium"text[]extended
"utmSource"text[]extended
"utmTerm"text[]extended
"utmContent"text[]extended
"referrerURLOrigin"character varying(255)extended
"referrerURLPath"character varying(255)extended
"referrerURLSearchParams"jsonbextended
"initTitle"character varying(128)extended
"initURLOrigin"character varying(255)extended
"initURLPath"character varying(255)extended
"initURLSearchParams"jsonbextended
"exitTitle"character varying(128)extended
"exitURLOrgin"character varying(255)extended
"exitURLPath"character varying(255)extended
"exitURLSearchParams"jsonbextended
"pageReloaded"booleanplain
"domInteractive"integerplainMilliseconds until Document.readyState changes to "interactive" and the corresponding readystatechange event is thrown.
"domContentLoaded"integerplain
"load"integerplain
"notes"character varying(255)extended
"companyId"textextended
"userActionsCount"integerplain
"userType"integerplain
"public"booleanfalseplain
"softDeleted"timestamp with time zoneplain
"pageViewsCount"integerplain
"buildHash"character varying(32)extended
"verified"booleanplain
"hasHtml"booleanplain
"wisdomVersion"character varying(20)extended
"pageCreatedAt"timestamp with time zoneplain
"softDeletedAt"timestamp with time zoneplain
s3Bytesintegerplain

Indexes:

"Session_pkey" PRIMARY KEY, btree ("projectId", "sessionStart", "sessionId")
"Session_companyId" btree ("companyId")
"Session_tags" gin (tags)
"Session_utmCampaign" gin ("utmCampaign")
"Session_utmContent" gin ("utmContent")
"Session_utmMedium" gin ("utmMedium")
"Session_utmSource" gin ("utmSource")
"Session_utmTerm" gin ("utmTerm")
"session__idx__proj_start_session_duration" btree ("projectId", "sessionStart", "sessionId", "activeTime", duration, "identityId", "pageViewsCount")
"session_projectid_anonymousid_sessionstart_index" btree ("projectId", "anonymousId", "sessionStart")
"session_projectid_deviceid_index" btree ("projectId", "deviceId")
"session_projectid_identityid_sessionstart_index" btree ("projectId", "identityId", "sessionStart")
"session_projectid_ipaddress_sessionstart_sessionid_index" btree ("projectId", "ipAddress", "sessionStart", "sessionId")
"session_projectid_screenwidth_index" btree ("projectId", "screenWidth")
"session_projectid_sessionid_index" btree ("projectId", "sessionId")

Policies:

POLICY "Session__rls_1_policy"
USING (("projectId" = get_user_accessible_project_id()))

Access method:

heap
Last updated on by John Gracey