a month ago
Hello,
My TimescaleDB volume shows 4GB usage in the Railway dashboard, but Postgres reports only 401MB total. There's a discrepancy of ~3.6GB that I cannot account for.
Here are the metrics from within Postgres:
DATABASE SIZE:
- Database: 113 MB
- WAL logs: 288 MB
- Total visible from Postgres: 401 MB
TOP 10 TABLES BY SIZE:
1. compress_hyper_6_4_chunk: 100 MB
2. option_spreads: 1.6 MB
3. fetch_jobs: 112 KB
4. options_snapshots: 80 KB
(All other tables < 100 KB)
TIMESCALEDB INFO:
- 1 hypertable: options_snapshots (compressed, 1 chunk)
- Total tablespace size: 138 MB
QUESTION:
Where are the remaining ~3.6GB located? Is this:
1. Provisioned disk space vs actual usage?
2. TimescaleDB internal files not visible from SQL?
3. System backups/snapshots?
4. Old WAL segments or temp files?
Can you help identify what's consuming the disk space?
Thanks!
Attachments
1 Replies
a month ago
Hey there! We've found the following might help you get unblocked faster:
If you find the answer from one of these, please let us know by solving the thread!