Search
 
SCRIPT & CODE EXAMPLE
 

SQL

show size of all tables postgres

select table_name, pg_relation_size(quote_ident(table_name))
from information_schema.tables
where table_schema = 'public'
order by 2
Comment

PREVIOUS NEXT
Code Example
Sql :: sql ignore accents 
Sql :: freemysqlhosting keeps deleting tables 
Sql :: postgresql server restart 
Sql :: sql change column types 
Sql :: oracle sql limit results 
Sql :: check database name oracle 
Sql :: mysql force query to use index 
Sql :: show tables sql server 
Sql :: mysql list databases 
Sql :: postgresql list extensions 
Sql :: string to int mysql 
Sql :: mysql group by month 
Sql :: postgresql Insufficient privilege: 7 ERROR: permission denied for table 
Sql :: mysql print variable 
Sql :: mysql update part of string 
Sql :: sql add date hour 
Sql :: postgres delete from where date is greater than specific date 
Sql :: ms sql rename database 
Sql :: mysql group by day 
Sql :: oracle show running job 
Sql :: tsql update datetime 
Sql :: cast to date bigquery 
Sql :: how to add a index to live table sql 
Sql :: how to get non distinct values in sql 
Sql :: sql exclude duplicates and find even id 
Sql :: oracle alter sequence restart start with 
Sql :: oracle list invalid password logon denied 
Sql :: mysql date between two dates 
Sql :: sql set auto increment back to 0 
Sql :: dual table in aql 
ADD CONTENT
Topic
Content
Source link
Name
4+4 =