How to find size of Database and Table in PostgreSQL

In this post, I show you some important script to find size of database , table and index.


Script 1 : Find a total size of the database.

Script 2: Find a total size of the table with an index.

Script 3: Find a total size of the table without an index.

Script 4: Find a total size of the index.

Script 5: Find a total number of rows in a table.

Script 6 : Find all the table size in the current database.

Script 7 : Find all the table and index size in the current database.

Other Related Articles:

PostgreSQL XML Type:

PostgreSQL Cross Database Query:

PostgreSQL Custom Paging using LIMIT and OFFSET

 

Anvesh Patel

Leave a Reply

3 Comments on "How to find size of Database and Table in PostgreSQL"

Notify of
avatar
Sort by:   newest | oldest | most voted
a/c Repair Moorpark
Guest

Hey very interesting blog!

Sourav
Guest

Nice Post

wpDiscuz