如何查看PostgreSQL的checkpoint 活动

参考：http://blog.2ndquadrant.com/measuring_postgresql_checkpoin/

执行前：

select pg_stat_reset();
select pg_stat_reset_shared('bgwriter');

待测试程序执行完毕后：

SELECT
total_checkpoints,
seconds_since_start / total_checkpoints / 60 AS minutes_between_checkpoints
FROM
(SELECT
EXTRACT(EPOCH FROM (now() - pg_postmaster_start_time())) AS seconds_since_start
(checkpoints_timed+checkpoints_req) AS total_checkpoints,
FROM pg_stat_bgwriter
) AS sub;

本文转自健哥的数据花园博客园博客，原文链接：http://www.cnblogs.com/gaojian/p/3277584.html，如需转载请自行联系原作者