Re: Finding last checkpoint time

On Tue, 2010-07-20 at 16:15 -0400, Greg Smith wrote:
> Devrim GÜNDÜZ wrote:
> > Is there a way to find last checkpoint time via SQL command? I know I
> > can grep xlogs by turning on log_checkpoints, but I'd prefer an SQL
> > solution.
> >
>
> Not directly. Best you can do without linking in new server code is
> either import the logs via CVS to get them into a table, or shell out
> and look at what comes out of pg_controldata.
>
> There have been two works in progress to improve this situation that
> didn't make it through to commit yet.
<snip>

What about adding a column to pg_stat_bgwriter, like "last_checkpoint"
or similar?

Regards,
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz