Hello,
sometimes I find select like the following in the apmsqlserverout.log, see lelow.
I got some data for the select in Squirrel.
Lutz
Appandage:
I test the select (see below) with Squirrel and got some data.
Before result.from: 2018-10-17T13:38:07.402Z
Before result.to: 2018-10-17T13:43:07.402Z
kSmartStorTimeZone: sun.util.calendar.ZoneInfo[id="Europe/Berlin",offset=3600000,dstSavings=3600000,useDaylight=true,transitions=143,lastRule=java.util.SimpleTimeZone[id=Europe/Berlin,offset=3600000,dstSavings=3600000,useDaylight=true,startYear=0,startMode=2,startMonth=2,startDay=-1,startDayOfWeek=1,startTime=3600000,startTimeMode=2,endMode=2,endMonth=9,endDay=-1,endDayOfWeek=1,endTime=3600000,endTimeMode=2]]
After result.from: 2018-10-17 15:38:07
After result.to: 2018-10-17 15:43:07
diffHours<1
Target has more than 1:false
rawCommand: apmsql 'APM.WebView' 'GC Heap|Bytes In Use' agg_value
select metric_path,year(ts) || '-' || month(ts) || '-' || dayofmonth(ts) || ' ' || hour(ts) || ':' || minute(ts) || ':' || second(ts) as theTime,
(timestampdiff(SQL_TSI_SECOND, FROM_UNIXTIME(0), PARSETIMESTAMP( year(ts) || '-' || month(ts) || '-' || dayofmonth(ts) || ' ' || hour(ts) || ':' || minute(ts) || ':' || second(ts) ,'yyyy-MM-dd hh:mm:ss')))*1000 as tstamp,
sum(value_count) as value_count,
avg(agg_value) as agg_value,
min(min_value) as min_value,
max(max_value) as max_value
from numerical_metric_data
where frequency=15000
and ts between '2018-10-17 15:34:00' and '2018-10-17 15:39:00'
and agent_name like_regex 'APM.WebView'
and metric_path like_regex 'GC Heap|Bytes In Use'
group by metric_path,year(ts),month(ts),dayofmonth(ts),hour(ts), minute(ts), second(ts)
order by metric_path
limit 2147483647