Loading of database objects takes too much time

Last modified: 26 February 2025

Introspection is a process of loading metadata of a database. When you perform introspection, structural information in the data source is inspected to detect tables, columns, routines, and other database objects with their attributes.

Sometimes introspection runs into problems. In case this happens, try to collect troubleshooting data and pass it on to our support team.

To diagnose a slow introspection, reload the metadata from the database and generate a detailed log file of the process. This information might be helpful for the support team when your introspection takes too much time.

Create an introspection log file

  1. Right-click a data source, navigate to Diagnostics and enable the Diagnostic Mode option.

  2. Run the introspection and wait till it is finished.

  3. Disable the Diagnostic Mode by right-clicking the data source, navigating to Diagnostics and deselecting the option.

  4. In the Diagnostic log stopped notification popup that appears, click the directory link to navigate to the log file.

    Notification about the log file with its location

  5. Attach the dataSource-<date>-<time>-<data_source_name>.log detailed log file to your support request.

    Log file in the OS file browser

The following screenshot shows the example output of this file.

Example of the introspection log file

To report an issue, you can use any option that is described in the Where to report an issue section. But we recommend using the JetBrains Support Center.

Submit a request in the JetBrains Support Center

  1. Open the request form by doing one of the following:

    • Click Help | Contact Support.

      The request form will contain prefilled fields about your product and OS.

    • Go to the Submit a request page.

  2. Fill in the Submit a request form.

    If it is possible, attach some troubleshooting materials.

  3. Click Submit.