yugabyte/yugabyte-db

[YSQL] Catalog cache misses counter does not include DB name in metrics attribuet

Open

#29,491 建立於 2025年11月26日

在 GitHub 查看
 (1 留言) (0 反應) (1 負責人)C (8,229 star) (1,003 fork)batch import
area/ysqlgood first issuekind/bugpriority/medium

描述

Jira Link: DB-19294

Description

This metric is exported as

handler_latency_yb_ysqlserver_SQLProcessor_CatalogCacheMisses_count{metric_id="yb.ysqlserver",metric_type="server",table_name="pg_am_name_index",exported_instance="yb-admin-sanketh-gcp4-n1"} 0 1764116240112

without the namespace_name or namespace_id attribute. This means that misses from different dbs cannot be distinguished.

@kai-franz

Issue Type

kind/bug

Warning: Please confirm that this issue does not contain any sensitive information

  • I confirm this issue does not contain any sensitive information.

貢獻者指南

技術棧
csqlpostgresqlprometheus
領域
databaseobservabilitybackend
議題類型
bug
難度面向新貢獻者的預計實作難度，1 表示很小改動，5 表示專家級工作。
4
預計時間有經驗貢獻者完成調查、實作、測試並準備 pull request 的粗略時間範圍。
half day
活動狀態議題目前的可參與程度：新鮮、活躍、陳舊、阻塞或等待維護者輸入。
blocked
清晰度議題是否清楚說明預期改動、驗收標準和下一步。
clear
前置要求
C programmingYSQL internalsPrometheus metrics
新手友善度1-100 的估計分數，表示該議題對首次貢獻者的友善程度。
25
研究方向
The issue reports that the handler latency yb ysqlserver SQLProcessor CatalogCacheMisses count metric is missing the namespace name or namespace id attribute. To resolve, locate the code that emits this metric (likely in the YSQL layer) and add the database name as a label. The existing code path for similar metrics might serve as a reference. The Jira link DB 19294 may contain additional details. There is no linked PR or comment indicating progress.