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 |

Emacs 29.3 (Org mode 9.6.15)