Strings that look identical but compare unequal

You

Two visually identical strings fail an equality check.

ChatGPT

Almost certainly composed versus decomposed forms: "é" as one code point or as "e" plus a combining accent. Normalise both sides with NFC before comparing, and store normalised so the problem does not come back through a different door.

Tool steps: 3 (reasoning summary, call to python, execution output)

reasoning summary

Checked the query plan, then compared index options.

call to python

rows = run_sql("EXPLAIN (ANALYZE) SELECT ...")
print(rows[:3])

execution output

Seq Scan on events  (cost=0.00..812431.00 rows=41203122 width=16)
  Rows Removed by Filter: 38996878
Planning Time: 0.214 ms
Execution Time: 11842.663 ms

You

Is there a simpler version that gets most of the benefit?

ChatGPT

Yes: do the first step, skip the automation, and revisit in a month. Most of the value is in the first step, and most of the cost is in making it repeatable before you know it is right.