Finding last checkpoint time

From: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
To: PostgreSQL - General ML <pgsql-general(at)postgresql(dot)org>
Subject: Finding last checkpoint time
Date: 2010-07-20 19:22:58
Message-ID: 1279653778.28450.4.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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.

--
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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2010-07-20 19:48:23 Re: Finding last checkpoint time
Previous Message Artur Dabrowski 2010-07-20 15:46:20 Re: Incorrect FTS result with GIN index