Hi Wei,
You can use the Virtuoso query profile command which provide the query
compilation and execution time as detailed at:
http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtTipsAndTricksAanalyzingSPARQLQuery
<http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtTipsAndTricksAanalyzingSPARQLQuery>
Virtuoso server side query logging can also be enabled which provides any
number of query metrics including compile and execution time as detailed at:
http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#querylogging
<http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#querylogging>
I hope this helps …
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
> On 7 Sep 2015, at 23:21, Wei Zhang <[email protected]> wrote:
>
> Can anyone help?
> I want to get the estimated execution time by command…
>
> Thank you very much for your time.
>
> Best Regards,
> Wei Zhang
>
> From: Wei Zhang [mailto:[email protected]]
> Sent: Monday, 7 September 2015 5:30 PM
> To: [email protected]
> Subject: [Virtuoso-users] How to get estimated execution time from Virtuoso?
> 'explain' can only give compile time?
>
> Dear All,
>
> I have a question regarding to get estimated query execution time from
> Virtuoso.
> Most the posts I have searched out regard to setting the upper limit of
> execution time in configuration file.
>
> But I want to get the estimated time from Virtuoso directly rather than from
> the error line such as “The estimated execution time AAA (sec) exceeds the
> limit of BBB (sec)”
>
> I found ‘explain’ function can give a time
> (http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#perfdiagqueryplans
> <http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#perfdiagqueryplans>),
> but it is the compilation time according to
> https://www.mail-archive.com/[email protected]/msg05857.html
>
> <https://www.mail-archive.com/[email protected]/msg05857.html>
> I am wondering how the server get the estimated time? Can we get it directly?
>
> Sorry for my question if it is too simple …, could you help me?
>
> Thank you very much for your time.
> Vivian
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Virtuoso-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
_______________________________________________
Virtuoso-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/virtuoso-users