May 6th, 2011 by depesz | Tags: debug_pretty_print, debug_print_parse, debug_print_plan, debug_print_rewritten, logging, logging_collector, log_checkpoints, log_connections, log_destination, log_directory, log_disconnections, log_duration, log_error_verbosity, log_executor_stats, log_filename, log_hostname, log_line_prefix, log_lock_waits, log_min_duration_statement, log_min_error_statement, log_min_messages, log_parser_stats, log_planner_stats, log_rotation_age, log_rotation_size, log_statement, log_statement_stats, log_temp_files, log_timezone, log_truncate_on_rotation, postgresql, silent_mode, syslog_facility, syslog_ident, understanding | 3 comments »
After loooong pause, adding next (well, second) post to the "series". This time, I'd like to describe how logging works. And I don't mean binary logging (WAL), but the log for us, humans, to read. Before I will go to the ...
July 22nd, 2010 by depesz | Tags: logging, log_min_duration_statement, log_statement, pg_stat_activity, postgresql | No comments »
One of the questions that pop up frequently on IRC is how to see queries are now executed on the server, and what queries were earlier. Theoretically answer to this is simple - pg_stat_activity and log_min_duration_statement. Or log_statement. What is the ...
