Sample Header Ad - 728x90

Size, audit and rowcount of a table in Vertica

1 vote
2 answers
3027 views
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