| From: | Marti Raudsepp <marti(at)juffo(dot)org> |
|---|---|
| To: | Rafael Martinez <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: timing != log duration |
| Date: | 2012-03-21 11:53:05 |
| Message-ID: | CABRT9RBdEcm4snv41WsiMnF8KEfYbh=97j16tEMYcYsBw=GQuA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Wed, Mar 21, 2012 at 13:42, Rafael Martinez <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no> wrote:
> I am wondering why the time reported by \timing in psql is not the same
> as the time reported by duration in the log file when log_duration or
> log_min_duration_statement are on?
psql's \timing measures time on the client -- which includes the
network communication time (time to send the query to the server, and
receive back the results)
log_min_duration_statement measures time on the server, so it doesn't
know how long network transmission takes.
Regards,
Marti
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ktm@rice.edu | 2012-03-21 12:59:30 | Re: DBD-Pg prepared statement versus plain execution |
| Previous Message | Rafael Martinez | 2012-03-21 11:42:00 | timing != log duration |