/// <summary>
/// Gets a human readable plain text of the QueryMetrics (Please use monospace font).
/// </summary>
/// <param name="indentLevel">The level of nesting / indenting of this object.</param>
/// <returns>A human readable plain text of the QueryMetrics.</returns>
internal string ToTextString(int indentLevel = 0)
{
if (indentLevel == int.MaxValue)
{
throw new ArgumentOutOfRangeException("indentLevel", "input must be less than Int32.MaxValue");
}
StringBuilder stringBuilder = new StringBuilder();
checked
{
// Top level properties
QueryMetricsUtils.AppendCountToStringBuilder(
stringBuilder,
QueryMetricsConstants.RetrievedDocumentCountText,
this.RetrievedDocumentCount,
indentLevel);
QueryMetricsUtils.AppendBytesToStringBuilder(
stringBuilder,
QueryMetricsConstants.RetrievedDocumentSizeText,
this.RetrievedDocumentSize,
indentLevel);
QueryMetricsUtils.AppendCountToStringBuilder(
stringBuilder,
QueryMetricsConstants.OutputDocumentCountText,
this.OutputDocumentCount,
indentLevel);
QueryMetricsUtils.AppendBytesToStringBuilder(
stringBuilder,
QueryMetricsConstants.OutputDocumentSizeText,
this.OutputDocumentSize,
indentLevel);
QueryMetricsUtils.AppendPercentageToStringBuilder(
stringBuilder,
QueryMetricsConstants.IndexUtilizationText,
this.IndexHitRatio,
indentLevel);
QueryMetricsUtils.AppendMillisecondsToStringBuilder(
stringBuilder,
QueryMetricsConstants.TotalQueryExecutionTimeText,
this.TotalQueryExecutionTime.TotalMilliseconds,
indentLevel);
// QueryPreparationTimes
stringBuilder.Append(this.QueryPreparationTimes.ToTextString(indentLevel + 1));
QueryMetricsUtils.AppendMillisecondsToStringBuilder(
stringBuilder,
QueryMetricsConstants.IndexLookupTimeText,
this.IndexLookupTime.TotalMilliseconds,
indentLevel + 1);
QueryMetricsUtils.AppendMillisecondsToStringBuilder(
stringBuilder,
QueryMetricsConstants.DocumentLoadTimeText,
this.DocumentLoadTime.TotalMilliseconds,
indentLevel + 1);
// VM Execution Time is not emitted since the user does not have any context
// RuntimesExecutionTimes
stringBuilder.Append(this.RuntimeExecutionTimes.ToTextString(indentLevel + 1));
QueryMetricsUtils.AppendMillisecondsToStringBuilder(
stringBuilder,
QueryMetricsConstants.WriteOutputTimeText,
this.DocumentWriteTime.TotalMilliseconds,
indentLevel + 1);
// Client Side Metrics
stringBuilder.Append(this.ClientSideMetrics.ToTextString(indentLevel + 1));
// Activity Ids
QueryMetricsUtils.AppendActivityIdsToStringBuilder(stringBuilder, QueryMetricsConstants.ActivityIds, this.ActivityIds, indentLevel);
}
return(stringBuilder.ToString());
}
/// <summary>
/// Gets a human readable plain text of the ClientSideMetrics (Please use monospace font).
/// </summary>
/// <param name="indentLevel">The indent / nesting level of the ClientSideMetrics.</param>
/// <returns>A human readable plain text of the ClientSideMetrics.</returns>
public string ToTextString(int indentLevel = 0)
{
if (indentLevel == int.MaxValue)
{
throw new ArgumentOutOfRangeException("indentLevel", "input must be less than Int32.MaxValue");
}
StringBuilder stringBuilder = new StringBuilder();
checked
{
// Properties
QueryMetricsUtils.AppendHeaderToStringBuilder(
stringBuilder,
QueryMetricsConstants.ClientSideQueryMetricsText,
indentLevel);
QueryMetricsUtils.AppendCountToStringBuilder(
stringBuilder,
QueryMetricsConstants.RetriesText,
this.Retries,
indentLevel + 1);
QueryMetricsUtils.AppendRUToStringBuilder(
stringBuilder,
QueryMetricsConstants.RequestChargeText,
this.RequestCharge,
indentLevel + 1);
QueryMetricsUtils.AppendNewlineToStringBuilder(stringBuilder);
// Building the table for fetch execution ranges
QueryMetricsUtils.AppendHeaderToStringBuilder(stringBuilder, QueryMetricsConstants.FetchExecutionRangesText, 1);
QueryMetricsUtils.AppendHeaderToStringBuilder(stringBuilder, PartitionExecutionTimelineTable.TopLine, 1);
QueryMetricsUtils.AppendHeaderToStringBuilder(stringBuilder, PartitionExecutionTimelineTable.Header, 1);
QueryMetricsUtils.AppendHeaderToStringBuilder(stringBuilder, PartitionExecutionTimelineTable.MiddleLine, 1);
foreach (FetchExecutionRange fetchExecutionRange in this.FetchExecutionRanges.OrderBy(fetchExecutionRange => fetchExecutionRange.StartTime))
{
QueryMetricsUtils.AppendHeaderToStringBuilder(
stringBuilder,
PartitionExecutionTimelineTable.GetRow(
fetchExecutionRange.PartitionId,
fetchExecutionRange.StartTime.ToUniversalTime().ToString("hh:mm:ss.ffffff"),
fetchExecutionRange.EndTime.ToUniversalTime().ToString("hh:mm:ss.ffffff"),
(fetchExecutionRange.EndTime - fetchExecutionRange.StartTime).TotalMilliseconds.ToString("0.00"),
fetchExecutionRange.NumberOfDocuments,
fetchExecutionRange.RetryCount),
1);
}
QueryMetricsUtils.AppendHeaderToStringBuilder(stringBuilder, PartitionExecutionTimelineTable.BottomLine, 1);
QueryMetricsUtils.AppendNewlineToStringBuilder(stringBuilder);
// Building the table for scheduling metrics
QueryMetricsUtils.AppendHeaderToStringBuilder(stringBuilder, QueryMetricsConstants.SchedulingMetricsText, 1);
QueryMetricsUtils.AppendHeaderToStringBuilder(stringBuilder, SchedulingMetricsTable.TopLine, 1);
QueryMetricsUtils.AppendHeaderToStringBuilder(stringBuilder, SchedulingMetricsTable.Header, 1);
QueryMetricsUtils.AppendHeaderToStringBuilder(stringBuilder, SchedulingMetricsTable.MiddleLine, 1);
foreach (Tuple <string, SchedulingTimeSpan> partitionSchedulingTimeSpan in this.PartitionSchedulingTimeSpans.OrderBy(x => x.Item2.ResponseTime))
{
string partitionId = partitionSchedulingTimeSpan.Item1;
SchedulingTimeSpan schedulingTimeSpan = partitionSchedulingTimeSpan.Item2;
QueryMetricsUtils.AppendHeaderToStringBuilder(
stringBuilder,
SchedulingMetricsTable.GetRow(
partitionId,
schedulingTimeSpan.ResponseTime.TotalMilliseconds.ToString("0.00"),
schedulingTimeSpan.RunTime.TotalMilliseconds.ToString("0.00"),
schedulingTimeSpan.WaitTime.TotalMilliseconds.ToString("0.00"),
schedulingTimeSpan.TurnaroundTime.TotalMilliseconds.ToString("0.00"),
schedulingTimeSpan.NumPreemptions),
1);
}
QueryMetricsUtils.AppendHeaderToStringBuilder(stringBuilder, SchedulingMetricsTable.BottomLine, 1);
}
return(stringBuilder.ToString());
}