aboutsummaryrefslogtreecommitdiff
path: root/src/backend/commands/variable.c
diff options
context:
space:
mode:
authorAmit Kapila <akapila@postgresql.org>2024-09-04 08:55:21 +0530
committerAmit Kapila <akapila@postgresql.org>2024-09-04 08:55:21 +0530
commit6c2b5edecc0d6c936e27775c9451d32bb3141c90 (patch)
treea3717ebb364195cceaac32754aec901072531f98 /src/backend/commands/variable.c
parent9626068f13338f79ba183b4cf3c975e22c98c575 (diff)
downloadpostgresql-6c2b5edecc0d6c936e27775c9451d32bb3141c90.tar.gz
postgresql-6c2b5edecc0d6c936e27775c9451d32bb3141c90.zip
Collect statistics about conflicts in logical replication.
This commit adds columns in view pg_stat_subscription_stats to show the number of times a particular conflict type has occurred during the application of logical replication changes. The following columns are added: confl_insert_exists: Number of times a row insertion violated a NOT DEFERRABLE unique constraint. confl_update_origin_differs: Number of times an update was performed on a row that was previously modified by another origin. confl_update_exists: Number of times that the updated value of a row violates a NOT DEFERRABLE unique constraint. confl_update_missing: Number of times that the tuple to be updated is missing. confl_delete_origin_differs: Number of times a delete was performed on a row that was previously modified by another origin. confl_delete_missing: Number of times that the tuple to be deleted is missing. The update_origin_differs and delete_origin_differs conflicts can be detected only when track_commit_timestamp is enabled. Author: Hou Zhijie Reviewed-by: Shveta Malik, Peter Smith, Anit Kapila Discussion: https://postgr.es/m/OS0PR01MB57160A07BD575773045FC214948F2@OS0PR01MB5716.jpnprd01.prod.outlook.com
Diffstat (limited to 'src/backend/commands/variable.c')
0 files changed, 0 insertions, 0 deletions