I'm running the following query over a database of 1,000,000,000 items.
insert into date_aggregate (count, a, date) select count(date) as count, a, date, from input group by date, a order by date;
I expect it to take a certain length of time, but I have no way of knowing how long.
The system queue table has a 'null' estimate. All I know from that table is that the query is running. Is there a way to get any more information about its progress?
I would be happy to just wait, but I don't know if I should be waiting for hours or days or weeks. The monetdbd process is only using 14% CPU (on a 6 core machine) and 14% RAM (the machine has 7GB and lots of SSD swap). My machine is basically idling when I want it to run as fast as possible. Running Jan2014-SP2, 64-bit on Ubuntu 14.04.
Any hints about measuring progress and improving resource utilisation?
Joe