Blocks read for index scans

Поиск
Список
Период
Сортировка
От Jim Nasby
Тема Blocks read for index scans
Дата
Msg-id 85979594-1CCA-43C5-A8F2-08685CF41ACE@pervasive.com
обсуждение исходный текст
Ответы Re: Blocks read for index scans
Re: Blocks read for index scans
Список pgsql-performance
While working on determining a good stripe size for a database, I
realized it would be handy to know what the average request size is.
Getting this info is a simple matter of joining pg_stat_all_tables
and pg_statio_all_tables and doing some math, but there's one issue
I've found; it appears that there's no information on how many heap
blocks were read in by an index scan. Is there any way to get that info?
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461



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