Almir ==== On 01/07/2016 05:15 PM, Marc Mamin wrote:
P {margin-top:0;margin-bottom:0;}
>I ask your help to solve a slow query which is taking more than 14 seconds to be executed. >Maybe I am asking too much both from you and specially from postgresql, as it is really huge, envolving 16 tables. > >Explain: >http://explain.depesz.com/s/XII9 > >Schema: >http://adj.com.br/erp/data_schema/
ADJ Tecnologia da Informação Diretor Tel: +55 (21) 3079-4128 Cel: +55 (21) 99362-7627 Skype: almir.duarte.jr Email: almirjr@adj.com.br Rua São José, 90 - sala 613 - Centro Rio de Janeiro - RJ - CEP: 20.010-901