Netezza Administration : Getting each Database size

Run query ! Just like MAGIC !

-

SELECT current_timestamp AS SAMPLE_TIME

       ,t. database AS DATABASE_NAME

       , round(nvl (SUM (d.used_bytes)/1024 /1024,0),2)      AS USED_MB

       , round(nvl (SUM (d.allocated_bytes)/1024 /1024,0),2) AS ALLOCATED_MB

      FROM _V_SYS_OBJECT_DSLICE_INFO d

INNER JOIN _V_OBJ_RELATION_XDB t

        ON t.objid = d.tblid

WHERE t.objid > 200000

  AND d.tblid > 200000

GROUP BY rollup (DATABASE_NAME)

ORDER BY DATABASE_NAME nulls last;

-

It will only shows database that is in use and ignore the one that is NULL basically.