Difference between "Explain analyze" and "\timing"

Поиск
Список
Период
Сортировка
От tarcizioab@c3sl.ufpr.br
Тема Difference between "Explain analyze" and "\timing"
Дата
Msg-id 50061.201.15.49.76.1217463555.squirrel@webmail.inf.ufpr.br
обсуждение исходный текст
Ответы Re: Difference between "Explain analyze" and "\timing"  (Bill Moran <wmoran@collaborativefusion.com>)
Список 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 по дате отправления:

Предыдущее
От: Mark Roberts
Дата:
Сообщение: Re: Database size Vs performance degradation
Следующее
От: Bill Moran
Дата:
Сообщение: Re: Difference between "Explain analyze" and "\timing"