Re: EXPLAIN ANALYZE output

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: EXPLAIN ANALYZE output
Дата
Msg-id 4507.1135722988@sss.pgh.pa.us
обсуждение исходный текст
Ответ на EXPLAIN ANALYZE output  (David Rysdam <drysdam@ll.mit.edu>)
Список pgsql-general
David Rysdam <drysdam@ll.mit.edu> writes:
> According to what I've been able to find:

> A = predicted time to first returned row in milliseconds
                                              ^^^^^^^^^^^^ arbitrary units
> B = total cost in arbitrary units
> C = actual time to first returned row in milliseconds
> D = actual total time in milliseconds

> 2) Does EXPLAIN ANALYZE add a lot of overhead that is being measured here?

Yes, its per-row overhead can be significant.  Depends on what the query
plan actually is, and how many rows go through, which you didn't say...

            regards, tom lane

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

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: [ADMIN] Running with fsync=off
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [ADMIN] Running with fsync=off