The Vertica Database Forums

Code: Select all

select audit('public', 'table');

Code: Select all

SELECT *, RawSize / CompressedSize AS Ratio
FROM (
    SELECT audit_start_timestamp,
        anchor_table_name,
        size_bytes AS RawSize,
        CAST(SUM(ros_used_bytes) AS DECIMAL(14, 2)) AS CompressedSize
    FROM projection_storage ps
    INNER JOIN user_audits ua ON ps.projection_schema = ua.object_schema
        AND ps.anchor_table_name = ua.object_name
    WHERE audit_start_timestamp > now() - 1
    GROUP BY 1, 2, 3
    ) A
ORDER BY audit_start_timestamp, anchor_table_name;