analyze_transactions
Analyze transaction performance to identify slow requests, high-error endpoints, and traffic patterns using NRQL queries with grouping by attributes like name or host.
Instructions
Analyze transaction performance using NRQL with FACET grouping. Query the Transaction event type to analyze web requests, API calls, and background jobs. Group by transaction name, host, or other attributes. Calculate metrics like count, average duration, error rate, and throughput. Useful for identifying slow transactions, high-error endpoints, or traffic patterns.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| since | No | Time range start (NRQL SINCE clause). Examples: '1 hour ago', '24 hours ago', '7 days ago', '2024-01-01' | 1 hour ago |
| until | No | Time range end (NRQL UNTIL clause). Examples: 'now', '1 hour ago', '2024-01-02' | |
| facets | No | Fields to group results by. Default: ['name']. Common: 'name', 'host', 'request.uri' | |
| appName | No | Filter by application name | |
| where | No | Additional WHERE clause conditions. Example: "duration > 1" or "error IS true" | |
| metrics | No | Metrics to calculate. Options: count, averageDuration, totalTime, errorRate, throughput | |
| limit | No | Maximum number of results (1-1000, default: 100) | |
| accountId | No | NewRelic account ID (defaults to configured account) |