find the table size on IBM netezza sql database from Aginity workbench on win 7

sql database windows-7 netezza
user3601704 picture user3601704 · Nov 5, 2014 · Viewed 15.7k times · Source

I need to find a table size on IBM netezza sql database from Aginity workbench on win 7.

I used this 

 SELECT  * FROM _V_TABLE
 where tablename = 'my_table_name'

But, no information about table size.

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

Any help would be appreciated.

thanks

Answer

Niederee picture Niederee · Nov 6, 2014

Try this query.

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

Related questions

Insert into ... values ( SELECT ... FROM ... )

I am trying to INSERT INTO a table using the input from another table. Although this is entirely feasible for many database engines, I always seem to struggle to remember the correct syntax for the SQL engine of the day (…

Read More
What is the difference between "INNER JOIN" and "OUTER JOIN"?

Also how do LEFT JOIN, RIGHT JOIN and FULL JOIN fit in?

Read More
'IF' in 'SELECT' statement - choose output value based on column values

SELECT id, amount FROM report I need amount to be amount if report.type='P' and -amount if report.type='N'. How do I add this to the above query?

Read More