20 сент. 2013 г. · I am able to find the size of a specific database by using following command: select pg_database_size('databaseName'); sql. postgresql.

12 февр. 2014 г. · This will show you the schema name, table name, size pretty and size (needed for sort). SELECT schema_name, relname, pg_size_pretty(table_size) AS size, table_ ...

25 янв. 2022 г. · The size of database and table in postgres can be found using following command. To get the databse size: SELECT pg_size_pretty( pg_database_size('dbname') );

12 апр. 2019 г. · Why does PostgreSQL occupy so much more storage than MySQL? And is there some way of significantly reducing it near to the MySQL level?

11 дек. 2010 г. · I'm looking for a query that returns a result of the form for any database (see example below supposing total space used by the database is 40GB)

24 июн. 2017 г. · PostgreSQL is designed for client-server architecture and 1GB and longer databases - so this cost is not significant.

23 нояб. 2020 г. · One database's size is 23 GB and when I ran below query to get sum of size of all individual tables in this particular database, it was around 8 GB.

30 мар. 2022 г. · I have a relatively small database (less than ~300 rows total) but it takes up more than 150 MB of storage. It grew to this from ~11 MB without much addition ...

22 окт. 2013 г. · You can use pg_total_relation_size() to get actual usage by table, or pg_database_size(name) to get usage by whole database.

12 апр. 2021 г. · Looking at the sum size of my schemas for this database, it only takes up 126 GB, which is 42%. SELECT pg_size_pretty(sum(total_size)::bigint) as "total"