戴安·费:PGSQL 星期五 #008:pg_stat_statements
原文英文,约800词,阅读约需3分钟。发表于: 。pg_stat_statements for May. As luck would have it, it's been invaluable to me over the past few weeks as I've been solving some performance problems of the "tens of millions of rows, row-level...
文章介绍了作者使用pg_stat_statements解决性能问题时发现执行时间标准差的重要性,通过拆分语句提升性能,并通过标准差分析发现波动主要由两个最大值导致。建议在解决性能问题时注意标准差分析。