constants.ts

// Copyright The Perses Authors
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
//
// http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.

export const queryExample = `-- Time Series Query (must alias to 'time' and 'value')
-- Available macros: $__timeFrom, $__timeTo, $__interval, $__interval_ms
SELECT
  toStartOfInterval(timestamp, INTERVAL $__interval second) as time,
  avg(cpu_usage) as value
FROM system_metrics
WHERE timestamp BETWEEN '$__timeFrom' AND '$__timeTo'
GROUP BY time ORDER BY time

-- With labels (extra columns become labels)
SELECT
  toStartOfInterval(timestamp, INTERVAL $__interval second) as time,
  count(*) as value,
  service_name
FROM logs
WHERE timestamp BETWEEN '$__timeFrom' AND '$__timeTo'
GROUP BY time, service_name ORDER BY time`;