{"id":133,"date":"2018-06-03T22:23:01","date_gmt":"2018-06-03T22:23:01","guid":{"rendered":"http:\/\/dbtut.com\/?p=133"},"modified":"2019-10-31T14:25:06","modified_gmt":"2019-10-31T14:25:06","slug":"how-to-find-the-size-of-all-databases-in-postgresql","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/06\/03\/how-to-find-the-size-of-all-databases-in-postgresql\/","title":{"rendered":"How to Find The Size of all Databases in PostgreSQL"},"content":{"rendered":"

In Postgres you could be managing many databases on a Cluster.<\/p>\n

In some cases you may need to query the size all of these databases.<\/p>\n

You can query the size of\u00a0 a database or all databases in the cluster with the help of the following scripts.<\/p>\n

Find the Size of a Database in PostgreSQL<\/h2>\n
SELECT pg_database.datname as \"databasename\", \npg_database_size(pg_database.datname)\/1024\/1024\/1024 AS sizegb \nFROM pg_database ORDER by pg_database_size(pg_database.datname) DESC;<\/pre>\n
\"\"<\/p>\n
Find the Size of all Databases in PostgreSQL<\/h2>\n
SELECT pg_database.datname as \"databasename\", \npg_database_size(pg_database.datname)\/1024\/1024\/1024 AS sizegb \nFROM pg_database\nWHERE pg_database.datname='Test'\nORDER by pg_database_size(pg_database.datname) DESC;<\/pre>\n
\"\"<\/p>\n
If you want to list the the size of tables in postgresql, you should read the following article.<\/p>\n
“How To Find the Size of Tables and Indexes in PostgreSQL<\/a>”<\/p>\n\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
In Postgres you could be managing many databases on a Cluster. In some cases you may need to query the size all of these databases. You can query the size of\u00a0 a database or all databases in the cluster with the help of the following scripts. Find the Size of a Database in PostgreSQL SELECT …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"featured_media":11032,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[5],"tags":[60,61,2839,2841,2840,2855,2851,2842,2843,63,62,5091,5092,2845,5130,5090,5129,5127,5094,5128,5126,2854,5093,2847,2846,2849,2852,2850,59],"class_list":["post-133","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-postgres","tag-all-databases-size","tag-database-size","tag-find-the-size-of-a-database","tag-find-the-size-of-a-database-in-postgresql","tag-find-the-size-of-all-database-in-postgresql","tag-find-the-size-of-all-databases","tag-finding-the-size-of-a-postgres-database","tag-how-do-i-find-the-size-of-a-postgresql-database","tag-how-do-i-list-all-databases-in-postgresql","tag-pg_database","tag-pg_database_size","tag-postgres-database-size","tag-postgres-db-size","tag-postgres-db-size-command","tag-postgresql-all-database-size","tag-postgresql-database-size","tag-postgresql-database-size-command","tag-postgresql-database-size-query","tag-postgresql-database-size-sql","tag-postgresql-database-sizes","tag-postgresql-get-database-size","tag-postgresql-how-to-see-database-size","tag-postgresql-size-check","tag-query-the-size-of-postgres-database","tag-query-the-size-of-postgresql-database","tag-show-size-of-all-databases","tag-show-size-of-every-postgresql-database","tag-show-size-of-postgres-database","tag-size-of-databases"],"aioseo_notices":[],"yoast_head":"\nHow to Find The Size of all Databases in PostgreSQL - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How to Find The Size of all Databases in PostgreSQL\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/06\/03\/how-to-find-the-size-of-all-databases-in-postgresql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Find The Size of all Databases in PostgreSQL - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How to Find The Size of all Databases in PostgreSQL\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/06\/03\/how-to-find-the-size-of-all-databases-in-postgresql\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-03T22:23:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-10-31T14:25:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-4.png\" \/>\n\t<meta property=\"og:image:width\" content=\"608\" \/>\n\t<meta property=\"og:image:height\" content=\"395\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/03\/how-to-find-the-size-of-all-databases-in-postgresql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/03\/how-to-find-the-size-of-all-databases-in-postgresql\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How to Find The Size of all Databases in PostgreSQL\",\"datePublished\":\"2018-06-03T22:23:01+00:00\",\"dateModified\":\"2019-10-31T14:25:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/03\/how-to-find-the-size-of-all-databases-in-postgresql\/\"},\"wordCount\":104,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/03\/how-to-find-the-size-of-all-databases-in-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-4.png\",\"keywords\":[\"all databases size\",\"database size\",\"Find the Size of a Database\",\"Find the Size of a Database in postgresql\",\"Find the Size of all Database in postgresql\",\"Find the Size of all Databases\",\"Finding the size of a Postgres database\",\"How do I find the size of a postgresql database\",\"How do I list all databases in PostgreSQL?\",\"pg_database\",\"pg_database_size\",\"postgres database size\",\"postgres db size\",\"postgres db size command\",\"postgresql all database size\",\"postgresql database size\",\"postgresql database size command\",\"postgresql database size query\",\"postgresql database size sql\",\"postgresql database sizes\",\"postgresql get database size\",\"postgresql how to see database size\",\"postgresql size check\",\"query the size of postgres database\",\"query the size of postgresql database\",\"show size of all databases\",\"Show size of every PostgreSQL database\",\"show size of postgres database\",\"size of databases\"],\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/06\/03\/how-to-find-the-size-of-all-databases-in-postgresql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/03\/how-to-find-the-size-of-all-databases-in-postgresql\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/03\/how-to-find-the-size-of-all-databases-in-postgresql\/\",\"name\":\"How to Find The Size of all Databases in PostgreSQL - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/03\/how-to-find-the-size-of-all-databases-in-postgresql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/03\/how-to-find-the-size-of-all-databases-in-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-4.png\",\"datePublished\":\"2018-06-03T22:23:01+00:00\",\"dateModified\":\"2019-10-31T14:25:06+00:00\",\"description\":\"How to Find The Size of all Databases in PostgreSQL\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/03\/how-to-find-the-size-of-all-databases-in-postgresql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/06\/03\/how-to-find-the-size-of-all-databases-in-postgresql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/03\/how-to-find-the-size-of-all-databases-in-postgresql\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-4.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-4.png\",\"width\":608,\"height\":395},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/03\/how-to-find-the-size-of-all-databases-in-postgresql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Find The Size of all Databases in PostgreSQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Find The Size of all Databases in PostgreSQL - Database Tutorials","description":"How to Find The Size of all Databases in PostgreSQL","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2018\/06\/03\/how-to-find-the-size-of-all-databases-in-postgresql\/","og_locale":"en_US","og_type":"article","og_title":"How to Find The Size of all Databases in PostgreSQL - Database Tutorials","og_description":"How to Find The Size of all Databases in PostgreSQL","og_url":"https:\/\/dbtut.com\/index.php\/2018\/06\/03\/how-to-find-the-size-of-all-databases-in-postgresql\/","og_site_name":"Database Tutorials","article_published_time":"2018-06-03T22:23:01+00:00","article_modified_time":"2019-10-31T14:25:06+00:00","og_image":[{"width":608,"height":395,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-4.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/03\/how-to-find-the-size-of-all-databases-in-postgresql\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/03\/how-to-find-the-size-of-all-databases-in-postgresql\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How to Find The Size of all Databases in PostgreSQL","datePublished":"2018-06-03T22:23:01+00:00","dateModified":"2019-10-31T14:25:06+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/03\/how-to-find-the-size-of-all-databases-in-postgresql\/"},"wordCount":104,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/03\/how-to-find-the-size-of-all-databases-in-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-4.png","keywords":["all databases size","database size","Find the Size of a Database","Find the Size of a Database in postgresql","Find the Size of all Database in postgresql","Find the Size of all Databases","Finding the size of a Postgres database","How do I find the size of a postgresql database","How do I list all databases in PostgreSQL?","pg_database","pg_database_size","postgres database size","postgres db size","postgres db size command","postgresql all database size","postgresql database size","postgresql database size command","postgresql database size query","postgresql database size sql","postgresql database sizes","postgresql get database size","postgresql how to see database size","postgresql size check","query the size of postgres database","query the size of postgresql database","show size of all databases","Show size of every PostgreSQL database","show size of postgres database","size of databases"],"articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/06\/03\/how-to-find-the-size-of-all-databases-in-postgresql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/03\/how-to-find-the-size-of-all-databases-in-postgresql\/","url":"https:\/\/dbtut.com\/index.php\/2018\/06\/03\/how-to-find-the-size-of-all-databases-in-postgresql\/","name":"How to Find The Size of all Databases in PostgreSQL - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/03\/how-to-find-the-size-of-all-databases-in-postgresql\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/03\/how-to-find-the-size-of-all-databases-in-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-4.png","datePublished":"2018-06-03T22:23:01+00:00","dateModified":"2019-10-31T14:25:06+00:00","description":"How to Find The Size of all Databases in PostgreSQL","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/03\/how-to-find-the-size-of-all-databases-in-postgresql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/06\/03\/how-to-find-the-size-of-all-databases-in-postgresql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/03\/how-to-find-the-size-of-all-databases-in-postgresql\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-4.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-4.png","width":608,"height":395},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/03\/how-to-find-the-size-of-all-databases-in-postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How to Find The Size of all Databases in PostgreSQL"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/133","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=133"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/133\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/11032"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=133"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=133"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=133"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}