My postgresql 9.3 logs are sprinkled with entries like these (redacted to protect the guilty):

STATEMENT:  INSERT INTO table (key, value) VALUES ($1, $2)
ERROR:  duplicate key value violates unique constraint "table_pkey"
DETAIL:  Key (key)=(xyz) already exists.
STATEMENT:  INSERT INTO table (key, value) VALUES ('xyz', '{...json...}')

I know the source of the problem (a race condition where two app servers do the same work) and that code gracefully handles the insertion failure, but for the life of me I can't seem to get PostgreSQL to stop logging the statement which generated the error to begin with.

I've set log_statements for this db to 'none' (which persists across connections):

show log_statement;
(1 row)

But to no avail. These entries still keep hitting the logs. I wouldn't mind except the "values" from the logged statement are JSON blobs which aren't tiny. How can I keep PostgreSQL from logging whenever an insert violates the unique constraint?

  • 1
    log_error_verbosity ? Mar 20, 2015 at 19:41
  • @MilenA.Radev correct. "alter database db_name set log_error_verbosity to 'terse';" as an answer and I'll accept it.
    – notpeter
    Mar 20, 2015 at 19:56
  • log_min_messages and log_min_error_statement: postgresql.org/docs/current/static/…
    – user1822
    Mar 21, 2015 at 11:36
  • log_statement does not do the trick because it logs statements irregardless of errors. You want to modify what's logged in case of an error. Milen and a_horse provided the relevant settings for this. Mar 21, 2015 at 18:04

2 Answers 2


The amount of details logged is controlled by log_error_verbosity. Setting it to TERSE will exclude DETAIL, HINT, QUERY, and CONTEXT error information:

ALTER DATABASE db_name SET log_error_verbosity to 'TERSE';

Set log_error_verbosity to TERSE and log_min_error_statement to LOG in postgresql.conf and reload with

pc_ctl -D <data_dir> reload

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.