When using psql with PostgreSQL, we can use the \list+ command to return information about all databases on the server.

November 14, 2022 - Here is a script to get the size of all your PostgreSQL databases. SELECT d.datname AS Name, pg_catalog.pg_get_userbyid(d.datdba) AS Owner, CASE WHEN pg_catalog.has_database_privilege(d.datname, 'CONNECT') THEN pg_catalog.pg_size_pretty( pg_catalog.pg_database_size(d.datname) ) ELSE 'No Access' END AS SIZE FROM pg_catalog.pg_database d ORDER BY CASE WHEN pg_catalog.has_database_privilege(d.datname, 'CONNECT') THEN pg_catalog.pg_database_size(d.datname) ELSE NULL END DESC; Cheers!

April 21, 2024 - SELECT datname AS database_name, pg_size_pretty(pg_database_size(datname)) AS size, datallowconn AS allow_connections, datconnlimit AS connection_limit, encoding, datcollate, datctype FROM pg_catalog.pg_database; ... This query provides insights into the database’s configurations and settings. Beekeeper Studio lists all databases in a dropdown at the top of the interface, switch between databases at any time. ... In summary, list all the databases in psql using \l.

April 1, 2024 - List and sort your PostgreSQL databases by size while checking access permissions. A practical SQL snippet for database administrators managing storage.

tl;dr; SELECT pg_database.datname, pg_database_size(pg_database.datname), pg_size_pretty(pg_database_size(pg_database.datname)) FROM pg_database ORDER by 2 DESC;

November 30, 2011 - psql -c \"SELECT pg_database.datname, pg_database_size(pg_database.datname), pg_size_pretty(pg_database_size(pg_database.datname)) FROM pg_database ORDER BY pg_database_size DESC;\" -d - (List all databases in Postgres and their (byte/human) sizes, ordering by byte size descending Get a listing of all of your databases in Postgres and their sizes, ordering by the largest size first.

August 24, 2022 - In PostgreSQL, built-in functions like pg_database_size(), pg_relation_size(), and pg_total_relation_size() are used to get the database and table size. The pg_total_relation_size() function is used to fetch the total size of a relation including ...

April 30, 2026 - Last reviewed: April 30, 2026. ... psql -U [username] -c "SELECT datname, pg_size_pretty(pg_database_size(datname)) AS size FROM pg_database ORDER BY pg_database_size(datname) DESC;"

... he PG_DATABASE_SIZE() function, you must have CONNECT privilege on the specified database (which is granted by default) or be a member of the pg_read_all_stats role. If you’re using psql, you can run the \l+ command. ... List of databases +--------+----------+----------+-------------...

Once you’ve connected to a database, you will want to inspect which tables have been created there. This can be done with the \dt meta-command. However, if there are no tables you will get no output. ... After creating a table, it will be returned in a tabular list of created tables.

October 31, 2019 - 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 a database or all databases in the cluster with the help of the following scripts. Find the Size of a Database in PostgreSQL SELECT

| Task | Command | |------|---------| | List all databases (psql) | \l | | List with sizes (psql) | \l+ | | List matching a pattern (psql) | \l myapp* | | List from the shell | psql -l | | List via SQL | SELECT datname FROM pg_database | | Exclude template databases | Add WHERE datistemplate = false | | Check if a database exists | SELECT EXISTS (SELECT 1 FROM pg_database WHERE datname = 'name') | | Get database size | SELECT pg_size_pretty(pg_database_size('name')) | | Connect to a database | \c dbname |

Our platform offers a wide range of services that support websites and projects of all sizes. From your first visitor to your millionth, we have a plan for you. ... Trusted by over 700,000 customers to power 3,000,000+ websites! ... Tailored for creators, trusted by agencies and built to scale with enterprises.

April 15, 2025 - In PostgreSQL, viewing a list of ... DATABASES statement like MySQL. Instead, you can use the \l or \l+ commands in psql or query the pg_database view to display all databases....

3 weeks ago - You can use the psql command-line program to determine the sizes of PostgreSQL databases and tables. To do this, follow these steps: Log in to your account using SSH. At the command line, type the following command. Replace dbname with the name of the database, and username with the database username:

April 16, 2026 - If you want to get information about the sizes of the databases, default tablespaces, and descriptions use \l+ or \list+. The database size is shown only if the current user can connect to it.

February 5, 2025 - Use l+ or list+ to get additional information about each database, such as the size in Kb and its description: ... If the command line is not your thing, remember that you can also list databases in PostgreSQL by querying pg_catalog.pg_database.

🚀 New PostgresAI: monitoring, ... indexes, etc.). You can use meta-commands to get the size: \dt+ – list tables; \l+ - list databases; \di+ – list indexes; \dv+ – list views; \dm+ – list materialized views; other ...