Skip to main content

Kingbase Performance Metrics

Metric AliasMetric DescriptionUnit
ConnectionCollects connection status information such as active connections, idle connections, and maximum connectionsCount
TransactionCollects transaction status information such as committed transactions and rolled-back transactionsCount
Query PerformanceCollects performance information such as average query execution timems
Lock WaitCollects lock wait information such as waiting lock countCount
Query StatisticsCollects query execution count, returned rows, shared block hits, shared block reads, and total execution timeCount, Rows, ms
Buffer CacheCollects Buffer Cache hit ratio, shared block hits, shared block reads, and related information%, Count
Database StatusCollects block hits, block reads, conflicts, backend count, and inserted/updated/deleted tuple informationCount
TablespaceCollects tablespace name and tablespace size informationBytes
Lock DetailCollects lock count information for different lock typesCount
Index UsageCollects index scan count, sequential scan count, index hit ratio, and related informationCount, %
Background WriterCollects backend buffer writes, background writer buffer writes, requested checkpoints, and timed checkpointsCount
Session ActivityCollects session state, wait events, session count, and related informationCount
Query CancellationCollects deadlock count, temporary file count, and related informationCount
Function StatisticsCollects function call count, self time, total time, and related informationCount, ms
Slow QueryCollects slow query call count, average execution time, total execution time, and related informationCount, ms