PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.
The EXPLAIN option MEMORY reports optimizer memory usage .
EXPLAIN
MEMORY