New RelicでNGINXデータを検索してクエリする

-- View request rate over time
FROM Metric SELECT rate(sum(nginx.requests), 1 minute)
WHERE nginx.deployment.name = 'production-web-01'
TIMESERIES

-- Check connection states
FROM Metric SELECT latest(nginx.connections_current)
WHERE nginx.deployment.name = 'production-web-01'
FACET state

-- Analyze log patterns (if log forwarding enabled)
FROM Log SELECT count(*)
WHERE nginx.deployment.name = 'production-web-01'
FACET status SINCE 1 hour ago

-- NGINX spans by name
FROM Span SELECT count(*)
WHERE nginx.deployment.name = 'production-web-01'
FACET name
SINCE 1 hour ago

-- Distributed traces flowing through NGINX
-- Shows all services participating in traces that include NGINX
FROM Span SELECT uniques(service.name)
WHERE trace.id IN (
  SELECT uniques(trace.id) FROM Span
  WHERE nginx.deployment.name = 'production-web-01'
  SINCE 30 minutes ago LIMIT 10
)
SINCE 30 minutes ago

-- Service relationships involving NGINX
FROM Relationship SELECT *
WHERE source.entityName = 'server:production-web-01'
  OR target.entityName = 'server:production-web-01'
SINCE 1 day ago