Function getSessionIndexStats

packages/core/src/query/session-queries.ts:404–428

(db: DatabaseAdapter)

 * Session index statistics: count, existence flag, and gap threshold from meta.
 */
export function getSessionIndexStats(db: DatabaseAdapter): SessionIndexStats {
  let sessionCount = 0
  if (hasTable(db, 'segment')) {
    try {
      const row = db.prepare('SELECT COUNT(*) as count FROM segment').get() as { count: number } | undefined
      sessionCount = row?.count ?? 0
    } catch {
      /* table may not exist */
    }
  }

  let gapThreshold = DEFAULT_SESSION_GAP_THRESHOLD
  try {
    const meta = db.prepare('SELECT session_gap_threshold FROM meta LIMIT 1').get() as
      | { session_gap_threshold: number | null }
      | undefined
    if (meta?.session_gap_threshold) {
      gapThreshold = meta.session_gap_threshold
    }
  } catch {
    /* column may not exist */
  }

  return { sessionCount, hasIndex: sessionCount > 0, gapThreshold }
}

/**
 * Query chat sessions within a time range.