# How do I know how long it took to deploy a changeset?

**URL:** https://forum.liquibase.org/t/how-do-i-know-how-long-it-took-to-deploy-a-changeset/6257
**Category:** Community Answers
**Created:** [December 14, 2021, 1:09pm UTC](https://forum.liquibase.org/t/how-do-i-know-how-long-it-took-to-deploy-a-changeset/6257 "2021-12-14T13:09:03Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![JirkaS](https://avatars.discourse-cdn.com/v4/letter/j/c2a13f/32.png) [@JirkaS](https://forum.liquibase.org/u/JirkaS)
#### Post date: [December 14, 2021, 1:09pm UTC](https://forum.liquibase.org/t/how-do-i-know-how-long-it-took-to-deploy-a-changeset/6257/1 "2021-12-14T13:09:03Z")

</div>

Hi, I would like to ask you if there is a way to find how long a deployment of a changeset took. For me the best way would be a column in DATABASECHANGELOGLOCK table.  
I know that there is the column DATEEXECUTED in the table DATABASECHANGELOGLOCK but there is only information about date executed not time needed to deploy the changeset.  
Thanks  
J.

---

<div class="post-metadata">

### Author: ![daryldoak](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/daryldoak/32/764_2.png) [@daryldoak](https://forum.liquibase.org/u/daryldoak)
#### Post date: [December 14, 2021, 3:29pm UTC](https://forum.liquibase.org/t/how-do-i-know-how-long-it-took-to-deploy-a-changeset/6257/2 "2021-12-14T15:29:35Z")

</div>

You can get the start and end timestamps from the Liquibase output, but this does take some effort to determine the duration for each changeset.

---

<div class="post-metadata">

### Author: ![ahmedabdeljelil](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/ahmedabdeljelil/32/397_2.png) [@ahmedabdeljelil](https://forum.liquibase.org/u/ahmedabdeljelil)
#### Post date: [December 15, 2021, 2:21pm UTC](https://forum.liquibase.org/t/how-do-i-know-how-long-it-took-to-deploy-a-changeset/6257/3 "2021-12-15T14:21:30Z")

</div>

Hello,

You can do it by calculating it. it’s just a diff between date of the first changeset executed and the last one.

Regards,  
Ahmed.

---

<div class="post-metadata">

### Author: ![MikeOlivas](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/mikeolivas/32/183_2.png) [@MikeOlivas](https://forum.liquibase.org/u/MikeOlivas)
#### Post date: [December 30, 2021, 3:41pm UTC](https://forum.liquibase.org/t/how-do-i-know-how-long-it-took-to-deploy-a-changeset/6257/4 "2021-12-30T15:41:49Z")

</div>

@JirkaS If you register your changelog with liquibase hub, Hub will have the information you are looking for. How long a changeset executed, how long the entire changelog executed, etc.

> **[Liquibase Hub](https://hub.liquibase.com)**
>
> Real-time monitoring for Liquibase database changes. Free for all users!

---

<div class="post-metadata">

### Author: ![JirkaS](https://avatars.discourse-cdn.com/v4/letter/j/c2a13f/32.png) [@JirkaS](https://forum.liquibase.org/u/JirkaS)
#### Post date: [January 3, 2022, 7:02am UTC](https://forum.liquibase.org/t/how-do-i-know-how-long-it-took-to-deploy-a-changeset/6257/5 "2022-01-03T07:02:35Z")

</div>

Thank you all for your advice
