PostgreSQL 15 preview - PostgreSQL 15 pg_stat_statements 增加对temp file blocks io timing的统计, 增加JIT的统计.

作者

digoal

日期

2022-04-11

标签

PostgreSQL , pg_stat_statements , jit , temp file blocks

PostgreSQL 15 pg_stat_statements 增加了对temp file blocks io timing的统计, 增加了JIT的统计.

用于使用到临时文件的场景(例如排序、聚合), 临时文件的IO对性能的影响.

用于分析使用了JIT的SQL(通常是分析类的SQL), JIT的优化效果, 以及JIT自身code gen的代价等.

https://www.postgresql.org/docs/devel/pgstatstatements.html

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=76cbf7edb6385c682facda095050858cac2efae0

pg_stat_statements: Track I/O timing for temporary file blocks    
This commit adds two new columns to pg_stat_statements, called    
temp_blk_read_time and temp_blk_write_time.  Those columns respectively    
show the time spent to read and write temporary file blocks on disk,    
whose tracking has been added in efb0ef9.  This information is    
available when track_io_timing is enabled, like blk_read_time and    
blk_write_time.    
pg_stat_statements is updated to version to 1.10 as an effect of the    
newly-added columns.  Tests for the upgrade path 1.9->1.10 are added.    
PGSS_FILE_HEADER is bumped for the new stats file format.    

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=57d6aea00fcefec3825a5948ce05cf2b4941097b

Add JIT counters to pg_stat_statements    
This adds cumulative counters for jit operations to pg_stat_statements,    
making it easier to diagnose how JIT is used in an installation.    

期望 PostgreSQL 增加什么功能?

PolarDB for PostgreSQL云原生分布式开源数据库

PostgreSQL 解决方案集合

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