I need to find a compressed size, an audit and a row count for each table in some schemes.
For a compressed size and a row count I tried to use
projection_storage
:
SELECT anchor_table_schema,
anchor_table_name,
SUM(used_bytes),
SUM(row_count)
FROM v_monitor.projection_storage
GROUP BY anchor_table_schema, anchor_table_name
But for empty table (0 rows) I got non-zero SUM(used_bytes) and SUM(row_count). So this way doesn't work properly.
And I calculate an audit by select audit('table_name')
for each table, but it's very slowly.
So my questions:
1. Is there other way to find compressed size (and maybe a row count) of a table? Because I got 80000000 bytes instead of zero.
2. Is there more faster way to calculate an audit? I know vertica calculates audits every day for each table, but I can't find where results is stored.
Asked by Vikora
(11 rep)
Mar 20, 2016, 03:49 PM
Last activity: May 10, 2020, 03:40 PM
Last activity: May 10, 2020, 03:40 PM