User Tools

Site Tools


data_volume

This is an old revision of the document!


Reporting date range

Depending on your Windsor.ai pricing tier you have a specific amount of rows included.

To calculate your row consumption go to the SQL Lab and get your overall row count with

select
       sum((xpath('/row/cnt/text()', xml_count))[1]::text::int) as row_count
from (
  select table_name, table_schema, 
         query_to_xml(format('select count(*) as cnt from %I.%I', table_schema, table_name), false, true, '') as xml_count
  from information_schema.tables
  where table_schema = 'public' --<< change here for the schema you want
) t ;

And divide the value which is returned by the number of months you have been subscribing to Windsor.ai

data_volume.1622533959.txt.gz ยท Last modified: 2021/06/01 08:52 by windsor_ai