On Toolforge, I would like to easily find out what indexes are available on a given table and given schema. It seems this is normally offered in statistics table of information_schema, but I see information_schema_p.statistics is missing.
information_schema.statistics (not _p) is available, but for whatever reason I'm unable to query it. Even for a simple SELECT with LIMIT 1 it just hangs.
Most ideal would be the ability to do SHOW INDEX FROM enwiki_p.revision, and even better somehow make this work on the views like revision_userindex.