Add Profile Events for Rows Read in PREWHERE

Why it matters

This feature provides detailed metrics on the number of rows processed specifically during the PREWHERE clause execution. It helps users understand and optimize query performance by offering insight into the effectiveness and cost of the PREWHERE filter, improving resource management and query diagnostics.

How to use it

Users can access the new profile events through query profiling and system tables that expose query execution details. No special configuration is required; the events are automatically available when profiling queries that use PREWHERE.