-- Counts for the data table on the Status page. Run on production:
--   docker exec -i supabase-db psql -U supabase_admin -d postgres < status-counts.sql
\pset format unaligned
set max_parallel_workers_per_gather = 0;
select 'entries', count(*) from lex.entries;
select 'entries_by_lang', lang, count(*) from lex.entries group by lang order by lang;
select 'senses', count(*) from lex.senses;
select 'en_senses_vi', count(*) filter (where s.gloss_vi is not null), count(*) from lex.senses s join lex.entries e on e.id = s.entry_id where e.lang = 'en';
select 'examples', count(*) from lex.examples;
select 'audio', count(*) from lex.pronunciations where audio_url is not null;
select 'relations', count(*), count(related_entry_id) from lex.lex_relations;
select 'family', count(*), count(distinct entry_id) from lex.lex_relations where relation_type = 'family';
select 'ranked', count(*) from lex.lex_relations where rank is not null;
select 'phrase_ipa', count(*), count(distinct entry_id) from lex.pronunciations where source_id = 'zhesen-phrase-ipa';
select 'inflections', count(*) from lex.inflections;
select 'gloss_terms', count(*) from lex.gloss_terms;
select 'db_size', pg_size_pretty(pg_database_size('postgres'));