Find table size in IBM netezza sql database from Aginity toolkit on win 7

Question

I need to find the size of a table in an IBM netezza sql database from Aginity toolkit on win 7.

I used this

SELECT * FROM _V_TABLE where tablename = 'my_table_name' 

But there is no information about the size of the table.

I right-clicked the table name in Aginity, but nothing worked.

Any help would be greatly appreciated.

thanks

Answer 1

Try this request.

 select used_bytes/pow(1024,3) as used_gb, * from _v_table_storage_stat where tablename = 'my_table_name' 

Answer 2

In Aginy (v2.1.181.6948), right-click on your database. Select "Show table size." A new window will appear that will have the names of the tables, owner, created, highlighted bytes, used bytes, etc.