plpgsql function for EXPLAIN of generic plan
Params:
- query (text)
- optionally, format (text -- detault -- or JSON)
- optionally, ideas to verify using hypopg (e.g., index ideas, array of text -- queries)
Acceptance Criteria
- PL/pgSQL function accepts a query text and returns EXPLAIN output for the generic plan
- Optional format parameter supports text (default) and JSON output
- Optional array of index definitions for HypoPG-based hypothetical index verification
- Function works on PostgreSQL 14+
Definition of Done
- Function is created and tested with various query types
- HypoPG integration tested for index suggestions
- Documentation covers function parameters and usage examples
Edited by Nikolay Samokhvalov