Script to poll the home assistant database running on PostgreSQL. The only requirement is psycopg2. (The script doesn't do any error/exception handling)

getdbsize.py

import psycopg2

# The name of the home assistant database
DB = "<DBNAME>"
# The user to connect to your home assistant database
DBUSER = "<DBUSER>"
# The IP/hostname of the PostgreSQL server
DBHOST = "<DBHOST>"
# The password for the user
DBPASSWORD = "<DBPASSWORD>"

props = "dbname='{}' user='{}' host='{}' password='{}'".format(DB, DBUSER, DBHOST, DBPASSWORD)

conn = psycopg2.connect(props)

cur = conn.cursor()

sizecmd = "select pg_database_size('{}');".format(DB)

cur.execute(sizecmd)

rows = cur.fetchall()
print (rows[0][0])