New Relic's Integration SDK imposes a limit of 1000 metrics per ingestion.To handle metric sets exceeding this limit, we process and ingest metrics in smaller chunks to ensure all data is successfully reported without exceeding the limit.

ExecutionPlanQuery holds the SQL query for fetching execution plans.

GroupedQueryCountMax specifies the maximum number of grouped queries that is ingested in an analysis cycle/interval.

IndividualQueryCountMax represents the maximum number of individual queries that is ingested at one time for any grouped query in detailed analysis.

MaxSystemDatabaseID indicates the highest database ID value considered a system database, used to filter out system databases from certain operations.

QueryResponseTimeThresholdDefault defines the default threshold in milliseconds for determining if a query is considered slow based on its response time.

SlowQueryCountThresholdDefault sets the default maximum number of slow queries that is ingested in an analysis cycle/interval.

We need to use this limit of long strings that we are injesting because the logs datastore in New Relic limits the field length to 4,094 characters.

Documentation: https:https://newrelic.atlassian.net/wiki/x/SYFq6g The above link contains all the queries, data models, and query details for QueryAnalysis.