FICHA · AUR

pg_show_plans

Shows the query plans of all currently running SQL statements

  • Database extension
  • DATABASE-EXTENSION
  • Dependency only
official+codex · reviewed · Jun 3, 2026 description in en

Description

Exposes execution plans for currently running PostgreSQL statements. It is a server-side diagnostics extension for database administrators troubleshooting slow queries, lock waits, or unexpected planner choices. It can reveal SQL text and runtime behavior from active sessions, so access should be limited to trusted operators.

Permissions

Permissions not analysed for this source yet.