Re: [ADMIN] Statement duration reporting

2006-02-11 Thread Tom Lane
"Erik G. Burrows" <[EMAIL PROTECTED]> writes: > So, my question is: What does the duration time in the serverlog > reflect? Is it just the time the server took to execute the statement, > or does it reflect also query receive and response transmit time? The former. The server has no way to measur

[ADMIN] Statement duration reporting

2006-02-10 Thread Erik G. Burrows
Hello All, I'm running PostgreSQL 7.4.7 (Debian package 7.4.7-6sarge1) on an AMD Opteron system wth Debian 3.1. In analyzing performance for this database, by logging statements with duration timing, I have many statements that are taking far longer to run than they should. For example, inserts in