Skip to content

update_editor_month: Fix performance and typo

Neil Shah-Quinn (WMF) requested to merge work/nshahquinn-wmf/editor_month into main

Using REPARTITION(1) rather than COALESCE(1) vastly improves performance by ensuring that the last stage of the job is run in parallel rather than as a single task.

A typo (event_entity='create' rather than event_type='create') caused the whole global_registration_dates subquery to select nothing, which meant global_user_registration was always null.

Bug: T362594

Merge request reports