---
title: "analyze query"
description: "Analyze database queries for performance issues using EXPLAIN plans and query patterns."
type: skill
canonical_url: https://claudary.paisolsolutions.com/skills/analyze-query
source: "Claudary"
difficulty: intermediate
author: "Claude Code Knowledge Pack"
date: 2026-07-10T11:07:31.978Z
license: CC-BY-4.0
attribution: "analyze query — Claudary (https://claudary.paisolsolutions.com/skills/analyze-query)"
---

# analyze query
Analyze database queries for performance issues using EXPLAIN plans and query patterns.

## Overview

Analyze database queries for performance issues using EXPLAIN plans and query patterns.

## Steps


1. Identify the slow or problematic query:
2. Run EXPLAIN (or EXPLAIN ANALYZE) on the query:
3. Analyze common performance issues:
4. Check for lock contention:
5. Suggest optimizations:
6. Estimate improvement from each suggestion.

## Format


```
Query: <simplified query>
Current Time: <execution time>
Issues Found:
  - <issue>: <impact>
```


## Rules

- Always use EXPLAIN ANALYZE for real execution statistics.
- Consider the query frequency when prioritizing optimizations.
- Test optimizations on a staging environment first.

---

Source: [Claudary](https://claudary.paisolsolutions.com/skills/analyze-query) · https://claudary.paisolsolutions.com