Top 10 Re-fetches in Depot

Best Answer

• Options

  Jim_Knicely - Select Field - Administrator

  November 2021 Answer ✓

  Should be this one:

  SELECT COUNT(*) AS refetches,
         pr.projection_schema AS table_schema,
         pr.anchor_table_name AS table_name
    FROM v_internal.dc_depot_fetches f
    JOIN storage_containers s 
      ON s.sal_storage_id = f.storageid
    JOIN projections pr
      ON pr.projection_id = s.projection_id
   WHERE time > to_timestamp_tz({from_time}) AND time <= to_timestamp_tz({to_time})
   GROUP BY 2,3
  HAVING COUNT(*) > 1
   ORDER BY refetches, pr.projection_schema, pr.anchor_table_name DESC
   LIMIT 10;
  

  0