PostgreSQL环境中查看SQL执行计划示例

explain   analyze ,format,buffers,

format :TEXT, XML, JSON, or YAML.

EXPLAIN (ANALYZE,buffers,format yaml) SELECT first_name FROM

customer_master WHERE first_name = ‘Carolee‘;

PostgreSQL环境中查看SQL执行计划示例

标签：