Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] Determine size of table before it's committed? - Mailing list pgsql-general

From Seamus Abshere
Subject [GENERAL] Determine size of table before it's committed?
Date
Msg-id 1507729406.764821.1135247016.257044EA@webmail.messagingengine.com
Whole thread Raw
Responses Re: [GENERAL] Determine size of table before it's committed?  (Justin Pryzby <pryzby@telsasoft.com>)
Re: [GENERAL] Determine size of table before it's committed?  (Melvin Davidson <melvin6925@gmail.com>)
List pgsql-general
Tree view 
hi,

I've had an `INSERT INTO x SELECT FROM [...]` query running for more
then 2 days.

Is there a way to see how big x has gotten? Even a very rough estimate
(off by a gigabyte) would be fine.

Best,
Seamus


--
Seamus Abshere, SCEA
https://www.faraday.io
https://github.com/seamusabshere
https://linkedin.com/in/seamusabshere


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Simon Riggs
Date:
Subject: Re: [GENERAL] startup process stuck in recovery
Next
From: Justin Pryzby
Date:
Subject: Re: [GENERAL] Determine size of table before it's committed?