2

From MonetDB docs https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/storage-model,

The storage footprint for any given database schema
can be obtained by inspecting the table producing 
function storage()

Here's a sample query from the documentation:

select * from storage() where "table" = 'lineitem';

But when I try a similar query, I get below error:

SELECT: no such operator 'storage'

What am I missing?

Sahas
  • 10,637
  • 9
  • 41
  • 51

1 Answers1

4

Prefixing the storage() function call with the "sys" schema may solve your issue. Ex :

select * from sys.storage() where "table" = 'lineitem';

Nicolas Riousset
  • 3,447
  • 1
  • 22
  • 25