Breaking News: Grepper is joining You.com. Read the official announcement!
Check it out

How to get the disk size of a Postgresql database

David Cao answered on February 9, 2021 Popularity 6/10 Helpfulness 10/10

Contents


More Related Answers

  • show size of all tables postgres
  • postgres check size table
  • get size of indexes postgres
  • Postgres size: db size, table size
  • pg_database_size
  • postgres database sizes
  • get the space occupied by db postgresql
  • postgresql check total storage
  • Postgres size: column size
  • postgresql size of database
  • find size of all DB's postgres
  • Psql Databases size
  • text size in postgresql
  • sql string length postgresql
  • how much table store postgres
  • sql - how to find the json size stored in a column of postgres

  • How to get the disk size of a Postgresql database

    2

    SELECT datname AS dbname, pg_database_size(datname) AS size, pg_size_pretty(pg_database_size(datname)) AS size_pretty

    FROM pg_database

    ORDER BY size DESC; 

    Popularity 6/10 Helpfulness 10/10 Language sql
    Link to this answer
    Share Copy Link
    Contributed on Apr 24 2023
    David Cao
    0 Answers  Avg Quality 2/10

    Closely Related Answers



    9
    Popularity 10/10 Helpfulness 10/10 Language sql
    Link to this answer
    Share Copy Link
    Contributed on Feb 09 2021
    Cloudy Caiman
    0 Answers  Avg Quality 2/10


    X

    Continue with Google

    By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.
    X
    Grepper Account Login Required

    Oops, You will need to install Grepper and log-in to perform this action.