pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedWhat is the number of rows in explain?
2+ messages / 2 participants
[nested] [flat]
* What is the number of rows in explain?
@ 2005-03-11 13:45 Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
2005-03-11 14:43 ` Re: What is the number of rows in explain? John A Meinel <john@arbash-meinel.com>
0 siblings, 1 reply; 2+ messages in thread
From: Joost Kraaijeveld @ 2005-03-11 13:45 UTC (permalink / raw)
To: pgsql-performance
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: What is the number of rows in explain?
2005-03-11 13:45 What is the number of rows in explain? Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
@ 2005-03-11 14:43 ` John A Meinel <john@arbash-meinel.com>
0 siblings, 0 replies; 2+ messages in thread
From: John A Meinel @ 2005-03-11 14:43 UTC (permalink / raw)
To: Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>; +Cc: 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
=:->
Attachments:
signature.asc (application/pgp-signature, 252B) download
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-03-11 14:43 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-03-11 13:45 What is the number of rows in explain? Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
2005-03-11 14:43 ` John A Meinel <john@arbash-meinel.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox