TimescaleDB volume shows 4GB usage in the Railway dashboard, but Postgres reports only 401MB total
yoannarz
PROOP

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

$10 Bounty

1 Replies

Railway
BOT

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!


Loading...