DX NetOps

How can I see the saved history and its size of the database?

HI Joan:

I assume you mean the vertica database.  Here are a few different methods to list backups:

Run the following command:

 /opt/vertica/bin/vbr.py --task listbackup --config-file /export/dradmin/fullbackup.ini

Run the following query in vsql:

select * from v_monitor.database_backups;

For database size you might run the following query:

drdata=> select storage_path, storage_usage, disk_space_used_mb, disk_space_used_mb / 1024 "disk_space_used_mb (GB)" from disk_storage where node_name = 'v_drdata_node0001';
storage_path | storage_usage | disk_space_used_mb | disk_space_used_mb (GB)
------------------------------------------------------------+---------------+--------------------+-------------------------
/loddisk2/catalog/drdata/v_drdata_node0001_catalog/Catalog | CATALOG | 6832 | 6.671875000000000000
/loddisk2/data/drdata/v_drdata_node0001_data | DATA,TEMP | 6832 | 6.671875000000000000
(2 rows)

HTH:

Joe