Postgres Pro
Downloads
Home   >   mailing lists

Difference between "Explain analyze" and "\timing" - Mailing list pgsql-performance

From tarcizioab@c3sl.ufpr.br
Subject Difference between "Explain analyze" and "\timing"
Date
Msg-id 50061.201.15.49.76.1217463555.squirrel@webmail.inf.ufpr.br
Whole thread Raw
Responses Re: Difference between "Explain analyze" and "\timing"
List pgsql-performance
Tree view 
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:

Previous
From: Mark Roberts
Date:
Subject: Re: Database size Vs performance degradation
Next
From: Bill Moran
Date:
Subject: Re: Difference between "Explain analyze" and "\timing"