What additional parameters can be specified in the EXPLAIN ANALYZE command to get more detailed information about query execution?

In PostgreSQL, the EXPLAIN ANALYZE command provides detailed information about the execution plan of an SQL query along with the actual execution time. To obtain more detailed information, additional parameters can be used:

• BUFFERS — shows buffer usage statistics (how many pages were read from memory and disk).
• VERBOSE — outputs more detailed information about each node in the plan.
• COSTS — enables or disables the display of operation cost estimates.
• TIMING — enables or disables the display of execution time for each node.

Example usage:

EXPLAIN (ANALYZE, BUFFERS, VERBOSE) SELECT * FROM users WHERE id = 1;

This will provide an extended report with information about buffers and plan details.