JDBC API › 使用 JDBC API › 度量标准查询 › 度量标准查询示例

度量标准查询示例

select * from metric_data where agent='.*' and metric='.*Average Response.*' and timestamp between '01/01/01 00:00:00' and '01/01/07 00:00:00' maxmatches=10

select * from metric_data where agent='.*' and metric='.*Average Response.*' and timestamp between '01/01/01 00:00:00' and '01/01/07 00:00:00' maxmatches=1

select * from metric_data where agent='.*' and metric='.*Average Response.*' and timestamp between '01/01/01 00:00:00' and '01/01/07 00:00:00' maxmatches=1 period=120

// match one metric_data and aggregate all values. This returns one row of data select * from metrics where agent='.*' and metric='.*Average Response.*' and timestamp between '01/01/01 00:00:00' and '01/01/07 00:00:00' maxmatches=1 aggregateall

// this is a top 10 query select * from metric_data where agent='.*' and metric='.*Average Response.*' and timestamp between '01/01/01 00:00:00' and '01/01/07 00:00:00' sort by value d maxmatches=10