Re:

From: Michael Goldberg <mic(dot)goldberg(at)gmail(dot)com>
To: otar shavadze <oshavadze(at)gmail(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re:
Date: 2021-08-15 10:14:55
Message-ID: CADJmpXH0LnO9xeLmO0GEJBPP001duc2WMW3VX2U2d9fGt9jLsw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

  • at 2021-08-15 09:49:34 from otar shavadze

Responses

  • Re: at 2021-08-15 11:12:08 from otar shavadze
  • Re: at 2021-08-15 20:27:34 from David Rowley

Browse pgsql-general by date

  From Date Subject
Next Message otar shavadze 2021-08-15 11:12:08 Re:
Previous Message otar shavadze 2021-08-15 09:49:34