On Sun, Aug 15, 2021 at 12:49 PM otar shavadze <oshavadze(at)gmail(dot)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