When I ran this query on the Clouds via Quarry:
select count(*) total_pages, sum(page_is_redirect) redirects
The [[ https://quarry.wmflabs.org/query/26903 | EXPLAIN results from Quarry ]] was as follows:
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE page ALL 2775439
1 SIMPLE revision eq_ref PRIMARY PRIMARY 4 fawiki.page.page_latest 1 Using index
Why would it reference the revision table?