RE: [Todo item] Add entry creation timestamp column topg_stat_replication
От | myungkyu.lim |
---|---|
Тема | RE: [Todo item] Add entry creation timestamp column topg_stat_replication |
Дата | |
Msg-id | 003001d47ca1$8282dc20$87889460$@samsung.com обсуждение исходный текст |
Ответ на | Re: [Todo item] Add entry creation timestamp column to pg_stat_replication (Surafel Temesgen <surafel3000@gmail.com>) |
Список | pgsql-hackers |
Hi. Thanks for your feedback. > Can you explain the purpose of this feature more because now we have columns to report replication delay times like write_lag,flush_lag and replay_lag that can use for similar purpose . I think, time elapsed stats are very useful on DML query active system, but not present that stats on idle system - not query, or only select. sent_lsn | 0/5476C88 write_lsn | 0/5476C88 flush_lsn | 0/5476C88 replay_lsn | 0/5476C88 write_lag | 00:00:00.000055 flush_lag | 00:00:00.000855 replay_lag | 00:00:00.000914 sync_priority | 0 sync_state | async last_msg_send_time | 2018-11-15 14:04:39.65889+09 state | streaming sent_lsn | 0/5476CC0 write_lsn | 0/5476CC0 flush_lsn | 0/5476CC0 replay_lsn | 0/5476CC0 write_lag | flush_lag | replay_lag | sync_priority | 0 sync_state | async last_msg_send_time | 2018-11-15 14:05:02.935457+09 state | streaming sent_lsn | 0/5476CC0 write_lsn | 0/5476CC0 flush_lsn | 0/5476CC0 replay_lsn | 0/5476CC0 write_lag | flush_lag | replay_lag | sync_priority | 0 sync_state | async last_msg_send_time | 2018-11-15 14:06:23.128947+09 This timestamp column is useful when react interval check and debugging on idle system. Best regards, Myungkyu, Lim
В списке pgsql-hackers по дате отправления: