Trying to understand duration column in Azure Sql DB Query Performance Insight

I have a query that runs for a long time, according to Query Performance Insight, and I tracked it down to a Runbook we use to export the azure db to our own copy of a backup. However, it says it is running for 8-9 hours every 24 hours. This can’t be right.

First screen shot: Query Performance Insight showing that my query ran for 8 hours and 51 minutes.User's image

Second screenshot: The details of the query show that it ran for over 2 hours between 8-9 PM and for over 6 hours between 9 and 10 pm. This does not make sense to me.

User's image

Screenshot 3: We use a scheduled runbook to do the backup and it finishes most nights in under a minute.

User's image

Why is the backup of the db (which is running the query) finishing in under a minute and yet the query supposedly takes 8 hours during a 2 hour time frame.

Read more here: Source link