SELECT
    table_schema
  , count(1) as tables
FROM information_schema.TABLES
WHERE table_schema regexp '^[psu][0-9]'
GROUP BY table_schema;


-- labsdb1001.eqiad.wmnet

+---------------------------------------+--------+
| table_schema                          | tables |
+---------------------------------------+--------+
| p50380g40014__test                    |      1 |
| p50380g50491_common                   |     11 |
| p50380g50491_inconsistent_redirects   |      2 |
| p50380g50491_oddlinks                 |      2 |
| p50380g50491_rlrl_enwiki              |     27 |
| p50380g50491_unlikely                 |      5 |
| p50380g50491__rlrl_enwiki_p           |     24 |
| p50380g50491__rlrl_ptwiki_p           |     22 |
| p50380g50491__unlikely_enwiki_p       |      7 |
| p50380g50491__unlikely_ptwiki_p       |      5 |
| p50380g50494_data                     |     17 |
| p50380g50497__wikidb_commonswiki      |     50 |
| p50380g50497__wikidb_enwiki           |     50 |
| p50380g50497__wikidb_zhwiki           |     59 |
| p50380g50512__                        |     49 |
| p50380g50551__UTRS                    |     12 |
| p50380g50553__ilc                     |      5 |
| p50380g50592__interwikis_p            |      1 |
| p50380g50692__DPL_p                   |     54 |
| p50380g50728__hostbot_p               |     21 |
| p50380g50816__pop_stats               |     30 |
| p50380g50824__contributionsurveyor    |      1 |
| p50380g50838__geophotoreq             |      1 |
| p50380g50900_testdb                   |      4 |
| p50380g50921__ghel_p                  |     18 |
| p50380g50921__wma_p                   |      3 |
| s51055__AnomieBOT                     |      1 |
| s51058__dat                           |      1 |
| s51073__toolserver                    |      1 |
| s51111__common_p                      |     13 |
| s51111__inconsistent_redirects_p      |      2 |
| s51111__oddlinks_p                    |      2 |
| s51111__rlrl_enwiki_p                 |     24 |
| s51111__rlrl_ptwiki_p                 |     22 |
| s51111__unlikely_enwiki_p             |      5 |
| s51111__unlikely_ptwiki_p             |      5 |
| s51127__dewiki_Bilderwunsch_p         |      2 |
| s51127__dewiki_new                    |      5 |
| s51127__stats_p                       |      1 |
| s51127__temp_transient                |      5 |
| s51127__toolserverdb                  |      1 |
| s51154__catscan2                      |      6 |
| s51172__user                          |      1 |
| s51187__xtools_tmp                    |    357 |
| s51206__ptwikis_p                     |      1 |
| s51223__lists_p                       |      1 |
| s51306__copyright_p                   |      2 |
| s51329__afc_statistics                |      4 |
| s51334__enwiki_first_page_revisions_p |      1 |
| s51362__erwin85                       |     16 |
| s51417__artplusfem_nyc_2015_moma      |      1 |
| s51454__CategoryWatchlistBot          |      6 |
| s51454__CleanupWorklistBot            |      5 |
| s51454__TemplateParamBot_p            |      9 |
| s51454__wikidata                      |      6 |
| s51698__yetkin2                       |      5 |
| s51755__tmp                           |      6 |
| s51892_toolserverdb                   |      5 |
| s51892_toolserverdb_p                 |      6 |
| s52037_yicheng                        |      4 |
| s52107_reports                        |      1 |
| s52365__devtestwiki                   |     49 |
| s52467__hashtags                      |      7 |
| s52490__hashtags_p                    |      5 |
| s52524__rwtest                        |      1 |
| s52690__                              |      5 |
| s52690__p                             |      3 |
| s52744__tif                           |      1 |
| s53012__fikarummet_p                  |      1 |
| s53024__sandbox_p                     |      1 |
| s53151__spamwatch_test                |      1 |
| s53311__wikidata_usage_and_views_p    |      8 |
| s53381__extra                         |      6 |
| u10276__tmp                           |      1 |
| u11049__Revision_2015JanFeb           |      3 |
| u12219__wikied_p                      |     18 |
| u2029__quarry                         |      1 |
| u2041_test                            |      1 |
| u2041__botvbot_p                      |      3 |
| u2041__ores_p                         |      1 |
| u2041__thr_p                          |      2 |
| u2043__infocycle                      |      2 |
| u2117_test                            |      1 |
| u2248__AnomieBOT                      |      1 |
| u2248__tmp                            |      3 |
| u2402__p                              |      4 |
| u2745_analysis                        |      1 |
| u2815__                               |      4 |
| u2815__p                              |     40 |
| u2815__piwik                          |     31 |
| u2815__test                           |      3 |
| u2815__toolserver_s4b                 |      1 |
| u2843__tmp                            |      1 |
| u3182__wp10_p                         |      1 |
| u3214_testdb                          |      1 |
| u3290__2012categories                 |      1 |
| u3290__2013categories                 |      1 |
| u3356__                               |      3 |
| u3532__                               |     46 |
| u3533_edit_req_db                     |      1 |
| u3533_g13_database                    |      2 |
| u3533_onlyuser                        |      1 |
| u3570_test                            |      2 |
| u3617__tmp                            |      9 |
| u3945__staeiou                        |      3 |
| u3949__tmp                            |      2 |
| u4301_robertb                         |      2 |
| u4817__afcresearch                    |     35 |
| u4974__ores_tmp_p                     |      1 |
+---------------------------------------+--------+
109 rows in set (1.08 sec)

