Query Run
# 1M took 30 seconds SELECT count(*) FROM revision WHERE rev_id < 10000000; 5 years ago
SELECT count(*) FROM revision WHERE rev_id < 1000000; 5 years ago
SELECT count(*) FROM revision WHERE rev_id < 100000; 5 years ago
SELECT count(*) FROM revision WHERE rev_id < 10000; 5 years ago
SELECT count(*) FROM revision WHERE rev_id < 1000; 5 years ago
SELECT count(*) FROM revision; 5 years ago
SELECT count(rev_id) FROM revision WHERE rev_deleted = 0; 5 years ago
SELECT count(rev_id) FROM revisions WHERE rev_deleted = 0; 5 years ago