PostgreSQL configs! ^^

.psqlrc

\set QUIET 1
\pset format wrapped
\pset null ''
\pset pager on
\set COMP_KEYWORD_CASE upper
\set extensions 'select * from pg_available_extensions;'
\set HISTSIZE 9999
\set PROMPT1 '%[%033[1;31m%]psql%[%033[0m%]:%[%033[1;33m%]%/ %[%033[1;35m%]>%[%033[0m%] '
\set PROMPT2 '%[%033[1;31m%]> %[%033[0m%] '
\set show_slow_queries 'SELECT (total_time / 1000 / 60) as total_minutes, (total_time/calls) as average_time, query FROM pg_stat_statements ORDER BY 1 DESC LIMIT 100;'
\set VERBOSITY verbose
\set version 'SELECT version();'
\timing
\x auto
\set QUIET 0

postgresql.conf

log_connections = on
log_disconnections = on
log_line_prefix = '%t %c %q%u@%h:%d '
log_min_messages = "DEBUG3"

shared_preload_libraries = 'pg_stat_statements'		# (change requires restart)
pg_stat_statements.max = 1000
pg_stat_statements.track = all
#https://gist.github.com/troyk/4462899

track_activities = on
track_counts = on
track_io_timing = off
track_functions = none			# none, pl, all
track_activity_query_size = 1024	# (change requires restart)
update_process_title = on
stats_temp_directory = 'pg_stat_tmp'


# - Statistics Monitoring -

log_parser_stats = off
log_planner_stats = off
log_executor_stats = off
log_statement_stats = off