You can translate the question and the replies:

Audit List of query execution time is more than 800Sec

Hi Team, Could you please share the query or steps to take Audit list of query execution time is more than 800Sec
User
13-01-2020 08:35:03 -0500

1 Answer

Hi, For auditing, I use the [Denodo Monitor](https://community.denodo.com/kb/view/document/Denodo%20Monitor%20timings?category=Performance+%26+Optimization) tool, which is a command-line based utility that logs information about Denodo Platform servers. "vdp-queries.log" contains information about queries' durations in milliseconds. To get the list of queries that took longer than 800 seconds (800,000 milliseconds), I would do it one of these ways: * Create a [delimited data source](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/delimited_file_sources/delimited_file_sources) over "vdp-queries.log" and then a view. Then, execute a query such that it has a filter on "duration" column. * Alternatively, the Denodo Monitor logs can be used with [Diagnostic & Monitoring Tool](https://community.denodo.com/docs/html/browse/latest/vdp/dmt/introduction/introduction). To achieve your scenario, I would create first create a [diagnostic](https://community.denodo.com/docs/html/browse/latest/vdp/dmt/creating_diagnostics_and_diagnostic_intervals/creating_diagnostics/creating_diagnostics), and then in the diagnostic's ["Requests"](https://community.denodo.com/docs/html/browse/7.0/vdp/dmt/monitoring/monitoring_servers/monitoring_requests) tab, add the "Duration" column and specify a filter such that it returns log information where the duration of the query is greater than 800 seconds. * Lastly, if you are a valid Support user, you can use [Denodo Monitor Reports](https://community.denodo.com/docs/html/document/denodoconnects/7.0/Denodo%20Monitor%20Reports%20-%20User%20Manual) which can be downloaded from the DenodoConnects section of the [Support Site](https://support.denodo.com/). This is a web application that generates graphical reports based on the Denodo Monitor logs. These reports also return information on queries' durations. Hope this helps!
Denodo Team
13-01-2020 21:19:38 -0500
You must sign in to add an answer. If you do not have an account, you can register here