I have a liquibase process where when creating a new table in DB , the liquibase.snapshot.DatabaseSnapshot step is taking a lot of time on the constraints, i already have the stats gather on metadata but still the step takes time and overall contribute to slowness of the liquibase process in my application.
How can i debug this further ? what sql might be slow or any other setting ? Any ideas ?
the change log for create a pre condition
Degug logs of liquibase process ,
2025-07-16 15:18:29,493 liquibase.snapshot.DatabaseSnapshot : DEBUG - Excluding XXX_Constraint_Name
2025-07-16 15:18:29,493 liquibase.snapshot.DatabaseSnapshot : DEBUG - Excluding XXX_Constraint_Name
2025-07-16 15:18:29,579 liquibase.snapshot.DatabaseSnapshot : DEBUG - Excluding XXX_Constraint_Name
2025-07-16 15:18:29,579 liquibase.snapshot.DatabaseSnapshot : DEBUG - Excluding XXX_Constraint_Name
2025-07-16 15:18:29,932 liquibase.snapshot.DatabaseSnapshot : DEBUG - Excluding XXX_Constraint_Name
2025-07-16 15:18:29,933 liquibase.snapshot.DatabaseSnapshot : DEBUG - Excluding XXX_Constraint_Name
2025-07-16 15:18:30,055 liquibase.snapshot.DatabaseSnapshot : DEBUG - Excluding XXX_Constraint_Name
2025-07-16 15:18:30,055 liquibase.snapshot.DatabaseSnapshot : DEBUG - Excluding XXX_Constraint_Name
2025-07-16 15:18:30,161 liquibase.snapshot.DatabaseSnapshot : DEBUG - Excluding XXX_Constraint_Name
2025-07-16 15:18:30,162 liquibase.snapshot.DatabaseSnapshot : DEBUG - Excluding XXX_Constraint_Name
2025-07-16 15:18:30,492 liquibase.snapshot.DatabaseSnapshot : DEBUG - Excluding XXX_Constraint_Name