useSlowQueriesCount() — supabase Function Reference

Architecture documentation for the useSlowQueriesCount() function in useSlowQueriesCount.ts from the supabase codebase.

Function typescript ContentManagement MediaManagement called by 1

Entity Profile

ContentManagement→ MediaManagement→ useSlowQueriesCount() — supabase Function Reference

Dependency Diagram

graph TD
  910ee264_3322_2086_f02e_8c5907515007["useSlowQueriesCount()"]
  0009d41d_6f19_5684_073a_6abf433e87db["ObservabilityOverview()"]
  0009d41d_6f19_5684_073a_6abf433e87db -->|calls| 910ee264_3322_2086_f02e_8c5907515007
  style 910ee264_3322_2086_f02e_8c5907515007 fill:#6366f1,stroke:#818cf8,color:#fff

Relationship Graph

Source Code

apps/studio/components/interfaces/Observability/useSlowQueriesCount.ts lines 4–36

export const useSlowQueriesCount = (projectRef?: string, refreshKey: number = 0) => {
  // SQL to count queries with total execution time > 1000ms (1 second)
  // refreshKey is used in useMemo to force recomputation when refresh is triggered
  const sql = useMemo(
    () => `
    -- observability-slow-queries-count
    set search_path to public, extensions;

    SELECT
      count(*)::int as slow_queries_count
    FROM pg_stat_statements
    WHERE total_exec_time + total_plan_time > 1000;
  `,
    [refreshKey]
  )

  const { data, isLoading, error } = useDbQuery({
    sql,
  })

  const slowQueriesCount = useMemo(() => {
    if (!data || !Array.isArray(data) || data.length === 0) {
      return 0
    }
    return data[0]?.slow_queries_count ?? 0
  }, [data])

  return {
    slowQueriesCount,
    isLoading,
    error,
  }
}