DEV Community

Josua Schmid
Josua Schmid

Posted on • Updated on

Sum ActiveStorage::Blob byte_size

#rails #mssql #sql

You may think to sum up the size all ActiveStorage files, you could simply execute the following query:

ActiveStorage::Blob.sum(:byte_size)
Enter fullscreen mode Exit fullscreen mode

But this may produce numbers too large for the resulting column type:

ActiveRecord::RangeError (TinyTds::Error: Arithmetic overflow error converting expression to data type int.)
Enter fullscreen mode Exit fullscreen mode

The solution is to cast:

ActiveStorage::Blob.connection.exec_query(
  'SELECT SUM(CAST(byte_size AS BIGINT)) from active_storage_blobs'
).first
Enter fullscreen mode Exit fullscreen mode

Top comments (0)

Read next

bdavidxyz profile image

My honest opinion about Hatchbox

David Boureau -

riboulet profile image

Good Database Migration Practices for Your Ruby on Rails App using Strong Migrations

Thomas Riboulet -

cudilala profile image

All joins in PostgreSQL: Tutorial

Augustine Madu -

daviducolo profile image

Mastering Kredis in Ruby: Your Essential Guide

Davide Santangelo -