---
title: "EXPLAIN / EXPLAIN ANALYZE — Database Glossary | Xata"
description: "Diagnostic commands showing the query execution plan. EXPLAIN shows the estimated plan; EXPLAIN ANALYZE executes the query and shows actual timings, row..."
source: "https://xata.io/glossary/explain"
---

# EXPLAIN / EXPLAIN ANALYZE

SQL

Diagnostic commands showing the query execution plan. EXPLAIN shows the estimated plan; EXPLAIN ANALYZE executes the query and shows actual timings, row counts, and buffer usage.

Related terms

[Query Plan](/glossary/query-plan)

[← Back to glossary](/glossary)