@puniko @privateger take a look at htop, on the io tab you should see how much io it does
Then you need to know how big the table is which the querry runs on... On psql you can query the size somehow
Then you can like estimate how long it should take and substract the time which its aleady used