How to find the number of cached pages for a relation?

Поиск
Список
Период
Сортировка
От Amin
Тема How to find the number of cached pages for a relation?
Дата
Msg-id CAF-KA8_axSMpQW1scOTnAQx8NFHgmJc6L87QzAo3JezLiBU1HQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: How to find the number of cached pages for a relation?  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
Hi,

Before scanning a relation, in the planner stage, I want to make a call to retrieve information about how many pages will be a hit for a specific relation. The module pg_buffercache seems to be doing a similar thing. Also, pg_statio_all_tables seems to be having that information, but it is updated after execution. However, I want the information before execution. Also not sure how pg_statio_all_tables is created and how I can access it in the code.

Thank you!

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: Fixes required for cross version update testing
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: pgsql: Add new GUC createrole_self_grant.