Difference between "Explain analyze" and "\timing"

From: tarcizioab(at)c3sl(dot)ufpr(dot)br
To: pgsql-performance(at)postgresql(dot)org
Subject: Difference between "Explain analyze" and "\timing"
Date: 2008-07-31 00:19:15
Message-ID: 50061.
Views: Raw Message | Whole Thread | Download mbox
Lists: pgsql-performance

Hello friends

The commands "\timing" and "EXPLAIN ANALYZE" return values related to the
time of execution of the instruction. These values are "Time:" and "Total
runtime:" respectively. What is the difference between these values, and
the specific use of each command in queries?

If someone can help me.

Thank's for attention.

Tarcizio Bini


Browse pgsql-performance by date

  From Date Subject
Next Message Bill Moran 2008-07-31 00:59:22 Re: Difference between "Explain analyze" and "\timing"
Previous Message Mark Roberts 2008-07-30 22:14:19 Re: Database size Vs performance degradation