digoal
2020-03-26
PostgreSQL , pgNodeGraph
https://github.com/shenyuflying/pgNodeGraph
pgNodeGraph -- a postgreSQL node tree print tool
The output of postgreSQL node tree can be very long for the developer to investigate. pgNodeGraph tool can covert the output of the node tree into jpg formatted pictiure which is quite convenient for developing or debugging purposess.
将PG 优化器debug结果直接输出为图像:
set debug_print_parse = on;
set debug_print_plan = on;
set debug_pretty_print = on;
copy and paste the node tree in text form.
put it in node dir
run $ ./pgNodeGraph
$ ./pgNodeGraph
processing file sample.node ...done
您的愿望将传达给PG kernel hacker、数据库厂商等, 帮助提高数据库产品质量和功能, 说不定下一个PG版本就有您提出的功能点. 针对非常好的提议,奖励限量版PG文化衫、纪念品、贴纸、PG热门书籍等,奖品丰富,快来许愿。开不开森.