Bitmap Scan Pages - Mailing list pgsql-general

From Listmail
Subject Bitmap Scan Pages
Date
Msg-id op.trbtzjlwzcizji@apollo13
Whole thread Raw
Responses Re: Bitmap Scan Pages  (Jim Nasby <decibel@decibel.org>)
List pgsql-general
    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 CLUSTER) or
50 pages (ie. my table is well clustered, everything cool).
    Since, when it's cached, it's so fast anyway I cant' tell the difference,
but when it's not cached, it is important.

    This would give an interesting probe for EXPLAIN ANALYZE tuning...

pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: reasonable limit to number of schemas in a database?
Next
From: Listmail
Date:
Subject: Re: query from a list of ids