Supabase监控与日志 #

Dashboard > Home

概览信息
├── 数据库大小
├── 存储使用量
├── API请求数
├── 实时连接数
└── Edge Functions调用

Dashboard > Reports

报告类型
├── API使用统计
├── 数据库性能
├── 存储使用
├── 实时订阅
└── 认证统计

Dashboard > Logs > API

日志内容
├── 请求时间
├── 请求路径
├── 请求方法
├── 状态码
├── 响应时间
└── 错误信息

Dashboard > Logs > Database

日志内容
├── SQL查询
├── 执行时间
├── 错误信息
├── 连接信息
└── 事务日志

Dashboard > Logs > Auth

日志内容
├── 登录事件
├── 注册事件
├── 密码重置
├── Token刷新
└── 错误信息

# CLI查看函数日志
supabase functions logs my-function

# 实时日志
supabase functions logs my-function --follow

# 限制行数
supabase functions logs my-function --limit 100

-- 查看慢查询
SELECT 
    query,
    calls,
    total_time,
    mean_time,
    max_time
FROM pg_stat_statements
ORDER BY mean_time DESC
LIMIT 10;

-- 需要先启用扩展
CREATE EXTENSION IF NOT EXISTS pg_stat_statements;

-- 查看表大小
SELECT 
    schemaname,
    tablename,
    pg_size_pretty(pg_total_relation_size(schemaname||'.'||tablename)) as size
FROM pg_tables
WHERE schemaname = 'public'
ORDER BY pg_total_relation_size(schemaname||'.'||tablename) DESC;

-- 查看索引使用率
SELECT 
    schemaname,
    tablename,
    indexname,
    idx_scan,
    idx_tup_read,
    idx_tup_fetch
FROM pg_stat_user_indexes
ORDER BY idx_scan DESC;

-- 查看当前连接
SELECT 
    pid,
    usename,
    application_name,
    client_addr,
    state,
    query_start,
    query
FROM pg_stat_activity
WHERE state = 'active';

-- 查看连接数
SELECT count(*) FROM pg_stat_activity;

Dashboard > Settings > Alerts

告警类型
├── CPU使用率
├── 内存使用
├── 磁盘空间
├── 连接数
└── 错误率

// Edge Function: health-check
Deno.serve(async (req) => {
  const supabase = createClient(
    Deno.env.get('SUPABASE_URL')!,
    Deno.env.get('SUPABASE_SERVICE_ROLE_KEY')!
  )

  // 检查数据库连接
  const { error: dbError } = await supabase
    .from('_health')
    .select('id')
    .limit(1)

  // 检查存储
  const { error: storageError } = await supabase
    .storage
    .from('health-check')
    .list()

  const health = {
    database: !dbError,
    storage: !storageError,
    timestamp: new Date().toISOString(),
  }

  return new Response(JSON.stringify(health), {
    headers: { 'Content-Type': 'application/json' },
  })
})

-- 创建错误日志表
CREATE TABLE error_logs (
    id BIGSERIAL PRIMARY KEY,
    error_type TEXT,
    error_message TEXT,
    stack_trace TEXT,
    user_id UUID,
    request_path TEXT,
    created_at TIMESTAMPTZ DEFAULT NOW()
);

-- 错误统计
SELECT 
    error_type,
    COUNT(*) as count,
    MAX(created_at) as last_occurrence
FROM error_logs
WHERE created_at > NOW() - INTERVAL '24 hours'
GROUP BY error_type
ORDER BY count DESC;

-- 用户活动统计
SELECT 
    DATE(created_at) as date,
    COUNT(DISTINCT user_id) as active_users,
    COUNT(*) as total_requests
FROM api_logs
WHERE created_at > NOW() - INTERVAL '7 days'
GROUP BY DATE(created_at)
ORDER BY date;

-- 查看缺失索引
SELECT 
    schemaname,
    tablename,
    attname,
    n_distinct,
    correlation
FROM pg_stats
WHERE schemaname = 'public'
AND n_distinct > 100
ORDER BY n_distinct DESC;

-- 创建索引
CREATE INDEX idx_users_email ON users(email);
CREATE INDEX idx_posts_created ON posts(created_at DESC);

-- 分析查询计划
EXPLAIN ANALYZE 
SELECT * FROM posts WHERE author_id = 'user-uuid';

-- 使用索引扫描
EXPLAIN ANALYZE
SELECT * FROM posts WHERE author_id = 'user-uuid' ORDER BY created_at DESC;

监控项目
├── API响应时间
├── 数据库查询性能
├── 错误率
├── 连接数
├── 存储使用
└── 实时连接数

建议阈值
├── API响应时间 > 1秒
├── 错误率 > 1%
├── 数据库连接 > 80%
├── 存储使用 > 80%
└── CPU使用 > 80%