List the durations of past Apply Changes

If you think that Apply Changes is taking longer than usual, you can list the durations of past Apply Changes to determine whether the length of an Apply Changes is typical.

The durations of past Apply Changes are stored in the reloadtimes table of the opsview database.

Prerequisites Copied

• None

Procedure Copied

1. Log in to the orchestrator as root.
2. Query the opsview.reloadtimes table using cx:

/opt/opsview/coreutils/utils/cx opsview 'SELECT id, FROM_UNIXTIME(start_config), FROM_UNIXTIME(end_config), duration, post_reload_duration FROM reloadtimes ORDER BY id DESC limit 10;'

More or fewer rows Copied

Change the number of limit 10 to see more or fewer rows from the opsview.reloadtimes table.