PostgreSQL tips

Here are some tips to manipulate or inspect postgresql To know the size of your table # SELECT relname as table_name, pg_size_pretty(pg_total_relation_size(relid)) as total_size, pg_size_pretty(pg_relation_size(relid)) …