def get_max_mxid_age()

in postgresql_metrics/postgres_queries.py [0:0]

• 10 lines of code
• 4 McCabe index (conditional complexity)

def get_max_mxid_age(conn):
    # `mxid_age` is only available on postgres 9.5 and newer
    if conn.server_version < 95000:
        LOG.error("Unable to check mxid_age on versions of postgres below 9.5")
        return None
    sql = "SELECT max(mxid_age(relminmxid)) FROM pg_class WHERE relminmxid <> '0'"
    results = query(conn, sql)
    if not results:
        return None
    mxid_age, = results[0]
    return int(mxid_age)