BEHIND_BY column in SHOW MATERIALIZED VIEWS shows 12 to 24 hours
There are background MV maintenance jobs that do the refresh periodically. These MV jobs won’t kick in until the number of changes on the base table passes a certain threshold.
Knowledge Base