Обсуждение: Logging queries cancelled due to replication timeouts

Поиск
Список
Период
Сортировка

Logging queries cancelled due to replication timeouts

От
Christophe Pettus
Дата:
Greetings,

Is there a combination of options that will cause a hot standby replica to log queries that are cancelled due to a
replicationtimeout (max_standby_streaming_delay)? 

--
-- Christophe Pettus
   xof@thebuild.com


Re: Logging queries cancelled due to replication timeouts

От
Bruce Momjian
Дата:
Christophe Pettus wrote:
> Greetings,
>
> Is there a combination of options that will cause a hot standby replica to log queries that are cancelled due to a
replicationtimeout (max_standby_streaming_delay)? 

Sure, how about the system view pg_stat_database_conflicts in PG 9.1?

Our docs say:

    Add the <link
    linkend="monitoring-stats-views-table"><structname>pg_stat_database_conflicts</></link>
    system view to show queries that have been canceled and the
    reason (Magnus Hagander) </para>

       <para>
    Cancellations can occur because of dropped tablespaces, lock
    timeouts, old snapshots, pinned buffers, and deadlocks.

I assume replication cancellations are also in there, no?

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +