From: otar shavadze <oshavadze(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject:
Date: 2021-08-15 09:49:34
Message-ID: CAG-jOyCCgAqrAGMh9T0w2n8ZWZBm8H=xaaO+u1UVSt4oBVwc0w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

How measure table total pages (block) count? would be this correct way? :

SELECT pg_table_size('my_table'::regclass) /
current_setting('block_size')::BIGINT;

Responses

  • Re: at 2021-08-15 10:14:55 from Michael Goldberg

Browse pgsql-general by date

  From Date Subject
Next Message Michael Goldberg 2021-08-15 10:14:55 Re:
Previous Message Pól Ua Laoínecháin 2021-08-15 08:23:31 Using a TRIGGER with window functions.