recover_parameters
Recover real parameter values from auto_explain JSON logs to replace statistics synthesis, then use them to explain query plans or verify indexes.
Instructions
Recover REAL parameter values for a query from an auto_explain log — always a better grounding source than statistics synthesis. Requires auto_explain with log_format='json' and log_parameter_max_length != 0; pass the path to the (copied or mounted) log file.
Returns observed executions (slowest first) with their parameter values; feed those into explain_query or verify_index 'params'. Text values are redacted unless the profile opts out (redact = false).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | No | ||
| profile | Yes | ||
| queryid | No | ||
| log_path | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||