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