Re: [GENERAL] What does Rows Counted mean

2016-04-05 Thread Melvin Davidson
On Tue, Apr 5, 2016 at 1:37 PM, Adrian Klaver wrote: > On 04/05/2016 10:10 AM, Melvin Davidson wrote: > >> >> >> > >> FYI, in PgAdmin, there is an Option which determines if a _physical row >> count_ should be performed if the _estimated_ row count is less than a >> specified amount. It defaults

Re: [GENERAL] What does Rows Counted mean

2016-04-05 Thread Adrian Klaver
On 04/05/2016 10:10 AM, Melvin Davidson wrote: FYI, in PgAdmin, there is an Option which determines if a _physical row count_ should be performed if the _estimated_ row count is less than a specified amount. It defaults to 2000. To change it, Click on File, Options and under Browser click P

Re: [GENERAL] What does Rows Counted mean

2016-04-05 Thread Rakesh Kumar
On Tue, Apr 5, 2016 at 1:10 PM, Melvin Davidson wrote: > FYI, in PgAdmin, there is an Option which determines if a _physical row > count_ should be performed if the _estimated_ row count is less than a > specified amount. It defaults to 2000. > To change it, Click on File, Options and under Brow

Re: [GENERAL] What does Rows Counted mean

2016-04-05 Thread Melvin Davidson
On Tue, Apr 5, 2016 at 11:38 AM, Rakesh Kumar wrote: > This is on the object browser. When you navigate to the table and > click on the table name, you will see the output on the right side and > check the Properties tab. > > On Tue, Apr 5, 2016 at 10:37 AM, Adrian Klaver > wrote: > > On 04/05/2

Re: [GENERAL] What does Rows Counted mean

2016-04-05 Thread Rakesh Kumar
This is on the object browser. When you navigate to the table and click on the table name, you will see the output on the right side and check the Properties tab. On Tue, Apr 5, 2016 at 10:37 AM, Adrian Klaver wrote: > On 04/05/2016 07:11 AM, Rakesh Kumar wrote: >> >> pgAdmin shows this: >> >> Na

Re: [GENERAL] What does Rows Counted mean

2016-04-05 Thread Adrian Klaver
On 04/05/2016 07:11 AM, Rakesh Kumar wrote: pgAdmin shows this: Name: tableA OID Owner Tablespace Rows (estimated) : 10 Rows (Counted) : not counted What is Rows (Counted) and why it is showing not counted even though the table has been analyzed. Where is the above coming from in pgAd

[GENERAL] What does Rows Counted mean

2016-04-05 Thread Rakesh Kumar
pgAdmin shows this: Name: tableA OID Owner Tablespace Rows (estimated) : 10 Rows (Counted) : not counted What is Rows (Counted) and why it is showing not counted even though the table has been analyzed. thanks -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To ma