Skip site navigation (1) Skip section navigation (2)

rows in explain

From: "Lee Wu" <Lwu(at)mxlogic(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: rows in explain
Date: 2005-07-29 17:54:18
Message-ID: (view raw or whole thread)
Lists: pgsql-admin
Hi all,


I want to find out how PG gets rows when it explains a query.

For example, when I issue:


explain select count(*) from pg_class where relname='pg_class';

                          QUERY PLAN


 Aggregate  (cost=4.55..4.55 rows=1 width=0)

   ->  Seq Scan on pg_class  (cost=0.00..4.55 rows=1 width=0)

         Filter: (relname = 'pg_class'::name)

(3 rows)


Where and how PG get "rows=1"?


Thank you!


pgsql-admin by date

Next:From: Michael FuhrDate: 2005-07-29 18:45:15
Subject: Re: rows in explain
Previous:From: Luca StancapianoDate: 2005-07-29 17:26:30
Subject: problem on ssl client authentication

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group