How to List Netezza Database High Volume Tables?

  • Post author:
  • Post last modified:February 26, 2018
  • Post category:Netezza
  • Reading time:2 mins read

You may have to query Netezza system tables or views to get information about system, for example, list Netezza database high volume tables.

These kind of information will help you to manage Netezza server and databases. As a server maintenance activity, you may have to regularly verify the Netezza database table size and identify the growing tables in server to minimize the performance degrade.

How to List Netezza Database High Volume Tables?

Below query provides the information of big or high volume tables of database available in the Netezza data warehouse appliance. This query is useful for the Netezza administrator who frequently verify the database and table size.

Below query provides details about tables with high volume of data or big tables available in Netezza data warehouse appliance. This query may come in handy when you are performing tuning of your Netezza server.

select objname as table_name,
 database as db_name,
 (allocated_bytes/1048576) as Table_size_in_MB
from _v_sys_relation_xdb sys,
 _v_sys_object_dslice_info ds
where ds.tblid = sys.objid
 and dsid in (1,2,3,4)
 and database <> 'SYSTEM'
--and Table_size_in_MB > 1000
order by
Table_size_in_MB desc,
table_name,
db_name,
dsid;

 TABLE_NAME | DB_NAME | TABLE_ALLO_SIZE_MB | TABLE_USED_SIZE_MB
------------------+----------+--------------------+--------------------
 ARRAY_T | TRAINING | 3 | 0
 EMPLOYEE | TRAINING | 3 | 0
 EMPLOYEE | TRAINING | 3 | 0
 INT_SAMPLE_SALES | TRAINING | 3 | 0
 INT_SAMPLE_SALES | TRAINING | 3 | 0
...

Read:

Tags: