Thank you.
On Sun, Aug 15, 2021 at 2:15 PM Michael Goldberg <mic.goldb...@gmail.com>
wrote:
>
> On Sun, Aug 15, 2021 at 12:49 PM otar shavadze <oshava...@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
>
