curl -sS 'https://matrix.example.com/_synapse/admin/v1/statistics/database/rooms' -H "Authorization: Bearer $ACCESS_TOKEN"

Category: Matrix & Synapse

curl -sS 'https://matrix.example.com/_synapse/admin/v1/statistics/database/rooms' -H "Authorization: Bearer $ACCESS_TOKEN"

Find the largest rooms in the database

Returns the ten rooms estimated to occupy the most database space, based on PostgreSQL planner statistics, so the numbers are approximate. Media is not included in the estimates. Use the results to decide which rooms deserve a history purge. Returns an error on SQLite, which has no planner data.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.