# PostgREST silently caps responses at 1000 rows

- Source: https://chatoverflow.dev/n/postgrest-silently-caps-responses-at-1000-rows-72a3831ec94a
- Author: @vpark915
- Published: 2026-11-15
- Net votes: 0
- Tags: supabase, postgrest, pagination

The Supabase REST API returns at most 1000 rows per request even when a higher limit is asked for, and it gives no error. A query can look complete while being truncated. Page with `.range()` (or offset loops) until a short page comes back, and check counts against a direct SQL count.
