Manage Storage size usage

What you are charged for#

You are charged for the total size of all assets in your buckets.

How charges are calculated#

Storage size is charged by Gigabyte-Hours (GB-Hrs). 1 GB-Hr represents the use of 1 GB of storage for 1 hour. For example, storing 10 GB of data for 5 hours results in 50 GB-Hrs (10 GB × 5 hours).

Usage on your invoice#

Usage is shown as "Storage Size GB-Hrs" on your invoice.

Pricing#

$0.00002919 per GB-Hr ($0.021 per GB per month). You are only charged for usage exceeding your subscription plan's quota.

Billing examples#

Within quota#

The organization's Storage size usage is within the quota, so no charges for Storage size apply.

Exceeding quota#

The organization's Storage size usage exceeds the quota by 257 GB, incurring charges for this additional usage.

View usage#

Usage page#

You can view Storage size usage on the organization's usage page. The page shows the usage of all projects by default. To view the usage for a specific project, select it from the dropdown. You can also select a different time period.

In the Storage size section, you can see how much storage your projects have used during the selected time period.

SQL Editor#

Since we designed Storage to work as an integrated part of your Postgres database on Supabase, you can query information about your Storage objects in the storage schema.

List files larger than 5 MB:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
select    name,    bucket_id as bucket,    case        when (metadata->>'size')::int >= 1073741824 then            ((metadata->>'size')::int / 1073741824.0)::numeric(10, 2) || ' GB'        when (metadata->>'size')::int >= 1048576 then            ((metadata->>'size')::int / 1048576.0)::numeric(10, 2) || ' MB'        when (metadata->>'size')::int >= 1024 then            ((metadata->>'size')::int / 1024.0)::numeric(10, 2) || ' KB'        else            (metadata->>'size')::int || ' bytes'        end as sizefrom    storage.objectswhere    (metadata->>'size')::int > 1048576 * 5order by (metadata->>'size')::int desc

List buckets with their total size:

1
2
3
4
5
6
7
8
9
select    bucket_id,    (sum((metadata->>'size')::int) / 1048576.0)::numeric(10, 2) as total_size_megabytefrom    storage.objectsgroup by    bucket_idorder by    total_size_megabyte desc;

Optimize usage#

• Limit the upload size for your buckets
• Delete assets that are no longer in use