Search Postgresql Archives

negative duration times in query logs

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I started seeing some negative durations in my production query logs --
a "-" sign preceding the duration number, e.g.:

% grep 'duration: -' postgresql-Wed-*
postgresql-Wed-09.log:2008-01-02 08:56:33 PST [11705]: [538-1] LOG:
duration: -268280.421 ms
postgresql-Wed-15.log:2008-01-02 15:01:01 PST [30072]: [18-1] LOG:
duration: -1005.500 ms
postgresql-Wed-15.log:2008-01-02 15:01:01 PST [30066]: [14-1] LOG:
duration: -265.634 ms

These follow fairly standard queries that are issued hundreds if not
thousands times a day and ordinarily produce "normal" (positive)
durations. 

Has anyone seen this before? Any special meaning to the minus sign
(maybe it does not mean negative, but something else?)

I am running:

PostgreSQL 8.1.10 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC)
3.4.6 20060404 (Red Hat 3.4.6-3)

My logging setup is: 

 log_connections                 | on              
 log_destination                 | stderr          
 log_disconnections              | on              
 log_duration                    | on              
 log_error_verbosity             | default         
 log_executor_stats              | off             
 log_hostname                    | off             
 log_line_prefix                 | %t [%p]: [%l-1] 
 log_min_duration_statement      | -1              
 log_min_error_statement         | panic           
 log_min_messages                | notice          
 log_parser_stats                | off             
 log_planner_stats               | off             
 log_rotation_age                | 60              
 log_rotation_size               | 0               
 log_statement                   | all             
 log_statement_stats             | off             
 log_truncate_on_rotation        | on              
 redirect_stderr                 | on              

George

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux