Re: [GENERAL] Bitmap Scan Pages

2007-04-30 Thread Jim Nasby
On Apr 25, 2007, at 7:36 AM, Listmail wrote: Is there a way to know how many pages were hit by a Bitmap Heap scan ? For instance : Bitmap Heap Scan on posts (cost=56.71..295.24 rows=2123 width=67) (actual time=0.575..1.462 rows=2160 loops=1) I'd like to know if it hit 2160 pages (i

[GENERAL] Bitmap Scan Pages

2007-04-24 Thread Listmail
Hello, Is there a way to know how many pages were hit by a Bitmap Heap scan ? For instance : Bitmap Heap Scan on posts (cost=56.71..295.24 rows=2123 width=67) (actual time=0.575..1.462 rows=2160 loops=1) I'd like to know if it hit 2160 pages (ie I should really run CL