I would like to get the execution plan of a statement in postgresql. This statement is as follows:

CREATE TABLESPACE example LOCATION 'C:\example\';

The code I have tried is as follows:

EXPLAIN CREATE TABLESPACE example LOCATION 'C:\example\';

However, Postgresql indicates syntax error at or near "TABLESPACE".

Any idea?

Thnak you in advance

CodePudding user response：

Due to documentation, you can see the execution plan only for SELECT, INSERT, UPDATE, DELETE, VALUES, EXECUTE, DECLARE, CREATE TABLE AS, or CREATE MATERIALIZED VIEW AS statements.

So it is not impossible for CREATE TABLESPACE statements.