Re:

[otar shavadze <oshavadze@xxxxxxxxx>]

Thank you.
 

On Sun, Aug 15, 2021 at 2:15 PM Michael Goldberg <mic.goldberg@xxxxxxxxx> wrote:

On Sun, Aug 15, 2021 at 12:49 PM otar shavadze <oshavadze@xxxxxxxxx> 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