Query with Neon's SQL Editor

To use the SQL Editor:

1. Navigate to the Neon console.
2. Select your project.
3. Select the SQL Editor.
4. Select a branch and database.
5. Enter a query into the editor and click Run to view the results.

You can use the following queries to try the SQL Editor:

CREATE TABLE t (c int);
INSERT INTO t SELECT generate_series(1,100);
SELECT count(*) FROM t;

To clear the editor, click New Query.

Saving queries

The SQL Editor allows you to save your queries.

To save a query:

1. Enter the query into the editor.
2. Click Save to open the SAVE QUERY dialog.
3. Enter a name for the query and click Save.

The query is added to the Saved list in the left pane of the SQL Editor. You can rerun a query by selecting it from the Saved list.

You can rename or delete a saved query by selecting Rename or Delete from the the kebab menu associated with the saved query.

Viewing the query history

The SQL Editor maintains a query history for the project. To view your query history, select History in the left pane of the SQL Editor. You can click an item in the History list to view the query that was run.

Explain and Analyze

The Neon SQL Editor provides Explain and Analyze features.

• The Explain feature runs the specified query with the PostgreSQL EXPLAIN command, which returns the execution plan for the query. The Explain feature only returns a plan with estimates. It does not execute the query.
• The Analyze feature runs the specified query with EXPLAIN ANALYZE. The ANALYZE parameter causes the query to be executed and returns actual row counts and run times for plan nodes along with the EXPLAIN estimates.

Understanding the information provided by the Explain and Analyze features requires familiarity with PostgreSQL's EXPLAIN command and its ANALYZE parameter. Refer to the EXPLAIN documentation and the Using EXPLAIN topic in the PostgreSQL documentation.

Need help?

Send a request to support@neon.tech, or join the Neon community forum.