EXPLAIN するとき ANALYZE と FORMAT JSON を両方かけないと思ってたけど構文調べたら 「()」を使ってカンマ区切りにすれば両方指定できた

test1=# explain (analyze true, format json) select * from table1 where id = 1;
QUERY PLAN
------------------------------------------
[ +
{ +
"Plan": { +
"Node Type": "Index Scan", +
"Parallel Aware": false, +
"Scan Direction": "Forward", +
"Index Name": "table1_pkey", +
"Relation Name": "table1", +
"Alias": "table1", +
"Startup Cost": 0.28, +
"Total Cost": 16.30, +
"Plan Rows": 1, +
"Plan Width": 1049, +
"Actual Startup Time": 0.048, +
"Actual Total Time": 0.048, +
"Actual Rows": 0, +
"Actual Loops": 1, +
"Index Cond": "(id = 1)", +
"Rows Removed by Index Recheck": 0+
}, +
"Planning Time": 0.475, +
"Triggers": [ +
], +
"Execution Time": 0.114 +
} +
]