How to find the size of a table in SQL?


How to find the size of a table in SQL?

As a SQL developer or database administrator, it is essential to have a good understanding of the size of your database tables. Knowing the size of a table can help you optimize your database performance, plan for storage requirements, and troubleshoot issues related to database performance. In this blog post, we will guide you through the process of finding the size of a table in SQL.

Here’s how you can see the size table sizes for public schema

SELECT
	table_name,
	pg_size_pretty(pg_relation_size(quote_ident(table_name))),
	pg_relation_size(quote_ident(table_name))
FROM
	information_schema.tables
WHERE
	table_schema = 'public'
ORDER BY
	3 DESC;

See sizes of tables of all schemas:

SELECT
	schema_name,
	relname,
	pg_size_pretty(table_size) AS size,
	table_size
FROM (
	SELECT
		pg_catalog.pg_namespace.nspname AS schema_name,
		relname,
		pg_relation_size(pg_catalog.pg_class.oid) AS table_size
	FROM
		pg_catalog.pg_class
		JOIN pg_catalog.pg_namespace ON relnamespace = pg_catalog.pg_namespace.oid) t
WHERE
	schema_name NOT LIKE 'pg_%'
ORDER BY
	table_size DESC;

Newsletter


Related Posts

Deal with client requests in SaaS

How to deal with client requests in Saas which are seeing only their interests, not the product interest.

The first client of LoyalXpert is not answering anymore

Trying to implement LoyalXpert app, I lost my first customer, he's not answering anymore

Experiments with Tiktok Ads

Recently tried out TikTok ads for the first time and here are some of my learnings and challenges

People don’t care about you, until they know you care about them.

People don’t care about you, until they know you care about them. The same happens in business, you need to take care of your clients.

The One Word That Can Ruin Your SaaS Business Anyone

As a SaaS founder, you probably know how important it is to have a clear and specific target market for your product.

How I got my digital certificate connected it with ANAF

How I got my digital certificate from certSIGN and connected it with ANAF

The Ultimate List of Company Directories to Boost Your Networking

Discover a wide range of company directories to boost your business's visibility and connect with potential clients.

Discover the Best Free AI Art Tools for Your Next Masterpiece

Explore a curated collection of the finest free AI art tools, designed to help you bring your artistic vision to life.

SaaS vs. Software Agency

Discover the key differences between SaaS and Software Agencies to make informed business decisions and stay ahead in the competitive market.

Top ChatGPT Prompts for Technical People and Startup Founders

Discover the ultimate list of ChatGPT prompts designed specifically for technical people and startup founders. Enhance your AI interactions and boost productivity with these powerful prompts. Revolutionize the way you work and stay ahead of the competition. Read now!