Get the temp table logs from Vertica for Navigator Optimizer

temp_table_logs.sql

/* Temp table logs */
SELECT anchor_table_schema || '.' || anchor_table_name as TABLE_NAME,
   projection_column_count as AVG_ROW_LEN,
   SUM(row_count) as NUM_ROWS, 
   CASE 
     WHEN row_count<=99999 THEN 'x-small'
     WHEN row_count<=999999 THEN 'small'    
     WHEN row_count<=99999999 THEN 'medium'         
     WHEN row_count<=999999999 THEN 'large'              
     WHEN row_count>999999999 THEN 'x-large'
   END as ROW_RANGE
FROM v_monitor.projection_storage 
GROUP BY anchor_table_schema, anchor_table_name, projection_column_count, row_count