Using FOREIGN TABLE to get the Size of the Actual Remote Table Behind it

From: Avi Weinberg <AviW(at)gilat(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Using FOREIGN TABLE to get the Size of the Actual Remote Table Behind it
Date: 2022-01-13 09:49:22
Message-ID: DB9PR07MB71809309FB4B5AD42E458C58CB539@DB9PR07MB7180.eurprd07.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Experts,

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.

Thanks!

IMPORTANT - This email and any attachments is intended for the above named addressee(s), and may contain information which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you should not copy or use this e-mail for any purpose nor disclose its contents to any person.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shaozhong SHI 2022-01-13 10:43:52 How can a Postgres SQL script be automatically run when a new table turns up?
Previous Message Peter Geoghegan 2022-01-12 23:44:53 Re: When Update balloons memory