Does Filtering Apply to Full Dataset Before Limiting to 2,000 Rows?

Hello,

I recently upgraded to the Pro version of Metabase, and I noticed that it displays the message: "Showing first 2,000 rows." I understand that it limits the visible rows to 2,000, but I’m unsure how the filtering process works.

If I have a dataset with, say, 100,000 rows in Supabase, does Metabase apply the filter to the entire dataset and then show me the first 2,000 matching rows? Or does it only process a subset of the data?

I want to ensure that my filters are applied to the full dataset for accurate results, even if only 2,000 rows are displayed. Can anyone clarify how this works?