I’m observing that there is signficant difference between going through New Relic APM
APM->Transactions->Type “All Transactions”
And using Insights to
SELECT count(*) FROM Transaction since 3 days ago facet appName where appName like '%my list of aps here% 'TIMESERIES
I’m trying to have a high level number of transactions on the top of my dashboard, however feel for larger requests APM lists 300% more requests than Insights.
For example, insights list my number of transactions maxing at 1.2M and flatlining across the top. In contrast APM shows a more cyclical pattern.
I’m looking to always have the query available in all my dashboards so would perfer to use Insights so I could tune things - ie get P99 P95 etc.