SELECT
      host,
      approx_percentile_cont(latency, 0.95) RANGE '15s' as p95_latency,
      count(error) RANGE '15s' as num_errors,
  FROM
      metrics INNER JOIN logs on metrics.host = logs.host
  WHERE
      time > now() - INTERVAL '1 hour' AND
      matches(path, '/api/v1/avator')
  ALIGN '5s' BY (host) FILL PREV