Node.js - PostgreSQL - check database size

In this article, we would like to show you how to check Postgres database size in Node.js.

const { Client } = require('pg');

const client = new Client({
    host: '127.0.0.1',
    user: 'postgres',
    password: 'password',
    port: 5432,
});

const getDatabaseSize = async (databaseName) => {
    const query = `SELECT pg_size_pretty(pg_database_size($1));`;
    try {
        await client.connect(); // gets connection
        const { rows } = await client.query(query, [databaseName]); // sends query
        console.log(rows);
    } catch (error) {
        console.error(error.stack);
        return false;
    } finally {
        await client.end();     // closes connection
    }
};

getDatabaseSize('database_name');

Result: 

[ { pg_size_pretty: '8245 kB' } ]