60.1. Creating a Query Plan #
Before performing this instruction:
Get the query plan:
EXPLAIN (ANALYZE, COSTS, VERBOSE, BUFFERS, FORMAT JSON)
Copy the query plan and save it.
To create a query plan:
In the navigation panel, go to Monitoring → Visualization.
(Optional) To create a query plan based on an example, in the left part of the page, select Examples and click the name of the example.
Specify parameters of the new query plan (parameters marked with an asterisk are required):
Name.
Query plan.
Query: The text of the query.
If you specify the query text, it is added to the query plan visualization.
Instance and Database: The instance and database where the query is executed and with which the query plan will be associated.
Description.
Private query plan: Specifies whether the query plan can be shared with other users.
If you enable this checkbox, the query plan is available only to you.
(Optional) To visualize the query plan, click Visualize.
Click Save.