Configuration parameter

client_min_messages — PostgreSQL configuration parameter

Category Client Connection Defaults Default NOTICE

Controls which message levels are sent to the client.

At a glance

Property Value
Parameter client_min_messages
Category Client Connection Defaults
Default NOTICE
Value type enum
Change scope Per-session (SET)
Available in PostgreSQL 12, 13, 14, 15, 16, 17, 18, 19 (added in 12)

What it does

Controls which message levels are sent to the client. Valid values are DEBUG5, DEBUG4, DEBUG3, DEBUG2, DEBUG1, LOG, NOTICE, WARNING, and ERROR. Each level includes all the levels that follow it. The later the level, the fewer messages are sent. The default is NOTICE. Note that LOG has a different rank here than in log_min_messages.

INFO level messages are always sent to the client.

(Description quoted from the official PostgreSQL documentation.)

How to apply a change

Can be set per session with SET, per role/database with ALTER ROLE/DATABASE ... SET, or globally in postgresql.conf.

Inspect the current value and source with SHOW client_min_messages; or SELECT name, setting, unit, context, source FROM pg_settings WHERE name = 'client_min_messages';.

Tuning guidance

This sets a session default (locale, formatting, search path or transaction behaviour) rather than a performance knob. Set it per role or database with ALTER ROLE/DATABASE ... SET so the right default follows the right workload, and prefer setting it explicitly in the application for behaviour the query results depend on.

Reference

PostgreSQL documentation — client_min_messages.

Keep going

Related & next steps

Was this helpful?

← All configuration parameters