On Thu, Mar 17, 2016 at 4:45 PM, Karsten Hilbert
wrote:
> On Fri, Mar 18, 2016 at 09:38:30AM +1300, drum.lu...@gmail.com wrote:
>
> > Can you please provide me a Query that tells me how much space is a
> Schema
> > in my DB?
>
> There's been a discussion on that recently (like last month)
> which
On Fri, Mar 18, 2016 at 09:38:30AM +1300, drum.lu...@gmail.com wrote:
> Can you please provide me a Query that tells me how much space is a Schema
> in my DB?
There's been a discussion on that recently (like last month)
which can be found in the archive.
Karsten
--
GPG key ID E4071346 @ eu.pool
Hi all,
Can you please provide me a Query that tells me how much space is a Schema
in my DB?
I'm using one but don't think it's right
>
> SELECT schema_name,
>pg_size_pretty(sum(table_size)::bigint),
>(sum(table_size) / pg_database_size(current_database())) * 100 as a
> FROM
