{"Entry":{"collection":"catalog","key":"pg_stat_replication_slots","name":"pg_stat_replication_slots","aliases":[],"metadata":{"changed_in":["19"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"13","order":false,"removed":[],"status":"added","to":"14","types":[]},{"added":["mem_exceeded_count","slotsync_skip_count","slotsync_last_skip"],"attributes":[],"description_changed":false,"descriptions":[],"from":"18","listing":[],"order":false,"removed":[],"status":"changed","to":"19","types":[],"unlisted":[]}],"column_count":13,"content_hash":"385e5cdab1ba3878fe39c878d33d0a1c55b2997dff4abda069adf97a2cfabf43","first_version":"14","imported_at":"2026-09-30T00:40:55.978632+08:00","kind":"statistics","last_version":"20","name":"pg_stat_replication_slots","position":105,"present_in":["14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"english-manuals:062487f5e9f895e4dd67186b60fd6b929d21e06da040273ee1d8be3acd28acba","summary":"The pg_stat_replication_slots view will contain one row per logical replication slot, showing statistics about its usage.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_stat_replication_slots","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_stat_replication_slots","SourceRevision":"english-manuals:062487f5e9f895e4dd67186b60fd6b929d21e06da040273ee1d8be3acd28acba","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"A unique, cluster-wide identifier for the replication slot","description_zh":"","documented":true,"documented_name":"slot_name","hidden":false,"name":"slot_name","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":2,"description":"Number of transactions spilled to disk once the memory used by logical decoding to decode changes from WAL has exceeded logical_decoding_work_mem. The counter gets incremented for both top-level transactions and subtransactions.","description_zh":"","documented":true,"documented_name":"spill_txns","hidden":false,"name":"spill_txns","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":3,"description":"Number of times transactions were spilled to disk while decoding changes from WAL for this slot. This counter is incremented each time a transaction is spilled, and the same transaction may be spilled multiple times.","description_zh":"","documented":true,"documented_name":"spill_count","hidden":false,"name":"spill_count","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":4,"description":"Amount of decoded transaction data spilled to disk while performing decoding of changes from WAL for this slot. This and other spill counters can be used to gauge the I/O which occurred during logical decoding and allow tuning logical_decoding_work_mem.","description_zh":"","documented":true,"documented_name":"spill_bytes","hidden":false,"name":"spill_bytes","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":5,"description":"Number of in-progress transactions streamed to the decoding output plugin after the memory used by logical decoding to decode changes from WAL for this slot has exceeded logical_decoding_work_mem. Streaming only works with top-level transactions (subtransactions can't be streamed independently), so the counter is not incremented for subtransactions.","description_zh":"","documented":true,"documented_name":"stream_txns","hidden":false,"name":"stream_txns","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":6,"description":"Number of times in-progress transactions were streamed to the decoding output plugin while decoding changes from WAL for this slot. This counter is incremented each time a transaction is streamed, and the same transaction may be streamed multiple times.","description_zh":"","documented":true,"documented_name":"stream_count","hidden":false,"name":"stream_count","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":7,"description":"Amount of transaction data decoded for streaming in-progress transactions to the decoding output plugin while decoding changes from WAL for this slot. This and other streaming counters for this slot can be used to tune logical_decoding_work_mem.","description_zh":"","documented":true,"documented_name":"stream_bytes","hidden":false,"name":"stream_bytes","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":8,"description":"Number of decoded transactions sent to the decoding output plugin for this slot. This counts top-level transactions only, and is not incremented for subtransactions. Note that this includes the transactions that are streamed and/or spilled.","description_zh":"","documented":true,"documented_name":"total_txns","hidden":false,"name":"total_txns","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":9,"description":"Amount of transaction data decoded for sending transactions to the decoding output plugin while decoding changes from WAL for this slot. Note that this includes data that is streamed and/or spilled.","description_zh":"","documented":true,"documented_name":"total_bytes","hidden":false,"name":"total_bytes","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":10,"description":"Time at which these statistics were last reset","description_zh":"","documented":true,"documented_name":"stats_reset","hidden":false,"name":"stats_reset","not_null":false,"references":"","type":"timestamp with time zone","type_modifier":-1,"type_oid":1184}],"description":"The pg_stat_replication_slots view will contain one row per logical replication slot, showing statistics about its usage.","description_zh":"","doc":{"anchor":"PG-STAT-REPLICATION-SLOTS-VIEW","file":"monitoring-stats.html","lang":"en","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","slug":"18"},"kind":"statistics","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["slot_name","spill_txns","spill_count","spill_bytes","stream_txns","stream_count","stream_bytes","total_txns","total_bytes","stats_reset"],"runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"PG-STAT-REPLICATION-SLOTS-VIEW","file":"monitoring-stats.html","lang":"en","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","slug":"18"}},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["slot_name","spill_txns","spill_count","spill_bytes","stream_txns","stream_count","stream_bytes","total_txns","total_bytes","stats_reset"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_stat_replication_slots","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_stat_replication_slots","Summary":"pg_stat_replication_slots视图将包含每个逻辑复制槽的一行，显示关于其使用情况的统计信息。","BodyHTML":"\u003cp\u003epg_stat_replication_slots视图将包含每个逻辑复制槽的一行，显示关于其使用情况的统计信息。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"6caa5c73e9a01ba7f3e87def7e3fd68a06dde0e976be3309f98bae171eaddf69","Payload":{"columns":[{"description_zh":"复制槽在整个集簇范围内的唯一标识符","name":"slot_name","type":"text","zh_from":"doc"},{"description_zh":"当逻辑解码从 WAL 解码更改时所使用的内存超过logical_decoding_work_mem后，溢出到磁盘的事务数。顶层事务和子事务都会使此计数器递增。","name":"spill_txns","type":"bigint","zh_from":"doc"},{"description_zh":"在为该槽解码来自WAL的更改时，事务溢出到磁盘的次数。此计数器在每次事务溢出时递增，并且同一事务可能溢出多次。","name":"spill_count","type":"bigint","zh_from":"doc"},{"description_zh":"为此槽从 WAL 解码更改时，溢出到磁盘的已解码事务数据量。此计数器及其他溢出计数器可用于衡量逻辑解码期间发生的 I/O，并用于调优logical_decoding_work_mem。","name":"spill_bytes","type":"bigint","zh_from":"doc"},{"description_zh":"当逻辑解码为此槽从 WAL 解码更改时所使用的内存超过logical_decoding_work_mem后，流式传输到解码输出插件的进行中事务数。流式传输仅适用于顶层事务（子事务不能单独进行流式传输），因此子事务不会使此计数器递增。","name":"stream_txns","type":"bigint","zh_from":"doc"},{"description_zh":"在为该槽解码来自WAL的更改时，将进行中事务流式传输到解码输出插件的次数。此计数器在每次事务流式传输时递增，并且同一事务可能被流式传输多次。","name":"stream_count","type":"bigint","zh_from":"doc"},{"description_zh":"在为该槽解码来自WAL的更改时，为将进行中事务流式传输到解码输出插件而解码的事务数据量。这个和针对此槽的其他流式传输计数器可用于调优logical_decoding_work_mem。","name":"stream_bytes","type":"bigint","zh_from":"doc"},{"description_zh":"针对此槽发送到解码输出插件的已解码事务数。这只统计顶层事务，不会因子事务而增加计数。注意，这包括流式传输和/或溢出的事务。","name":"total_txns","type":"bigint","zh_from":"doc"},{"description_zh":"在为此槽从 WAL 解码更改时，为将事务发送到解码输出插件而解码的事务数据量。注意这包括流式传输和/或溢出的数据。","name":"total_bytes","type":"bigint","zh_from":"doc"},{"description_zh":"这些统计信息上次被重置的时间","name":"stats_reset","type":"timestamp with time zone","zh_from":"doc"}],"description_zh":"pg_stat_replication_slots视图将包含每个逻辑复制槽的一行，显示关于其使用情况的统计信息。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}