Script to Find Used Encoding Types in Vertica

SELECT node_name,
       column_name,
       row_count,
       used_bytes,
       round(used_bytes ::FLOAT / row_count ::FLOAT, 3) AS bytes_per_row,
       encodings,
       compressions,
       ros_count,
       projection_name,
       anchor_table_name,
       sum(used_bytes) OVER(PARTITION BY node_name, projection_name) AS proj_bytes_used
  FROM column_storage
 WHERE anchor_table_name ilike 'table_name'
   AND ANCHOR_TABLE_SCHEMA ilike 'schema_name'
   AND node_name ilike 'node_name'
 ORDER BY node_name, column_name, projection_name;