Postgres Pro
Downloads
Home   >   mailing lists

Re: Using FOREIGN TABLE to get the Size of the Actual Remote Table Behind it - Mailing list pgsql-general

From Laurenz Albe
Subject Re: Using FOREIGN TABLE to get the Size of the Actual Remote Table Behind it
Date
Msg-id 4496811616006330d67b6c309b1028f20eb5b36c.camel@cybertec.at
Whole thread Raw
In response to Using FOREIGN TABLE to get the Size of the Actual Remote Table Behind it  (Avi Weinberg <AviW@gilat.com>)
List pgsql-general
Tree view 
On Thu, 2022-01-13 at 09:49 +0000, Avi Weinberg wrote:
> Is it possible to get the size of the table a foreign table is pointing to (without creating
> another connecting to the remote server)?  Obviously this "select
> pg_size_pretty(pg_total_relation_size('f_table'))" returns 0.

No, there is no straightforward way to do that.

What you could do is create a view on the remote database that provides the
required information and access that view via a foreign table.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com

pgsql-general by date:

Previous
From: Shaozhong SHI
Date:
Subject: Re: How can a Postgres SQL script be automatically run when a new table turns up?
Next
From: Gautam Bellary
Date:
Subject: Assistance with an out of shared memory error