-- labsdb1003.eqiad.wmnet

+---------------------------------------+--------+
| table_schema                          | tables |
+---------------------------------------+--------+
| p50380g50491_common                   |      1 |
| p50380g50491__rlrl_cawiki_p           |     22 |
| p50380g50491__rlrl_frwiki_p           |     23 |
| p50380g50491__rlrl_lvwiki_p           |     22 |
| p50380g50491__unlikely_lvwiki_p       |      5 |
| p50380g50497__wikidb_arwiki           |     57 |
| p50380g50497__wikidb_mediawikiwiki    |     49 |
| p50380g50497__wikidb_testwikidatawiki |     49 |
| p50380g50497__wikidb_wikidatawiki     |     57 |
| p50380g50497__wikidb_zhwikisource     |     49 |
| p50380g50552__inflections             |      3 |
| p50380g50553__ilc                     |      6 |
| p50380g50553__ilc_s7                  |      2 |
| p50380g50692__DPL_p                   |      7 |
| p50380g50729__grantsbot               |      9 |
| p50380g50769__wvs2                    |     35 |
| p50380g50769__wvs2ds                  |      4 |
| p50380g50921__ghel_p                  |     70 |
| p50380g50921__ghel_p_s3               |     54 |
| p50380g50921__ghel_p_s7               |      5 |
| p50380g50921__wma_p                   |      3 |
| p50380g50921__wma_p_s3                |      3 |
| p50380g50921__wma_p_s7                |      3 |
| s51072__dwl_p                         |      5 |
| s51111__common_p                      |      1 |
| s51111__rlrl_cawiki_p                 |     22 |
| s51111__rlrl_frwiki_p                 |     22 |
| s51111__rlrl_lvwiki_p                 |     22 |
| s51111__unlikely_lvwiki_p             |      5 |
| s51117__wikidb_dawiki                 |     49 |
| s51117__wikidb_eswiki                 |     49 |
| s51117__wikidb_frwiki                 |     49 |
| s51117__wikidb_jawiki                 |     49 |
| s51117__wikidb_kowiki                 |     49 |
| s51117__wikidb_ruwiki                 |     49 |
| s51117__wikidb_zh_yuewiki             |     49 |
| s51172__tasks                         |      1 |
| s51187__xtools_tmp                    |    662 |
| s51187__xtools_tmp_s3                 |     10 |
| s51187__xtools_tmp_s7                 |     16 |
| s51206__pt                            |      2 |
| s51362__erwin85                       |     62 |
| s51362__erwin85_s3                    |     22 |
| s51362__erwin85_s7                    |      2 |
| s51392__coord                         |      1 |
| s51430__bswiki_first_page_revisions_p |      1 |
| s51447__cawiki                        |      2 |
| s51580__hroest                        |      4 |
| s51837__MerlBot                       |      1 |
| s51892_toolserverdb                   |      5 |
| s51892_toolserverdb_p                 |      6 |
| s51892_toolserverdb_p_s3              |      6 |
| s51892_toolserverdb_p_s7              |      6 |
| s51892_toolserverdb_s3                |      5 |
| s51892_toolserverdb_s7                |      5 |
| s52107_lime                           |     34 |
| s52107_tools                          |      1 |
| s52524__rwtest                        |      1 |
| s52690__p                             |      1 |
| s52861__bwAPI_p                       |      1 |
| s52861__fnbot                         |      3 |
| s52861__request                       |     13 |
| s52861__secWatch                      |      7 |
| s52861__thanks_de                     |      1 |
| s52957__wdcat                         |      3 |
| s53012__fikarummet_p                  |      1 |
| s53311__wikidata                      |      3 |
| u2170__meta_p                         |      2 |
| u2718__bswiki_first_page_revisions_p  |      1 |
| u2815__                               |      2 |
| u2815__p                              |     87 |
| u3617__tmp                            |      1 |
| u3710__stats                          |     33 |
| u3949__tmp                            |      2 |
| u4529_srwiki                          |     20 |
+---------------------------------------+--------+