You can translate the question and the replies:

How to fetch execution time for Denodo query by python

Hi team, Do we have some way about how to fetch execution time for Denodo query by python script? Or do we have some pre-defined store procedure can be used for this property, we have the requirement to auto-collect the query running time. Thanks.
user
16-06-2021 05:46:08 -0400

1 Answer

Hi, In order to get the Execution time of queries executed in the Virtual DataPort server using a python script, I would perform the following steps: * If I have Denodo Monitor configured, I would use the **vdp-queries.log** to create a new [Delimited data source ](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/delimited_file_sources/delimited_file_sources#delimited-file-sources)in the Virtual Dataport Administration Tool and create a base view over the new source. * I would then execute the newly created view using the Python script with a where condition on the **Query** column to get the execution start and end time of one specific query. You can take a look at the[ Denodo Monitor](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/monitoring_the_virtual_dataport_server/denodo_monitor/denodo_monitor#denodo-monitor) section of the Virtual DataPort Administration Guide for more information on how to configure a Denodo Monitor and the list of logs generated by the Denodo Monitor Hope this helps!
Denodo Team
16-06-2021 08:24:13 -0400
You must sign in to add an answer. If you do not have an account, you can register here