New Relic

# DeepCost New Relic NRQL Queries

# Performance vs Cost Correlation
SELECT 
  average(duration) as avg_response_time,
  average(cpuPercent) as avg_cpu,
  average(memoryUsedBytes) as avg_memory,
  deepcost.hourly_cost as infrastructure_cost
FROM Transaction, SystemSample
WHERE appName = 'my-app'
FACET host
SINCE 1 day ago
TIMESERIES

# Application Cost Efficiency
SELECT 
  rate(count(*), 1 minute) as throughput,
  average(duration) as response_time,
  deepcost.cost_per_transaction as unit_cost
FROM Transaction
WHERE appName = 'my-app'
FACET name
SINCE 1 hour ago

# Resource Utilization vs Spend
SELECT 
  average(cpuPercent) as cpu_utilization,
  average(memoryUsedPercent) as memory_utilization,
  max(deepcost.hourly_rate) as max_hourly_cost,
  average(deepcost.hourly_rate) as avg_hourly_cost
FROM SystemSample
WHERE hostname LIKE 'web-server%'
FACET hostname
SINCE 6 hours ago
TIMESERIES 10 minutes

# Error Rate Impact on Costs
SELECT 
  percentage(count(*), WHERE error IS true) as error_rate,
  average(duration) as avg_duration,
  sum(deepcost.wasted_cost) as cost_waste
FROM Transaction
WHERE appName = 'checkout-service'
FACET name
SINCE 1 day ago
COMPARE WITH 1 week ago

# Database Query Optimization
SELECT 
  average(duration) as query_duration,
  rate(count(*), 1 minute) as queries_per_minute,
  sum(deepcost.database_cost) as db_cost
FROM DatabaseSample
WHERE vendor = 'MySQL'
FACET query
SINCE 1 hour ago
ORDER BY db_cost DESC
LIMIT 10