Thank you.
On Sun, Aug 15, 2021 at 2:15 PM Michael Goldberg <[email protected]> wrote: > > On Sun, Aug 15, 2021 at 12:49 PM otar shavadze <[email protected]> > 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 >
