Will a record be inserted into the database table when executing an INSERT query with EXPLAIN ANALYZE?

A query using EXPLAIN ANALYZE does not make changes to the database. This operator is used to analyze the execution plan of an SQL query and evaluate its performance.

If you run a query like:

EXPLAIN ANALYZE INSERT INTO table_name (column1) VALUES ('value1');

the actual insertion of the record will not occur. Instead, the database will perform the insertion as part of the analysis, then roll back the changes so as not to affect the data. Thus, EXPLAIN ANALYZE allows you to see how the query will execute without modifying the data.