Skip to content

SET / RESET

SET and RESET change a setting for the current connection.

SET pivot_stats = true;
SELECT count(*) FROM system.tables;
RESET pivot_stats;
SET pivot_stats = true;
RESET pivot_stats;

SET pivot_stats = true includes execution statistics with query results. RESET pivot_stats turns them off.

The setting belongs to the current connection. Server memory, worker counts, and other deployment settings are configured in YAML.

These are Pivot settings. PostgreSQL wire compatibility does not make every PostgreSQL configuration parameter available through SET.