2018-06-20 18:35 GMT-03:00 DiasCosta <diascosta@diascosta.org>: > > 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