mysql> select count(*) from uuid_registry; +----------+ | count(*) | +----------+ | 362450 | +----------+ 1 row in set (0.02 sec) mysql> select count(*) from uuid_registry; +----------+ | count(*) | +----------+ | 362611 | +----------+ 1 row in set (0.03 sec) mysql> select count(*) lists; +-------+ | lists | +-------+ | 1 | +-------+ 1 row in set (0.00 sec) mysql> select distinct table_name from uuid_registry; +----------------+ | table_name | +----------------+ | patient_data | | form_encounter | | users | | facility | | immunizations | | lists | +----------------+ 6 rows in set (0.35 sec) mysql> select count(*) from lists; +----------+ | count(*) | +----------+ | 35093 | +----------+ 1 row in set (0.01 sec) mysql> select count(*) from uuid_registry; +----------+ | count(*) | +----------+ | 363696 | +----------+ 1 row in set (0.02 sec) mysql> select count(*) from uuid_registry; +----------+ | count(*) | +----------+ | 367200 | +----------+ 1 row in set (0.02 sec) mysql> select count(*) from documents; +----------+ | count(*) | +----------+ | 27519 | +----------+ 1 row in set (0.48 sec) mysql> select distinct table_name from uuid_registry; +----------------+ | table_name | +----------------+ | patient_data | | form_encounter | | users | | facility | | immunizations | | lists | +----------------+ 6 rows in set (0.20 sec) mysql> select count(table_name) from uuid_registry where table_name = 'lists'; +-------------------+ | count(table_name) | +-------------------+ | 35094 | +-------------------+ 1 row in set (0.08 sec) mysql> select count(*) from lists; +----------+ | count(*) | +----------+ | 35093 | +----------+ 1 row in set (0.01 sec) mysql> select distinct table_name from uuid_registry; +----------------+ | table_name | +----------------+ | patient_data | | form_encounter | | users | | facility | | immunizations | | lists | +----------------+ 6 rows in set (0.20 sec) mysql> select count(table_name) from uuid_registry where table_name = 'lists'; +-------------------+ | count(table_name) | +-------------------+ | 35094 | +-------------------+ 1 row in set (0.10 sec) mysql> select count(*) from uuid_registry; +----------+ | count(*) | +----------+ | 367425 | +----------+ 1 row in set (0.03 sec)