Changes between Version 56 and Version 57 of InstallationGuidelines/PostgreSQL


Ignore:
Timestamp:
11/16/11 10:46:06 (10 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • InstallationGuidelines/PostgreSQL

    v56 v57  
    262262 * http://www.postgresql.org/docs/8.4/static/runtime-config-logging.html
    263263
    264 Log all queries which take longer than 5s:
     264Log all queries which take longer than 500ms:
    265265{{{
    266266vim /etc/rsyslog.conf
     
    273273syslog_facility = 'LOCAL0'
    274274syslog_ident = 'postgres'
    275 log_min_duration_statement = 5000
     275log_min_duration_statement = 500
    276276
    277277/etc/init.d/postgresql restart
     
    289289
    290290
    291 Log all queries which take longer than 5s & do an 'EXPLAIN' on those queries (not working)
     291Log all queries which take longer than 500ms & do an 'EXPLAIN' on those queries (not working)
    292292 * http://www.depesz.com/index.php/2008/11/23/waiting-for-84-auto-explain/
    293293{{{
    294294LOAD 'auto_explain';
    295 set explain.log_min_duration = 5000;
     295set explain.log_min_duration = 500;
    296296}}}
    297297== Also see ==