pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
What 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