Skip to main content

性能指标

Optimize 记录会话提供有关已执行查询延迟的详细信息,捕获关键指标,例如平均持续时间、第 50 个百分位、第 99 个百分位和最大查询执行时间。

¥An Optimize recording session provides detailed insights into the latencies of executed queries, capturing key metrics such as average duration, 50th percentile, 99th percentile, and maximal query execution time.

查询总时长

¥Total query durations

Prisma Optimize 可测量查询模式的总延迟,使你能够有效地分析和调试慢速查询。

¥Prisma Optimize measures total latency for query patterns, enabling you to analyze and debug slow queries effectively.

平均查询时长 (AVG)

¥Average query duration (AVG)

平均查询时长揭示了所有查询的平均执行时间,帮助你评估整体性能趋势并识别影响用户体验的低效环节。

¥The average query duration reveals the mean execution time across all queries, helping you assess overall performance trends and identify inefficiencies that impact the user experience.

50 百分位 (P50)

¥50th percentile (P50)

50% 的查询持续时间(或中位数)表示一半查询完成所需的时间。此指标清晰地显示了典型的用户性能,不受异常值的影响。

¥The 50th percentile, or median, query duration indicates the time within which half of your queries complete. This metric offers a clear view of typical user performance, unaffected by outliers.

99 百分位 (P99)

¥99th percentile (P99)

99% 的查询持续时间高亮最慢 1% 查询的执行时间。此指标对于发现和解决性能瓶颈至关重要,尽管这些瓶颈并不常见,但会显著影响用户满意度。

¥The 99th percentile query duration highlights the execution time for the slowest 1% of queries. This metric is crucial for uncovering and addressing performance bottlenecks that, while infrequent, can significantly impact user satisfaction.

最大查询持续时间 (MAX)

¥Maximal query duration (MAX)

最大查询时长衡量的是单个最慢查询所花费的时间。此指标有助于识别极端情况,深入了解系统可能面临的最差性能场景,以便你诊断和解决异常值。

¥The maximal query duration measures the time taken by the single slowest query. This metric helps identify extreme cases, providing insights into the worst performance scenarios your system might face, so you can diagnose and resolve outliers.