_supabase Database Size Issue - 19GB Usage
When I run this query to check database sizes
SELECT
datname as database_name,
pg_size_pretty(pg_database_size(datname)) as size,
pg_database_size(datname) as size_bytes
FROM pg_database
ORDER BY pg_database_size(datname) DESC;
The _supabase system database is showing 19GB of usage, which seems unusually large.
1. What typically causes this database to grow so large?
2. Is there a way to safely clean up or reduce this size?
3. Are there any settings I should adjust to prevent this from happening again?
Any guidance would be greatly appreciated!
SELECT
datname as database_name,
pg_size_pretty(pg_database_size(datname)) as size,
pg_database_size(datname) as size_bytes
FROM pg_database
ORDER BY pg_database_size(datname) DESC;
The _supabase system database is showing 19GB of usage, which seems unusually large.
1. What typically causes this database to grow so large?
2. Is there a way to safely clean up or reduce this size?
3. Are there any settings I should adjust to prevent this from happening again?
Any guidance would be greatly appreciated!
