Hi,

I am still unable to find a way to see all running queries in MonetDB. Still getting the same output for sys.queue as in the previous mail (in this thread). 

Similar to logging, is it like I should enable something to get results from queue also? 

Clearly am missing something. Can someone please help me with this? 




Thanks & Regards,

Vijayakrishna.P.
Mobile : (+91) 9500402305.

On Thu, Aug 13, 2015 at 11:13 AM, Vijay Krishna <vijayakrishna55@gmail.com> wrote:
How to find all running processes and their statuses in MonetDB?? 

I found this...
https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/monitor

But I couldn't get this work... I ran a query (which took some 20 seconds to complete) in a window and connected the same database in another terminal and ran "select * from sys.queue" (several times during those 20 seconds) but I could get only this... 

sql>select * from sys.queue;

+-------+---------+----------------------------+----------------------------+----------+---------+------------+--------------------------+

| qtag  | user    | started                    | estimate                   | progress | status  | tag        | query                    |

+=======+=========+============================+============================+==========+=========+============+==========================+

| 27339 | monetdb | 2015-08-13 05:35:40.000000 | null                       |     null | running | 12532134@0 | select * from sys.queue; |

+-------+---------+----------------------------+----------------------------+----------+---------+------------+--------------------------+

I am using Oct-2014 version of monetdb on CentOS... 

Is there a way to find all running processes and their statuses in MonetDB?? 

Thanks & Regards,

Vijayakrishna.P.
Mobile : (+91) 9500402305.