Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread 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


pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group