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