Tag Archives: Log

Postgresql – Logging SQL query and time for Analysis

Change the following log option in postgresql.conf as log_error_verbosity = default # terse, default, or verbose messages log_duration = on log_line_prefix = ‘%t%d’ # Special values: log_statement = ‘all’ # none, mod, ddl, all

Posted in Database, Linux | Tagged , , | Leave a comment