{"Entry":{"collection":"catalog","key":"pg_stat_progress_copy","name":"pg_stat_progress_copy","aliases":[],"metadata":{"changed_in":["17"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"13","order":false,"removed":[],"status":"added","to":"14","types":[]},{"added":["tuples_skipped"],"attributes":[],"description_changed":false,"descriptions":[{"from":"The io type that the data is read from or written to: FILE, PROGRAM, PIPE (for COPY FROM STDIN and COPY TO STDOUT), or CALLBACK (used for example during the initial table synchronization in logical replication).","name":"type","to":"The I/O type that the data is read from or written to: FILE, PROGRAM, PIPE (for COPY FROM STDIN and COPY TO STDOUT), or CALLBACK (used for example during the initial table synchronization in logical replication)."}],"from":"16","listing":[],"order":false,"removed":[],"status":"changed","to":"17","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Number of tuples skipped because they contain malformed data. This counter only advances when a value other than stop is specified to the ON_ERROR option.","name":"tuples_skipped","to":"Number of tuples skipped because they contain malformed data. This counter only advances when ignore is specified to the ON_ERROR option."}],"from":"18","listing":[],"order":false,"removed":[],"status":"reworded","to":"19","types":[],"unlisted":[]}],"column_count":11,"content_hash":"e0cae75f340c2c995f55e48a4d931132308eced382574116d001b5ca72f17951","first_version":"14","imported_at":"2026-09-30T00:40:55.941548+08:00","kind":"progress","last_version":"20","name":"pg_stat_progress_copy","position":97,"present_in":["14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"english-manuals:431e9c2c59263876eed6e83a661555ca88ea532a7195e57eb0bd1c822b92f291","summary":"Whenever COPY is running, the pg_stat_progress_copy view will contain one row for each backend that is currently running a COPY command.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_stat_progress_copy","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_stat_progress_copy","SourceRevision":"english-manuals:431e9c2c59263876eed6e83a661555ca88ea532a7195e57eb0bd1c822b92f291","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Process ID of backend.","description_zh":"","documented":true,"documented_name":"pid","hidden":false,"name":"pid","not_null":false,"references":"","type":"integer","type_modifier":-1,"type_oid":23},{"array_dimensions":0,"attnum":2,"description":"OID of the database to which this backend is connected.","description_zh":"","documented":true,"documented_name":"datid","hidden":false,"name":"datid","not_null":false,"references":"","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":3,"description":"Name of the database to which this backend is connected.","description_zh":"","documented":true,"documented_name":"datname","hidden":false,"name":"datname","not_null":false,"references":"","type":"name","type_modifier":-1,"type_oid":19},{"array_dimensions":0,"attnum":4,"description":"OID of the table on which the COPY command is executed. It is set to 0 if copying from a SELECT query.","description_zh":"","documented":true,"documented_name":"relid","hidden":false,"name":"relid","not_null":false,"references":"","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":5,"description":"The command that is running: COPY FROM, or COPY TO.","description_zh":"","documented":true,"documented_name":"command","hidden":false,"name":"command","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":6,"description":"The I/O type that the data is read from or written to: FILE, PROGRAM, PIPE (for COPY FROM STDIN and COPY TO STDOUT), or CALLBACK (used for example during the initial table synchronization in logical replication).","description_zh":"","documented":true,"documented_name":"type","hidden":false,"name":"type","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":7,"description":"Number of bytes already processed by COPY command.","description_zh":"","documented":true,"documented_name":"bytes_processed","hidden":false,"name":"bytes_processed","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":8,"description":"Size of source file for COPY FROM command in bytes. It is set to 0 if not available.","description_zh":"","documented":true,"documented_name":"bytes_total","hidden":false,"name":"bytes_total","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":9,"description":"Number of tuples already processed by COPY command.","description_zh":"","documented":true,"documented_name":"tuples_processed","hidden":false,"name":"tuples_processed","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":10,"description":"Number of tuples not processed because they were excluded by the WHERE clause of the COPY command.","description_zh":"","documented":true,"documented_name":"tuples_excluded","hidden":false,"name":"tuples_excluded","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":11,"description":"Number of tuples skipped because they contain malformed data. This counter only advances when a value other than stop is specified to the ON_ERROR option.","description_zh":"","documented":true,"documented_name":"tuples_skipped","hidden":false,"name":"tuples_skipped","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20}],"description":"Whenever COPY is running, the pg_stat_progress_copy view will contain one row for each backend that is currently running a COPY command. The table below describes the information that will be reported and provides information about how to interpret it.","description_zh":"","doc":{"anchor":"PG-STAT-PROGRESS-COPY-VIEW","file":"progress-reporting.html","lang":"en","sha256":"a1f46d2b670502bfe75f1cf5192050ef2ef68202a8f928c4915abea0f4f71ae6","slug":"18"},"kind":"progress","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["pid","datid","datname","relid","command","type","bytes_processed","bytes_total","tuples_processed","tuples_excluded","tuples_skipped"],"runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"PG-STAT-PROGRESS-COPY-VIEW","file":"progress-reporting.html","lang":"en","sha256":"a1f46d2b670502bfe75f1cf5192050ef2ef68202a8f928c4915abea0f4f71ae6","slug":"18"}},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["pid","datid","datname","relid","command","type","bytes_processed","bytes_total","tuples_processed","tuples_excluded","tuples_skipped"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_stat_progress_copy","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_stat_progress_copy","Summary":"当COPY正在运行时，pg_stat_progress_copy视图会为每个当前正在执行COPY命令的后端包含一行。下表描述了会报告哪些信息，以及应如何解释这些信息。","BodyHTML":"\u003cp\u003e当COPY正在运行时，pg_stat_progress_copy视图会为每个当前正在执行COPY命令的后端包含一行。下表描述了会报告哪些信息，以及应如何解释这些信息。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"47281a938d13136f237ad37c855643f2ee1c720f969963e50106bdce3e5ba1b9","Payload":{"columns":[{"description_zh":"后端的进程ID。","name":"pid","type":"integer","zh_from":"doc"},{"description_zh":"后端连接到的数据库的OID。","name":"datid","type":"oid","zh_from":"doc"},{"description_zh":"后端连接到的数据库的名称。","name":"datname","type":"name","zh_from":"doc"},{"description_zh":"执行COPY命令的表的OID。如果从SELECT查询中复制，它被设置为0。","name":"relid","type":"oid","zh_from":"doc"},{"description_zh":"正在运行的命令：COPY FROM或COPY TO。","name":"command","type":"text","zh_from":"doc"},{"description_zh":"读取或写入数据的 I/O 类型：FILE、PROGRAM、PIPE（用于COPY FROM STDIN和COPY TO STDOUT），或CALLBACK（例如在逻辑复制的初始表同步期间使用）。","name":"type","type":"text","zh_from":"doc"},{"description_zh":"已经被COPY命令处理的字节数。","name":"bytes_processed","type":"bigint","zh_from":"doc"},{"description_zh":"COPY FROM命令的源文件大小，以字节计。如果不可用则设置为0。","name":"bytes_total","type":"bigint","zh_from":"doc"},{"description_zh":"已经被COPY命令处理的元组数。","name":"tuples_processed","type":"bigint","zh_from":"doc"},{"description_zh":"没有处理的元组数，因为它们被COPY命令的WHERE子句所排除。","name":"tuples_excluded","type":"bigint","zh_from":"doc"},{"description_zh":"因包含格式错误的数据而被跳过的元组数。只有当 ON_ERROR 选项指定的值不是 stop 时，此计数器才会递增。","name":"tuples_skipped","type":"bigint","zh_from":"doc"}],"description_zh":"当COPY正在运行时，pg_stat_progress_copy视图会为每个当前正在执行COPY命令的后端包含一行。下表描述了会报告哪些信息，以及应如何解释这些信息。","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}