A processing system including at least one processor may obtain a first set of performance records of a database system, train a machine learning model in accordance with the first set of performance records, where the machine learning model that is trained in accordance with the first set of performance records is configured to predict a latency of a query transaction for a designated time period, present a user interface with a plurality of settings of the database system that are user-adjustable, where the plurality of settings is associated with at least a portion of the first set of performance records, calculate a first predicted latency of a query transaction at the designated time period via the machine learning model in accordance with a set of values of the plurality of settings, and present the first predicted latency via the user interface.