in src/api/websites/db.ts [80:87]
export async function retrieveWebsiteTotal(
conn: DbConnectionType,
): Promise<number> {
const res = await conn.query<{ total_count: string }>(
SQL`SELECT COUNT(distinct url) as total_count FROM lighthouse_audits`,
);
return +res.rows[0].total_count;
}