postgresql find biggest table
Solutions on MaxInterview for postgresql find biggest table by the best coders in the world
{{#items}}
{{text}}
{{/items}} {{ctaText}}
{{#items}} {{/items}}
showing results for - "postgresql find biggest table"
Michelle
30 Jan 2018
1select schemaname as table_schema,
2 relname as table_name,
3 pg_size_pretty(pg_total_relation_size(relid)) as total_size,
4 pg_size_pretty(pg_relation_size(relid)) as data_size,
5 pg_size_pretty(pg_total_relation_size(relid) - pg_relation_size(relid))
6 as external_size
7from pg_catalog.pg_statio_user_tables
8order by pg_total_relation_size(relid) desc,
9 pg_relation_size(relid) desc
10limit 10;
11similar questions
show size of all tables postgrespostgresql select fast check no rowshow to get table id sequence postgrespostgresql last 12 rowspostgres select max valuesql string length postgresqlpostgres list tables and row countshow to find database collation in postgrespostgres set sequence value to max idpsql get last rowshow to get the size of the database in postgresqlfind size of all db 27s postgresstring length sql postgresqlpostgres base sizepostgresql get last 10 recordspostgres database sizespostgres count string lengthsetval max id postgresql sequencepostgresql limitcheck current sequence value postgresreset postgres table index to next max valueincrease speed of like queries postgrespostgres get size of databaseshow details of table postgres your answer for
you will get a confirmation link on this - you will have to click that for successful submission of your answer. we require this to keep the website free of spam, bots and unhelpful content
please ensure to add code which is syntactically corrent and executes properly
ask question on maxinterview
you will get a confirmation link on this - you will have to click that for successful submission of your question. we require this to keep the website free of spam, bots and unhelpful content
please be clear, to the point and respectful