JDBC API › JDBC API の使用 › メトリック クエリ › メトリック クエリの例

メトリック クエリの例

select * from metric_data where agent='.*' and metric='.*Average Response.*' and timestamp between '01/01/01 00:00:00' and '07/01/01 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 '07/01/01 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 '07/01/01 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 '07/01/01 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 '07/01/01 00:00:00' sort by value d maxmatches=10