What does \timing measure?

Поиск
Список
Период
Сортировка
От Daniel Tahara
Тема What does \timing measure?
Дата
Msg-id CACDEi8Noi54jmEhSJ1vNFLmeZ6wOsiTqGxh0wCKdK1y-aChK3g@mail.gmail.com
обсуждение исходный текст
Ответы Re: What does \timing measure?  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-general
I am attempting to benchmark a number of queries over a 15GB dataset with ~ 10mil records. When I run linux time on the query execution (single column projection), it returns 1 minute, but the \timing command returns only 15 seconds? Can someone explain the difference? 1 minute is consistent with reading the 15gb from disk at 250mb/s (I have SSDs), but is \timing supposed to include that cost? Or simply the computation time plus the time to return results.

Thank you.

Daniel

Computer Science
Yale University, Class of 2014
daniel.tahara@yale.edu
(646) 397-6379

В списке pgsql-general по дате отправления:

Предыдущее
От: "Hall, Samuel L (Sam)"
Дата:
Сообщение: backup and restore functions
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: What does \timing measure?