show_settings
Read PostgreSQL configuration parameters from pg_settings, optionally filtering by name pattern or target. Check current values for tuning and troubleshooting.
Instructions
[READ] Configuration parameters from pg_settings.
Args:
pattern: Optional case-insensitive substring to filter setting names
(e.g. 'work_mem', 'autovacuum').
target: Target name from config; omit for the default.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| target | No | ||
| pattern | No |