Обсуждение: What is the number of rows in explain?

Поиск
Список
Период
Сортировка

What is the number of rows in explain?

От
"Joost Kraaijeveld"
Дата:
Hi all,

Is the number of rows in explain the number of rows that is expected to be visited or retrieved?

Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J.Kraaijeveld@Askesis.nl
web: www.askesis.nl

Re: What is the number of rows in explain?

От
John A Meinel
Дата:
Joost Kraaijeveld wrote:

>Hi all,
>
>Is the number of rows in explain the number of rows that is expected to be visited or retrieved?
>
>Groeten,
>
>Joost Kraaijeveld
>Askesis B.V.
>Molukkenstraat 14
>6524NB Nijmegen
>tel: 024-3888063 / 06-51855277
>fax: 024-3608416
>e-mail: J.Kraaijeveld@Askesis.nl
>web: www.askesis.nl
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
In general, it is the number of rows expected to be retrieved. Since a
Sequential Scan always visits every row, but the rows= number is after
filtering.

John
=:->


Вложения