数据库性能调试指南：识别慢查询、优化执行计划、提升应用响应速度

database-performance-debugging by aj-geddes/useful-ai-prompts

148 周安装量

141 GitHub Stars

GitHub

安装命令

npx skills add https://github.com/aj-geddes/useful-ai-prompts --skill database-performance-debugging

数据库调试性能优化

🇨🇳中文介绍

数据库性能调试

概述

数据库性能问题直接影响应用程序的响应速度。调试的重点在于识别慢查询并优化执行计划。

使用时机

应用程序响应时间慢
数据库 CPU 使用率高
识别出慢查询
性能回归
负载压力下

快速开始

最小工作示例：

-- Enable slow query log (MySQL)
SET GLOBAL slow_query_log = 'ON';
SET GLOBAL long_query_time = 0.5;

-- View slow queries
SHOW GLOBAL STATUS LIKE 'Slow_queries';
SELECT * FROM mysql.slow_log;

-- PostgreSQL slow queries
CREATE EXTENSION pg_stat_statements;
SELECT mean_exec_time, calls, query
FROM pg_stat_statements
ORDER BY mean_exec_time DESC LIMIT 10;

-- SQL Server slow queries
SELECT TOP 10
  execution_count,
  total_elapsed_time,
  statement_text
FROM sys.dm_exec_query_stats
ORDER BY total_elapsed_time DESC;

-- Query profiling
EXPLAIN ANALYZE
SELECT * FROM orders WHERE user_id = 123;
// ... (see reference guides for full implementation)

参考指南

references/ 目录下的详细实现：

广告位招租

在这里展示您的产品或服务

触达数万 AI 开发者，精准高效

联系我们

指南	内容
识别慢查询	识别慢查询
常见问题与解决方案	常见问题与解决方案
执行计划分析	执行计划分析
调试流程	调试流程

🇺🇸English

Database Performance Debugging

Overview
When to Use
Quick Start
Reference Guides
Best Practices

Overview

Database performance issues directly impact application responsiveness. Debugging focuses on identifying slow queries and optimizing execution plans.

When to Use

Slow application response times
High database CPU
Slow queries identified
Performance regression
Under load stress

Quick Start

Minimal working example:

-- Enable slow query log (MySQL)
SET GLOBAL slow_query_log = 'ON';
SET GLOBAL long_query_time = 0.5;

-- View slow queries
SHOW GLOBAL STATUS LIKE 'Slow_queries';
SELECT * FROM mysql.slow_log;

-- PostgreSQL slow queries
CREATE EXTENSION pg_stat_statements;
SELECT mean_exec_time, calls, query
FROM pg_stat_statements
ORDER BY mean_exec_time DESC LIMIT 10;

-- SQL Server slow queries
SELECT TOP 10
  execution_count,
  total_elapsed_time,
  statement_text
FROM sys.dm_exec_query_stats
ORDER BY total_elapsed_time DESC;

-- Query profiling
EXPLAIN ANALYZE
SELECT * FROM orders WHERE user_id = 123;
// ... (see reference guides for full implementation)

Reference Guides

Detailed implementations in the references/ directory:

Guide	Contents
Identify Slow Queries	Identify Slow Queries
Common Issues & Solutions	Common Issues & Solutions
Execution Plan Analysis	Execution Plan Analysis
Debugging Process	Debugging Process

Best Practices

✅ DO

Follow established patterns and conventions
Write clean, maintainable code
Add appropriate documentation
Test thoroughly before deploying

❌ DON'T

Skip testing or validation
Ignore error handling
Hard-code configuration values

Weekly Installs

130

Repository

aj-geddes/usefu…-prompts

GitHub Stars

127

First Seen

Jan 21, 2026

Security Audits

Gen Agent Trust HubPass SocketPass SnykPass

Installed on

opencode109

gemini-cli106

codex103

claude-code101

cursor99

github-copilot91