PostgreSQL Server 設定筆記 Feb 21st, 2014 log 位置 1 2 /home/logs/pg/ /net/home0/_vlog/logs/db/ 設定檔位置 1 /net/pgsql/9.2.4/data/postgresql.conf 若要紀錄所有執行的 sql, 在 postgresql.conf 做以下設定 1 log_statement = 'all' # none, ddl, mod, all 若要紀錄執行時間 > 3 秒的 sql 1 2 3 4 # -1 is disabled, 0 logs all statements # and their durations, > 0 logs only statements running at least # this number of milliseconds log_min_duration_statement = 3000 ref : http://www.rhyous.com/2010/09/10/how-to-log-all-sql-statements-in-postgresql-running-on-freebsd/