2010/7/20 Devrim GÜNDÜZ <devrim@gunduz.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