PostgreSQL 生成优化器debug输出 图像

作者

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

PostgreSQL 许愿链接

您的愿望将传达给PG kernel hacker、数据库厂商等, 帮助提高数据库产品质量和功能, 说不定下一个PG版本就有您提出的功能点. 针对非常好的提议，奖励限量版PG文化衫、纪念品、贴纸、PG热门书籍等，奖品丰富，快来许愿。开不开森.

9.9元购买3个月阿里云RDS PostgreSQL实例

PostgreSQL 解决方案集合

德哥 / digoal's github - 公益是一辈子的事.