Timing co-occurrences

SQL

SET STATEMENT max_statement_time = 90 FOR
SELECT
  actor_name,
  COUNT(DISTINCT rc_timestamp DIV 10000) AS overlap_hours
FROM
  recentchanges_userindex AS recentchanges
  INNER JOIN change_tag ON recentchanges.rc_id = change_tag.ct_rc_id
  INNER JOIN change_tag_def ON change_tag.ct_tag_id = change_tag_def.ctd_id
  INNER JOIN actor_recentchanges AS actor ON recentchanges.rc_actor = actor.actor_id
WHERE
  TRUE
  AND rc_type = 0
  AND rc_namespace = 0
  AND rc_bot = 0
  AND actor_user IS NOT NULL
  AND change_tag_def.ctd_name = 'visualeditor'
  AND rc_timestamp >= (CURRENT_DATE - INTERVAL 30 DAY)
  AND (rc_timestamp DIV 10000) IN (
    SELECT
      DISTINCT rc_timestamp DIV 10000
    FROM
      recentchanges_userindex AS recentchanges
      INNER JOIN change_tag ON recentchanges.rc_id = change_tag.ct_rc_id
      INNER JOIN change_tag_def ON change_tag.ct_tag_id = change_tag_def.ctd_id
      INNER JOIN actor_recentchanges AS actor ON recentchanges.rc_actor = actor.actor_id
    WHERE
      TRUE
      AND rc_type = 0
      AND rc_namespace = 0
      AND rc_bot = 0
      AND actor_user IS NOT NULL
      AND change_tag_def.ctd_name = 'visualeditor'
      AND rc_timestamp >= (CURRENT_DATE - INTERVAL 30 DAY)
      AND actor_name = 'MikaPotterx'
  )
  GROUP BY actor_name
  ORDER BY overlap_hours DESC;
SQL

Checking query status...
