Database Statistics
Overview of database storage, table records, and system usage.
Total Size
10 GB
Used by current database
Total Tables
43
Active tables in schema
Materialized Views
4
Cached query views
Largest Tables
Tables consuming the most storage space
| Table Name | Rows | Total Size |
|---|---|---|
| villages_2025_12 | 7,811,902 | 7992 MB |
| villages_2025_11 | 455,602 | 452 MB |
| import_logs | 947 | 320 kB |
| villages_2026_12 | -1 | 152 kB |
| villages_2024_03 | -1 | 152 kB |
Materialized Views
Cached views for performance optimization
| View Name | Size | Status |
|---|---|---|
| village_rankings | 1541 MB | Active |
| player_rankings | 406 MB | Active |
| alliance_rankings | 21 MB | Active |
| server_stats | 192 kB | Active |
All Tables
Detailed statistics for all database tables
| Table Name | Rows | Total Size | Index Size |
|---|---|---|---|
| villages_2025_12 | 7,811,902 | 7992 MB | 6768 MB |
| villages_2025_11 | 455,602 | 452 MB | 389 MB |
| import_logs | 947 | 320 kB | 136 kB |
| villages_2026_12 | -1 | 152 kB | 144 kB |
| villages_2024_03 | -1 | 152 kB | 144 kB |
| villages_2024_04 | -1 | 152 kB | 144 kB |
| villages_2024_01 | -1 | 152 kB | 144 kB |
| villages_2025_10 | -1 | 152 kB | 144 kB |
| villages_2026_10 | -1 | 152 kB | 144 kB |
| villages_2026_11 | -1 | 152 kB | 144 kB |
| villages_2024_02 | -1 | 152 kB | 144 kB |
| villages_2024_09 | -1 | 152 kB | 144 kB |
| villages_2024_10 | -1 | 152 kB | 144 kB |
| villages_2024_11 | -1 | 152 kB | 144 kB |
| villages_2024_05 | -1 | 152 kB | 144 kB |
| villages_2024_06 | -1 | 152 kB | 144 kB |
| villages_2024_12 | -1 | 152 kB | 144 kB |
| villages_2025_01 | -1 | 152 kB | 144 kB |
| villages_2024_07 | -1 | 152 kB | 144 kB |
| villages_2025_02 | -1 | 152 kB | 144 kB |
| villages_2024_08 | -1 | 152 kB | 144 kB |
| villages_2025_04 | -1 | 152 kB | 144 kB |
| villages_2025_05 | -1 | 152 kB | 144 kB |
| villages_2025_06 | -1 | 152 kB | 144 kB |
| villages_2025_03 | -1 | 152 kB | 144 kB |
| villages_2025_07 | -1 | 152 kB | 144 kB |
| villages_2025_08 | -1 | 152 kB | 144 kB |
| villages_2025_09 | -1 | 152 kB | 144 kB |
| villages_default | -1 | 152 kB | 144 kB |
| villages_2026_01 | -1 | 152 kB | 144 kB |
| villages_2026_02 | -1 | 152 kB | 144 kB |
| villages_2026_03 | -1 | 152 kB | 144 kB |
| villages_2026_04 | -1 | 152 kB | 144 kB |
| villages_2026_05 | -1 | 152 kB | 144 kB |
| villages_2026_06 | -1 | 152 kB | 144 kB |
| villages_2026_07 | -1 | 152 kB | 144 kB |
| villages_2026_08 | -1 | 152 kB | 144 kB |
| villages_2026_09 | -1 | 152 kB | 144 kB |
| servers | 97 | 136 kB | 80 kB |
| server_sync_logs | -1 | 48 kB | 32 kB |
| kysely_migration | -1 | 32 kB | 16 kB |
| kysely_migration_lock | -1 | 24 kB | 16 kB |
| villages_old | -1 | 24 kB | 16 kB |