Table sizes (Postgres)

• Snippet
• SQL
• Ready to copy

SELECT relname, pg_size_pretty(pg_total_relation_size(relid))
FROM pg_catalog.pg_statio_user_tables
ORDER BY pg_total_relation_size(relid) DESC;

About this template

Largest tables.

Category

Code snippets

Pack

SQL

Type

Snippet, a short message

Asks for

Nothing, copy it as it is

Use it anywhere you write: email, chat, a document or a support tool. If you send it often, save the finished text as a snippet in ClipBuddy and paste it again from your clipboard history with ⌘⇧V.

SELECT relname, pg_size_pretty(pg_total_relation_size(relid))
FROM pg_catalog.pg_statio_user_tables
ORDER BY pg_total_relation_size(relid) DESC;

More code snippets templates

• Select with filter Snippet Basic query.
• Count by group Snippet Group and count.
• Find duplicates Snippet Rows appearing more than once.
• Inner join Snippet Join two tables.
• Left join missing rows Snippet Rows with no match.
• Last N days Snippet Recent rows.

See all 268 code snippets templates