Message-ID: <4F1830FE.3030005@gmail.com>
Date: Thu, 19 Jan 2012 16:04:30 +0100
From: Alexander Fortin <alexander.fortin@gmail.com>
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7;
	rv:9.0) Gecko/20111222 Thunderbird/9.0.1
MIME-Version: 1.0
To: Sergey Konoplev <gray.ru@gmail.com>
CC: pgsql-admin@postgresql.org
Subject: Re: Interpreting pg_stat_replication values
References: <4F13ED11.6080001@gmail.com>
	<CAL_0b1vJZdJtGLzBN_wRDoqUCAG6MuF_rCVELgvw+isSehoAUw@mail.gmail.com>
In-Reply-To: 
 <CAL_0b1vJZdJtGLzBN_wRDoqUCAG6MuF_rCVELgvw+isSehoAUw@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 1/18/12 9:38 AM, Sergey Konoplev wrote:
> With 9.1 you can use
>
> SELECT now() - pg_last_xact_replay_timestamp() AS time_lag;

Hi Sergey,
thank you very much for your suggestion. In the meanwhile we went for a 
check on pg_stat_replication, but we'll add one as you suggest soon on 
the replicas.

By the way, maybe you know where I could find documentation about 
possible values from column "state" on view pg_stat_replication? I can 
see "streaming" when everything is ok, and once I could get just a 
"catchup" while a replica was synching.

-- 
Alexander Fortin
http://about.me/alexanderfortin/