Revisions since first reversion deletion

SQL

SELECT count(*)
FROM revision
JOIN page ON rev_page = page_id
#WHERE rev_timestamp >= 20090130081928 AND rev_timestamp < 20120000000000 # 167,248,276 in 1633 seconds
#WHERE rev_timestamp >= 20120000000000 AND rev_timestamp < 20140000000000 # 100,126,964 in 1411.49 seconds
#WHERE rev_timestamp >= 20140000000000 AND rev_timestamp < 20160000000000 # 92,457,677 in 1213.81 seconds
#WHERE rev_timestamp >= 20160000000000 AND rev_timestamp < 20180000000000 # 103,025,694 in 1771.95 seconds
WHERE rev_timestamp >= 20180000000000 #  in  seconds
AND page_namespace IN (0, 1, 2, 3);

SQL

Checking query status...