—— capability 1 of 6 · Discovery

Search 200 reports across 52 students

Postgres full-text search over counselling reports, ranked by relevance. Filter by school, grade, or report kind.

Filters: Clear all
Showing: "Krishna Subramanian"

2 results

ranked by relevance · top 30
Test result May 6, 2026 rank 0.34

Mock CET / aptitude battery — Krishna Subramanian

Krishna Subramanian
CY-21108 · Gr 12
Mountain View Public School

Krishna Subramanian completed the mock CET aptitude battery. Performance: Maths 77/100, Logical Reasoning 56/100, English 75/100. Time management

Open student insights → /insights/34
Session note Feb 18, 2025 rank 0.19

Career exploration session — Grade 12

Krishna Subramanian
CY-21108 · Gr 12
Mountain View Public School

Krishna Subramanian was engaged today. We explored their interest in research, discussing pathway options at the intersection of curiosity

Open student insights → /insights/34
—— how Discovery works

Postgres FTS over every report, note and transcript

1
Tokenize

Every reports.text and counsellor_note is indexed by Postgres tsvector (english config). One GIN index, refreshed on insert.

2
Query

Search box runs plainto_tsquery + ts_rank_cd. Filter chips (school, grade, RIASEC, kind) compose into the same SQL — no client-side filtering.

3
Highlight

ts_headline wraps matches in <mark> tags so counsellors see the evidence in context.

4
Rank

Top 30 sorted by rank × recency. The aim is < 200 ms server-side on the full corpus, no Elasticsearch needed.