PostgreSQL Extended Query

ProxySQL v3.0.3+ supports PostgreSQL’s Extended Query Protocol, including full prepared statement handling with global caching and lazy backend preparation.

For detailed documentation, see:

• Extended Query Architecture — two-tier ID mapping, global deduplication, and reference counting
• Extended Query Lifecycle — Parse, Bind, Execute, Close flows and error handling
• Extended Query Pooling & Caching — connection pooling interaction, cache management, and monitoring
• Prepared Statement Cache — detailed caching mechanics, three-tier mapping, and observability
• Extended Query Protocol — how ProxySQL handles the full Extended Query Protocol