Re: pg_total_relation_size shows 0 byt table has thousands of rows

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Sbob <sbob(at)quadratum-braccas(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: pg_total_relation_size shows 0 byt table has thousands of rows
Date: 2024-04-11 18:30:11
Message-ID: CAKFQuwZ47g5Dg79kB9fF-Z6P-0R5kOtf81u_GiKD7wtVRX6GfA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, Apr 11, 2024 at 11:11 AM Sbob <sbob(at)quadratum-braccas(dot)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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sbob 2024-04-11 19:22:12 Re: pg_total_relation_size shows 0 byt table has thousands of rows
Previous Message Sbob 2024-04-11 18:10:55 pg_total_relation_size shows 0 byt table has thousands of rows