Settings

Nightly Feature You can use the information_schema.settings view to list Firebolt’s public engine settings together with their current values, defaults, types, and descriptions.

SELECT
  *
FROM
  information_schema.settings;

This view reports the public settings: the carefully curated set that Firebolt documents, supports, and keeps stable across releases. System settings describes what they do and how to change them. The view has the same columns as pg_catalog.pg_settings, with the same meaning per column, but reports only the public settings. pg_catalog.pg_settings reports every setting the engine defines, internal ones included, and so does SHOW ALL. A name that returns no row here but a row from pg_catalog.pg_settings is an internal setting: its name and default change between releases, so treat it as an implementation detail rather than an interface. The setting column holds the value in effect for the query that reads the view, so a value changed with SET earlier in the session is reflected there, while boot_val and reset_val keep reporting the default. Every setting listed here can also be read one at a time, by name, with current_setting:

SELECT
  current_setting('max_result_rows');

Custom settings, meaning names the engine does not define, are not listed, and current_setting does not read them either.

Columns

Each row describes one setting. Columns that Firebolt does not populate are always NULL; they exist so that the view keeps the shape Postgres clients expect from pg_settings.

Column Name	Data Type	Description
name	TEXT	Name of the setting.
setting	TEXT	Current value of the setting, as text.
unit	TEXT	Always `NULL`.
category	TEXT	Always `NULL`.
short_desc	TEXT	Description of the setting.
extra_desc	TEXT	Always `NULL`.
context	TEXT	Always `user`. Every listed setting can be changed for a session or a single query.
vartype	TEXT	SQL type of the setting value: `boolean`, `bigint`, `real`, or `text`. A setting that only accepts a fixed set of names reports `enum`, and `enumvals` lists those names.
source	TEXT	Always `NULL`.
min_val	TEXT	Always `NULL`.
max_val	TEXT	Always `NULL`.
enumvals	ARRAY(TEXT)	Every value a setting with `vartype` `enum` accepts, in the order the engine declares them. `NULL` for all other settings. A few settings accept any comma-separated combination of the listed values rather than exactly one of them; their description says so.
boot_val	TEXT	Default value of the setting, as text.
reset_val	TEXT	Default value of the setting, as text.
sourcefile	TEXT	Always `NULL`.
sourceline	INTEGER	Always `NULL`.
pending_restart	BOOLEAN	Always `false`. Settings take effect immediately.

Example

Look up specific settings and compare their current values against the defaults:

SELECT
  name,
  setting,
  boot_val,
  vartype
FROM
  information_schema.settings
WHERE
  name IN ('enable_result_cache', 'max_result_rows', 'timezone')
ORDER BY
  name;

name	setting	boot_val	vartype
enable_result_cache	true	true	boolean
max_result_rows	0	0	bigint
timezone	UTC	UTC	text

Overview

Performance and Observability

Security

Self-Managed

Managed service

Guides

SQL reference

Compatibility modes

Release notes

API reference

Legal

Columns

Example

​Columns

​Example

Columns

Example