Re: What is the number of rows in explain? - Mailing list pgsql-performance

From John A Meinel
Subject Re: What is the number of rows in explain?
Date
Msg-id 4231AEA1.7070300@arbash-meinel.com
Whole thread Raw
In response to What is the number of rows in explain?  ("Joost Kraaijeveld" <J.Kraaijeveld@Askesis.nl>)
List pgsql-performance
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
=:->


Attachment

pgsql-performance by date:

Previous
From: "Joost Kraaijeveld"
Date:
Subject: What is the number of rows in explain?
Next
From: Jacques Caron
Date:
Subject: Performance tuning