Skip to main content
Database Administrators

Return to Answer

Fix calculation of gigabytes
Source Link
edit approved May 10, 2020 at 15:40
Yair Halberstadt
edit approved May 10, 2020 at 15:40
Yair Halberstadt
  • 145
  • 8

Using below query, you will get the size of Vertica tables.

SELECT anchor_table_schema,
anchor_table_name,
SUM(used_bytes) / (1024/1024/ * 1024/ * 1024) AS TABLE_SIZE_GB
FROM   v_monitor.projection_storage
GROUP  BY anchor_table_schema,
anchor_table_name
order  by sum(used_bytes) desc;

Check out the most important queries to check table size

https://www.orahow.com/2018/06/how-to-check-size-of-tables-in-vertica.html

Using below query, you will get the size of Vertica tables.

SELECT anchor_table_schema,
anchor_table_name,
SUM(used_bytes) / (1024/1024/1024/1024) AS TABLE_SIZE_GB
FROM   v_monitor.projection_storage
GROUP  BY anchor_table_schema,
anchor_table_name
order  by sum(used_bytes) desc;

Check out the most important queries to check table size

https://www.orahow.com/2018/06/how-to-check-size-of-tables-in-vertica.html

Using below query, you will get the size of Vertica tables.

SELECT anchor_table_schema,
anchor_table_name,
SUM(used_bytes) / (1024 * 1024 * 1024) AS TABLE_SIZE_GB
FROM   v_monitor.projection_storage
GROUP  BY anchor_table_schema,
anchor_table_name
order  by sum(used_bytes) desc;

Check out the most important queries to check table size

https://www.orahow.com/2018/06/how-to-check-size-of-tables-in-vertica.html

added 23 characters in body
Source Link
mustaccio
mustaccio
  • 26.9k
  • 24
  • 58
  • 74

Using below query, you will get the size of verticaVertica tables.

SELECT anchor_table_schema, anchor_table_name, SUM(used_bytes) / (1024/1024/1024/1024) AS TABLE_SIZE_GB FROM v_monitor.projection_storage GROUP BY anchor_table_schema, anchor_table_name order by sum(used_bytes) desc;

SELECT anchor_table_schema,
anchor_table_name,
SUM(used_bytes) / (1024/1024/1024/1024) AS TABLE_SIZE_GB
FROM   v_monitor.projection_storage
GROUP  BY anchor_table_schema,
anchor_table_name
order  by sum(used_bytes) desc;

Check out the most important queries to check table size

https://www.orahow.com/2018/06/how-to-check-size-of-tables-in-vertica.html

Using below query, you will get the size of vertica tables.

SELECT anchor_table_schema, anchor_table_name, SUM(used_bytes) / (1024/1024/1024/1024) AS TABLE_SIZE_GB FROM v_monitor.projection_storage GROUP BY anchor_table_schema, anchor_table_name order by sum(used_bytes) desc;

Check out the most important queries to check table size

https://www.orahow.com/2018/06/how-to-check-size-of-tables-in-vertica.html

Using below query, you will get the size of Vertica tables.

SELECT anchor_table_schema,
anchor_table_name,
SUM(used_bytes) / (1024/1024/1024/1024) AS TABLE_SIZE_GB
FROM   v_monitor.projection_storage
GROUP  BY anchor_table_schema,
anchor_table_name
order  by sum(used_bytes) desc;

Check out the most important queries to check table size

https://www.orahow.com/2018/06/how-to-check-size-of-tables-in-vertica.html

Source Link
santosh tiwary
santosh tiwary
  • 191
  • 3

Using below query, you will get the size of vertica tables.

SELECT anchor_table_schema, anchor_table_name, SUM(used_bytes) / (1024/1024/1024/1024) AS TABLE_SIZE_GB FROM v_monitor.projection_storage GROUP BY anchor_table_schema, anchor_table_name order by sum(used_bytes) desc;

Check out the most important queries to check table size

https://www.orahow.com/2018/06/how-to-check-size-of-tables-in-vertica.html