On Sun, Aug 15, 2021 at 12:49 PM otar shavadze <oshavadze@gmail.com> wrote:How measure table total pages (block) count? would be this correct way? :SELECT pg_table_size('my_table'::regclass) / current_setting('block_size')::BIGINT;Did you try:SELECT relpages FROM pg_class WHERE relname='my_table'; Best,Michael
How measure table total pages (block) count? would be this correct way? :SELECT pg_table_size('my_table'::regclass) / current_setting('block_size')::BIGINT;
SELECT pg_table_size('my_table'::regclass) / current_setting('block_size')::BIGINT;
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных