Bitmap Scan Pages

Поиск
Список
Период
Сортировка
От Listmail
Тема Bitmap Scan Pages
Дата
Msg-id op.trbtzjlwzcizji@apollo13
обсуждение исходный текст
Ответы Re: Bitmap Scan Pages
Список 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 по дате отправления:

Предыдущее
От: "A. Kretschmer"
Дата:
Сообщение: Re: reasonable limit to number of schemas in a database?
Следующее
От: Listmail
Дата:
Сообщение: Re: query from a list of ids