I’m trying to analyze if the triggers before and after on my table with huge data to check for any bottlenecks and for improvements but i’m getting syntax error and wanted to see if it’s possible to do EXPLAIN ANALYZE COPY
i did some research but couldn’t find if it’s possible or not
>Solution :
As documented in the manual the following statements can be explained
Any SELECT, INSERT, UPDATE, DELETE, VALUES, EXECUTE, DECLARE, CREATE TABLE AS, or CREATE MATERIALIZED VIEW AS statement, whose execution plan you wish to see.
The COPY command is not in that list