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.

Thanks Pierrie.

I think you have implemented the query history functionality. Completed queries profiling is done in MonetDB with query_history, query_catalog and query_calls tables. The time taken for query execution is also recorded in those tables.

What I wish to see is the list of queries that are currently running with the server. As per the documentation, this was with the sys.queue table, which I don't get quite.

Not sure what am missing from this straight forward solution.

Thanks & Regards,

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

On Wed, Mar 30, 2016 at 8:13 PM, Pierre-Adrien Coustillas < pcoustillas@1g6.biz> wrote:

Hi,

sys.queue we should not either. We write all requests into a text file upon execution and write the execution time soon end.

Except monetdb crash (almost never) this solution works perfectly.

Pierre

---

*De: *"Vijay Krishna" vijayakrishna55@gmail.com *À: *"Communication channel for MonetDB users" users-list@monetdb.org *Envoyé: *Mercredi 30 Mars 2016 09:19:07 *Objet: *Re: Find all running processes?

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.

---

users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

---

users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list