II.
LibraryProcess overview
Reference · livelib-process:performance-optimization--query-performance-analysis
specializations/performance-optimization/query-performance-analysis overview
Query Performance Analysis - Analyze and optimize slow database queries including execution plan analysis, index identification, join strategy optimization, and query complexity review.
Attributes
displayName
specializations/performance-optimization/query-performance-analysis
description
Query Performance Analysis - Analyze and optimize slow database queries including execution plan
analysis, index identification, join strategy optimization, and query complexity review.
libraryPath
library/specializations/performance-optimization/query-performance-analysis.js
specialization
performance-optimization
references
- - Use The Index Luke: https://use-the-index-luke.com/
- - PostgreSQL EXPLAIN: https://www.postgresql.org/docs/current/sql-explain.html
example
const result = await orchestrate('specializations/performance-optimization/query-performance-analysis', {
projectName: 'E-commerce Platform',
database: 'postgresql',
slowQueryThreshold: 100
});
usesAgents
- performance-engineer
Outgoing edges
lib_applies_to_domain1
- domain:software-engineering·DomainSoftware Engineering
lib_belongs_to_specialization1
- specialization:performance-optimization·Specialization
lib_covers_topic1
- topic:observability-driven-development·TopicObservability-Driven Development
lib_implements_workflow1
- workflow:performance-profiling-cycle·WorkflowPerformance Profiling Cycle
lib_involves_role2
- role:backend-engineer·RoleBackend Engineer
- role:sre·Role
lib_requires_skill_area2
- skill-area:performance-monitoring-profiling·SkillAreaPerformance Monitoring and Profiling
- skill-area:profiling-cpu·SkillAreaCPU Profiling
uses_agent1
- lib-agent:software-architecture--performance-engineer·LibraryAgentperformance-engineer
Incoming edges
None.