What does log mean

From: Daniel Drotos <drdani(at)mazsola(dot)iit(dot)uni-miskolc(dot)hu>
To: pgsql-admin(at)postgresql(dot)org
Subject: What does log mean
Date: 2005-08-31 10:47:24
Message-ID: Pine.LNX.4.61.0508311239400.27041@mazsola.iit.uni-miskolc.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

If I ask detailed information about statements in log file, I got
something like:

...
2005-08-29 10:19:15 CEST ...(...)DETAIL: ! system usage stats:
! 101.659118 elapsed 0.640000 user 0.950000 system sec
! [0.670000 user 0.970000 sys total]
...

What does "elapsed" value contain exactly? Does it include
client-server communication time or just the query running time?

How can I examine what is the network overhead between the client and
the server?

Daniel

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message MG 2005-08-31 11:42:31 Question to localization
Previous Message Jan Waiz 2005-08-31 08:29:02 Replication