v.24.12Improvement

Added JoinBuildTableRowCount, JoinProbeTableRowCount, and JoinResultRowCount Profile Events

Added JoinBuildTableRowCount/JoinProbeTableRowCount/JoinResultRowCount profile events. #72842 (Vladimir Cherkasov).
Added new profile events JoinBuildTableRowCount, JoinProbeTableRowCount, and JoinResultRowCount to monitor join operation metrics.

Why it matters

These profile events provide detailed counts of rows involved in join operations, helping users to better understand and optimize join performance by monitoring the number of rows in the build table, probe table, and the resulting joined output.

How to use it

Users can enable and view these profile events during query profiling or monitoring to gather insights about join operations, typically through system query logs or profiling tools that capture profile events.