# Can I get query execution metadata?
**URL:** https://community.dremio.com/t/can-i-get-query-execution-metadata/6812
**Category:** Uncategorized
**Created:** [January 7, 2021, 10:09am UTC](https://community.dremio.com/t/can-i-get-query-execution-metadata/6812 "2021-01-07T10:09:50Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@dmitrij.a](https://community.dremio.com/u/dmitrij.a)
#### Post date: [January 7, 2021, 10:09am UTC](https://community.dremio.com/t/can-i-get-query-execution-metadata/6812/1 "2021-01-07T10:09:50Z")
Is it possible to get query execution statistics? I’m using S3 demo bucket table and query it via python (pyodbc, pandas). How can I get query profiling/execution stats, for example: execution time, planning time, scanned data amount, etc?
---
### Author:  [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)
#### Post date: [January 8, 2021, 9:28am UTC](https://community.dremio.com/t/can-i-get-query-execution-metadata/6812/2 "2021-01-08T09:28:46Z")
@dmitrij.a
The Dremio query profile should give you all those details
> **[How To Share A Query Profile](https://www.dremio.com/tutorials/share-query-profile-dremio/)**
>
> Tutorial explaining how to share a query profile in Dremio.
Thanks
Bali
---
### Author:  [@dmitrij.a](https://community.dremio.com/u/dmitrij.a)
#### Post date: [January 8, 2021, 10:08am UTC](https://community.dremio.com/t/can-i-get-query-execution-metadata/6812/3 "2021-01-08T10:08:50Z")
@balaji.ramaswamy thanks, however is there any automatic/programmatic way of doing that?
---
### Author:  [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)
#### Post date: [January 9, 2021, 8:08am UTC](https://community.dremio.com/t/can-i-get-query-execution-metadata/6812/4 "2021-01-09T08:08:51Z")
@dmitrij.a
You can download the zip file and extract the contents. The header.json will contain information such as node list, sources list while the profile.json should have all the profile info. You can upload the profile JSON to Dremio and query to see the same information but the UI rendering will not be there
Thanks
Bali
---
### Author:  [@dmitrij.a](https://community.dremio.com/u/dmitrij.a)
#### Post date: [January 10, 2021, 10:54am UTC](https://community.dremio.com/t/can-i-get-query-execution-metadata/6812/5 "2021-01-10T10:54:29Z")
@balaji.ramaswamy sorry for being annoying, but how can I download that zip automatically? What I mean is that I want to query the data using odbc connector and then get these results automatically without going to UI. Is it possible?
---
### Author:  [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)
#### Post date: [January 10, 2021, 11:02pm UTC](https://community.dremio.com/t/can-i-get-query-execution-metadata/6812/6 "2021-01-10T23:02:30Z")
@dmitrij.a
I thought you wanted a report on how the query performed? If you want to the actual results programmatically then you can use a REST call
[http://docs.dremio.com/rest-api/jobs/get-job.html](http://docs.dremio.com/rest-api/jobs/get-job.html)
---
### Author:  [@dmitrij.a](https://community.dremio.com/u/dmitrij.a)
#### Post date: [January 11, 2021, 10:28am UTC](https://community.dremio.com/t/can-i-get-query-execution-metadata/6812/7 "2021-01-11T10:28:25Z")
That’s exactly what I needed, thanks