2018-06-20 18:35 GMT-03:00 DiasCosta <diascosta@xxxxxxxxxxxxx>:
>
> Hi all,
> can someone help me?
>
> I don't know if this is the correct list for this matter. If I'm wrong, please bear with me and point me in right direction.
>
> I have a large query which, largely after more than 24 hours running, doesn't come to an end;
> However I can see, using system tools, that the postgres process keeps, although slowly, reading and writing bytes and the "afinity" dedicated cores are at 6.25% .
>
> I tried https://www.depesz.com/ but the query was rejected.
>
Regards,
--
Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
>
> Hi all,
> can someone help me?
>
> I don't know if this is the correct list for this matter. If I'm wrong, please bear with me and point me in right direction.
>
Here is a good start...
> I have a large query which, largely after more than 24 hours running, doesn't come to an end;
> However I can see, using system tools, that the postgres process keeps, although slowly, reading and writing bytes and the "afinity" dedicated cores are at 6.25% .
>
> I tried https://www.depesz.com/ but the query was rejected.
>
Are you talking about http://explain.depesz.com ?? If yes you should copy and paste the EXPLAIN output of your query... If you don't do it yet, please do it and send to us the results .
And use some external service like pastebin.com to send long SQL statements.
Regards,
--
Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
