Row Counts per Table
Uses PostgreSQL statistics for all tables in the schema:
select relname as table_name, n_live_tup as rows from pg_stat_user_tables where schemaname = 'ores' order by n_live_tup desc;
| table_name | rows | |------------------+------| | images | 276 | | image_tags | 276 | | currency_images | 158 | | currencies | 158 | | permissions | 24 | | role_permissions | 21 | | roles | 6 | | feature_flags | 4 | | tags | 1 | | ip2country | 0 | | account_roles | 0 | | sessions | 0 | | accounts | 0 | | login_info | 0 |