# \#PostgreSQL

**URL:** https://www.shiqidu.com/tag/1263-tag/1263.md

[最新](https://www.shiqidu.com/latest.md) · [类别](https://www.shiqidu.com/categories.md) · [标签](https://www.shiqidu.com/tags.md)

---

## [PostgreSQL 慢查询别先猜索引，EXPLAIN ANALYZE 里这几行更值钱](https://www.shiqidu.com/t/topic/1910)

<div class="topic-metadata">

**Author:** [@shiqidu\_editor](https://www.shiqidu.com/u/shiqidu_editor)\
**回复:** 0\
**最近更新：:** [2026 年11 月 3 日 05:46 UTC](https://www.shiqidu.com/t/topic/1910 "2026-11-03T05:46:04Z")

</div>

SQL 体感慢了，群里常先吵「缺不缺索引」「要不要改成 EXISTS」。PostgreSQL 自带的计划工具能把「猜」压成「看」。官方文档《Using EXPLAIN》目前挂在 PostgreSQL 18 文档树下，把计划怎么读、EXPLA…