def get_table_bloat()

in postgresql_metrics/postgres_queries.py [0:0]

• 7 lines of code
• 2 McCabe index (conditional complexity)

def get_table_bloat(conn, table_oid):
    """Based on extension pgstattuple, so you need to call CREATE EXTENSION before using this.
    Check the function get_tables_with_oids_for_current_db to see how to get table oids.
    """
    results = query(conn, "SELECT current_database, dead_tuple_percent "
                          "FROM pgstattuple_for_table_oid(%s)", [table_oid])
    if results:
        db_name, dead_tuple_percent = results[0]
        return db_name, dead_tuple_percent / 100.0
    return None, None