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_ ... How do you find the disk size of a Postgres / PostgreSQL table ... list table sizes for all tables in a postgresql database How to list tables of specific database and sort them by size ... Другие результаты с сайта stackoverflow.com

19 февр. 2024 г. · You can use the pg_total_relation_size() function to find the size of the biggest tables including indexes. For example, the following query ...

This article demonstrates how to determine the size of PostgreSQL databases and tables. You can do this by using the psql command-line program.

Get the size of a table​. To get the table size, you can use either the \dt+ [ pattern ] command or the pg_table_size function.

5 нояб. 2018 г. · Query below returns tables in a database with space they use ordered from the ones using most. Do table names in your database always make sense?

This article will be looking at how to determine the size of PostgreSQL databases and tables using the psql command-line program.

20 окт. 2022 г. · This will report size information for all tables, that are not inherited, in the "pretty" form. Inherited tables are grouped together.

You can use meta-commands to get the size: \dt+ – list tables;; \l+ - list databases;; \di+ – list indexes;; \dv+ – list views;; \dm+ – list materialized views; ...

23 февр. 2023 г. · In this article, we will focus on the topic of table size in the PostgreSQL database environment. We will cover the three major components that make up a table.

2 нояб. 2022 г. · Use the pg_size_pretty() with the pg_relation_size() function to get the table size in user-friendly formats, such as KBs, MBs, etc.