GoLand
 
2025.1EAP
Shortcuts: Windows
Get GoLand
Because GoLand 2025.1 is still in development, this documentation may not be entirely accurate and is subject to change.
  1. Database Tools and SQL
  2. Introspection

Introspection

Last modified: 26 February 2025

Overview

Introspection is a process of loading the metadata of database objects and their source code.

When you perform introspection, structural information in the data source is inspected to detect tables, columns, functions, and other elements with their attributes. GoLand uses this information to show the objects in Database tool window, display their DDL, suggest them during completion, and for other coding assistance features.

Once you initiate introspection, GoLand displays the introspection progress bar on the right-hand side of the status bar.

Introspection run process

By default, only the schemas and databases selected to be shown in the Database tool window are introspected.

You can select which schemas or databases will be introspected and shown by either selecting them in the Database tool window, or editing the data source properties in Data Sources and Drivers dialog (CtrlAltShift0S) dialog.

Select schemas and databases for introspection and display

note

Depending on the database size, introspection and loaded metadata can take a significant amount of time and disk space.

  • In Database tool window

    Select schemas or databases in Database tool window

  • In Data Sources and Drivers dialog

    Select schemas or databases in data source properties

Once the necessary databases and schemas are introspected, IDE can resolve the database objects in your scripts to the correct context. The example below demonstrates database object resolve for introspected and not introspected schemas.

Database objects resolve for the introspected and not introspected schemas

  1. MySQL data source that has not been introspected.

  2. The only introspected guest database of the PostgreSQL data source. The database includes four schemas and only the public one has been introspected.

  3. Database object resolve in a query console: successful for the introspected guest schema and unsuccessful for the tests schema that has not been introspected.

tip

For query consoles, database object resolve also depends on the selected resolve mode. For more information about query console resolve modes, refer to the Run queries topic.

Database users might experience a long introspection time if all the objects are being processed, whereas it is usually not required for daily work and coding assistance. To reduce the number of introspected objects, GoLand has three introspection levels available for a few databases. For more information about the levels, refer to Introspection levels topic.