def METHOD_NAME(self, conn):
    """
    returns the total size of indexes for the pyiron job table
    """
    stmt = """
        SELECT
            t.schemaname,
            t.tablename,
            c.reltuples::bigint                            AS num_rows,
            pg_size_pretty(pg_relation_size(c.oid))        AS table_size,
            psai.indexrelname                              AS index_name,
            pg_size_pretty(pg_relation_size(i.indexrelid)) AS index_size,
            CASE WHEN i.indisunique THEN 'Y' ELSE 'N' END  AS "unique",
            psai.idx_scan                                  AS number_of_scans,
            psai.idx_tup_read                              AS tuples_read,
            psai.idx_tup_fetch                             AS tuples_fetched
        FROM
            pg_tables t
            LEFT JOIN pg_class c ON t.tablename = c.relname
            LEFT JOIN pg_index i ON c.oid = i.indrelid
            LEFT JOIN pg_stat_all_indexes psai ON i.indexrelid = psai.indexrelid
        WHERE
            t.schemaname NOT IN ('pg_catalog', 'information_schema')
        ORDER BY 1, 2;        
        """
    rows = conn.execute(stmt).fetchall()
    index_usage = 0
    for row in rows:
        if row[1] == self._job_table:
            index_usage += int(str(row[5]).split(" ")[0])
    return {"index size/usage (MB)": index_usage}