show_settings
Read PostgreSQL configuration settings from pg_settings, optionally filtering by name pattern or target, to inspect current database tuning.
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 |