Average time interval between checkpoints

Calculates average delay between checkpoints. SELECT total_checkpoints, seconds_since_start / total_checkpoints AS seconds_between_checkpoints, seconds_since_start / total_checkpoints / 60 AS minutes_between_checkpoints, seconds_since_start FROM (SELECT EXTRACT(EPOCH...

bgwriter statistic in PostgreSQL 8.4

If you need to check what is PostgreSQL really doing – reads, writes, etc. you can try bgwriter statistic in pg_stat_bgwriter Only problem is that PG 8.4 does not store history therefore you need to save some time snapshots. First – create table for time...