Re: SQL Query never ending...

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