Use (select auth.uid()) instead of auth.uid() in policies | BeforeMerge Rules | BeforeMerge

Use (select auth.uid()) instead of auth.uid() in policies | BeforeMerge Rules | BeforeMerge

Why This Matters

PostgreSQL may evaluate auth.uid() per-row without the subquery wrapper. On a table with millions of rows, this adds overhead.

Good

CREATE POLICY "own_data" ON profiles
  FOR SELECT USING (id = (SELECT auth.uid()));

Bad

CREATE POLICY "own_data" ON profiles
  FOR SELECT USING (id = auth.uid());  -- evaluated per row