Differences

This shows you the differences between two versions of the page.

--- data_volume [2021/06/01 08:52]
windsor_ai created
+++ — (current)
@@ Line 1: / Line 1: @@
-====== Reporting date range ======
-Depending on your [[https://www.windsor.ai/pricing/|Windsor.ai pricing]] tier you have a specific amount of rows included.
-To calculate your row consumption go to the [[https://charts.windsor.ai/w/sqllab|SQL Lab]] and get your overall row count with
-<code>
-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 ;
-</code>
-And divide the value which is returned by the number of months you have been subscribing to Windsor.ai

Knowledge Base