How to find Size of a Table in Netezza ?

The below query you can use to find the size of a table in Netezza.

SELECT 
A.DATABASE AS DATABASENAME
,LOWER(A.OBJNAME) AS TABLE_NAME
,A.OBJTYPE AS OBJECT_TYPE
,B.USED_BYTES/POW(1024,3) AS USED_SPACE_IN_GB
FROM _V_OBJ_RELATION_XDB A INNER JOIN
_V_SYS_OBJECT_STORAGE_SIZE B
ON    A.OBJID=B.TBLID
AND UPPER(A.OBJNAME) ='TABLE_NAME'
WHERE DATABASENAME='DATABASE_NAME'  AND OBJECT_TYPE='TABLE' ;