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