mirror of
https://github.com/supabase/supabase.git
synced 2026-10-10 11:55:05 +03:00
Joshen Lim
cf7da58eb3
## Context Building on top of "Database Connections" - this adds a top summary section, again from `pg_stat_activity` <img width="948" height="324" alt="image" src="https://github.com/user-attachments/assets/f4968193-0a5f-4754-a630-40685b747999" /> Each block comes with a tooltip in hopes to educate the significance of each metric - Connections: Spread of connections per database role <img width="313" height="164" alt="image" src="https://github.com/user-attachments/assets/8ceeab5d-b960-4be3-9a5b-8600bd5cf303" /> - Active queries: Rough representative of activity <img width="350" height="196" alt="image" src="https://github.com/user-attachments/assets/f9705ff1-a869-409a-86b6-50170a169674" /> - Idle in transaction: Important to identify as this indicates locks (Suggests root cause) <img width="350" height="196" alt="image" src="https://github.com/user-attachments/assets/f9705ff1-a869-409a-86b6-50170a169674" /> - Blocked queries: Also important to identify stuck queries <img width="335" height="183" alt="image" src="https://github.com/user-attachments/assets/57255fb8-24f6-4ddd-aa54-850a77173b5c" /> - Longest running query: Might be useful to identify unusually long queries - Will be `text-warning` if exceeds 30 seconds for active queries, `text-destructive` if exceeds 10 seconds for queries idle in transaction <img width="342" height="119" alt="image" src="https://github.com/user-attachments/assets/f6783b43-058a-4a32-a40c-0bc64f23d2ce" /> "Summarize activity" CTA leverages on the Assistant to give a quick overview - highlights any potential issues for quick reference <img width="1918" height="958" alt="image" src="https://github.com/user-attachments/assets/340121fe-3186-48a5-8023-fbac2a93397a" /> ## Other changes - Hides "View running queries" in SQL Editor if `topForPostgres` feature flag is enabled (since this UI is meant to replace that) <!-- This is an auto-generated comment: release notes by coderabbit.ai --> ## Summary by CodeRabbit * **New Features** * Added a Database Connections observability overview with metric cards (connections, longest-running, active, blocked, idle-in-transaction) and an interactive “Longest running” PID selector. * Added a “Summarize activity” AI assistant dropdown that starts a timestamped, activity-aware summary chat. * **Improvements** * Enhanced live activity refresh (including window-focus updates) and standardized duration warning thresholds for active and idle-in-transaction sessions. * Improved hover details for query previews and allowed richer tooltip content for metric labels. * **Feature Changes** * Gated the “View running queries” bottom panel behind a feature flag. * **Bug Fixes** * Refined running-too-long badge and warning styling for idle-in-transaction cases. <!-- end of auto-generated comment: release notes by coderabbit.ai -->
19 lines
1.0 KiB
TypeScript
19 lines
1.0 KiB
TypeScript
// [Joshen] These are opinionated thresholds for when things might need attention
|
||
// For queries in "active" state - show warning variant if running longer than 30 seconds
|
||
// - Typically Not a problem unless its running longer than expected
|
||
// For queries in "idle in transaction" state - show warning variant if running longer than 30 seconds
|
||
// - Shorter threshold as it indicates a lock
|
||
export const WARN_DURATION_ACTIVE_QUERY = 30 // seconds
|
||
export const WARN_DURATION_IDLE_TXN = 10 // seconds
|
||
|
||
export const QUERY_STATE_TOOLTIP = {
|
||
['active']: 'Currently executing a query.',
|
||
['idle']: 'Connected, but not currently running a query.',
|
||
['disabled']: 'Activity tracking is disabled for this session.',
|
||
['idle in transaction']: 'Has an open transaction but isn’t currently running a query.',
|
||
['idle in transaction (aborted)']:
|
||
'The last statement in this transaction failed and hasn’t been rolled back yet.',
|
||
['fastpath function call']:
|
||
'Executing a function call via Postgres’s low-level fastpath protocol.',
|
||
}
|