Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_total_relation_size shows 0 byt table has thousands of rows - Mailing list pgsql-admin

From David G. Johnston
Subject Re: pg_total_relation_size shows 0 byt table has thousands of rows
Date
Msg-id CAKFQuwZ47g5Dg79kB9fF-Z6P-0R5kOtf81u_GiKD7wtVRX6GfA@mail.gmail.com
Whole thread Raw
In response to pg_total_relation_size shows 0 byt table has thousands of rows  (Sbob <sbob@quadratum-braccas.com>)
Responses Re: pg_total_relation_size shows 0 byt table has thousands of rows
List pgsql-admin
Tree view
On Thu, Apr 11, 2024 at 11:11 AM Sbob <sbob@quadratum-braccas.com> wrote:

I have a table that has 39,000 rows in it, but a
pg_total_relation_size('schema.table') shows a size of 0

I did a vacuum and an analyze but no change

Thoughts?


Copy and paste the exact queries you are running and the results they are giving.

David J.

pgsql-admin by date:

Previous
From: Sbob
Date:
Subject: pg_total_relation_size shows 0 byt table has thousands of rows
Next
From: Sbob
Date:
Subject: Re: pg_total_relation_size shows 0 byt table has thousands of rows