we have a server that has multiple pools for php-fpm. we would like to visualise the occupation op those pools over time. I have enabled process metrics, so I can do a query like :
SELECT count(commandLine) FROM ProcessSample FACET commandLine WHERE commandLine like 'php-fpm: pool %'
and that kinda works, but gives me an aggregate count over a lot of processSamples. If I limit the query to a 20 second interval, I can get the counts from one sample, it seems, but I have no idea how to get a time series from that.
does anybody have an idea ?