----- Original Message ----- > From the 9.5 docs: > > log_min_duration_statement (integer) > > Causes the duration of each completed statement to be logged if the > statement ran for at least the specified number of > milliseconds. Setting this to zero prints all statement > durations. Minus-one (the default) disables logging statement > durations. For example, if you set it to 250ms then all SQL statements > that run 250ms or longer will be logged. > > While the first sentence explicitly states a fixed unit (namely msec), > the last sentence seems to imply a (maybe optional) unit suffix > (ms in this case). Which one is true? > > How would e.g. "SET log_min_duration_statement=1min" be interpreted? As one minute. > > I'd prefer a docs clarification. # log all statements which take more than 100ms log_min_duration_statement = 100 # log all statements which take more than 30 seconds log_min_duration_statement = 30s All of the GUCS which take time have both a base unit (ms, s) or they accept a time abbreviation (ms, s, min, h). -- Josh Berkus Red Hat OSAS (opinions are my own) -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
