Re: Finding last checkpoint time

From: Thom Brown <thombrown(at)gmail(dot)com>
To: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
Cc: PostgreSQL - General ML <pgsql-general(at)postgresql(dot)org>
Subject: Re: Finding last checkpoint time
Date: 2010-07-20 19:48:23
Message-ID: AANLkTil4_soVYhJayXBfKN_-O6y4uNR3MEOM44lz8DXZ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2010/7/20 Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>:
>
> 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.
>
> --

Or you can use pg_controldata /path/to/pgdata and look at "Time of
latest checkpoint".

I don't know of any other way, not to say there isn't one.

Thom

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2010-07-20 20:15:34 Re: Finding last checkpoint time
Previous Message Devrim GÜNDÜZ 2010-07-20 19:22:58 Finding last checkpoint time