Requested at https://www.mediawiki.org/wiki/Topic:Vp2ayoa175kry93l
The query is actually pretty fast, sorting by page_len. Various filtering options could be added, such as namespaces, and only showing pages with titles that match a certain pattern.
A Quarry example: https://quarry.wmflabs.org/query/46195 (1.67 seconds)