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 |
+---------------------------------------+--------+