X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D62AA565D4 for ; Fri, 11 Mar 2005 14:43:57 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 50813-09 for ; Fri, 11 Mar 2005 14:43:55 +0000 (GMT) Received: from ct.radiology.uiowa.edu (ct.radiology.uiowa.edu [129.255.60.186]) by svr1.postgresql.org (Postfix) with ESMTP id 072BC565AC for ; Fri, 11 Mar 2005 14:43:53 +0000 (GMT) Received: from [192.168.1.11] (12-217-241-0.client.mchsi.com [12.217.241.0]) by ct.radiology.uiowa.edu (8.11.6/8.11.6) with ESMTP id j2BEht320430; Fri, 11 Mar 2005 08:43:56 -0600 Message-ID: <4231AEA1.7070300@arbash-meinel.com> Date: Fri, 11 Mar 2005 08:43:45 -0600 From: John A Meinel User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Joost Kraaijeveld Cc: "Pgsql-Performance (E-mail)" Subject: Re: What is the number of rows in explain? References: In-Reply-To: X-Enigmail-Version: 0.89.5.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig9B513C46F6EDA591C4B7ED11" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200503/189 X-Sequence-Number: 10894 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig9B513C46F6EDA591C4B7ED11 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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 =:-> --------------enig9B513C46F6EDA591C4B7ED11 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.6 (Cygwin) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCMa6lJdeBCYSNAAMRAi9gAJ4v1q+WVhGBM8ta1mcFmeh5QqujEQCfYuR2 ZSNOiEJAdfvGdAy+Kw3kWqM= =z7iU -----END PGP SIGNATURE----- --------------enig9B513C46F6EDA591C4B7ED11--