difference

balance.sql

SELECT 
    l.account_id, 
    sum(l.debit-l.credit) 
FROM account_move_line AS l 
INNER JOIN account_account AS a ON a.id = l.account_id 
WHERE l.debit-l.credit != 0  AND a.code ilike '1-1-08%'  //<<ug l
GROUP BY account_id
/*
Tiempo de ejecución de la sentencia: 11.56 segundos
*/

SELECT 
    l.account_id, 
    sum(l.debit-l.credit) 
FROM account_move_line AS l 
INNER JOIN account_account AS a ON a.id = l.account_id 
WHERE l.debit-l.credit != 0  AND a.parent_id = 462 // <<technically perfect and functionally perfect
GROUP BY account_id