{"Entry":{"collection":"metric","key":"pg_stat_progress_create_index-partitions_done","name":"pg_stat_progress_create_index.partitions_done","aliases":["partitions_done","pg_stat_progress_create_index"],"metadata":{"aliases":["partitions_done","pg_stat_progress_create_index"],"category":"pg_stat_progress_create_index","content_hash":"541990d1943c5b3f5b92c9c1115367f5f82ed094d82551b36147e8a90c26debe","derived_content_hash":"b017549c5706b80221d3079238762247ada870bc1257e1021a209b81af1fc513","imported_at":"2026-09-30T00:40:45.892138+08:00","name":"pg_stat_progress_create_index.partitions_done","name_zh":"","slug":"pg_stat_progress_create_index-partitions_done","summary":"Number of partitions on which the index has already been created or attached, including both direct and indirect partitions. 0 during a REINDEX, or when the index is not partitioned."}},"Definition":{"Collection":"metric","Key":"pg_stat_progress_create_index-partitions_done","SourceDatabase":"center","Version":"18","SourceTable":"statistics_metric","SourceKey":"pg_stat_progress_create_index-partitions_done","SourceRevision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","Facts":{"comparison_data":{"field":"partitions_done","sql_type":"bigint","units_mentioned":[],"view":"pg_stat_progress_create_index"},"comparison_hash":"2d9995648979412b6f87e8d4ba11be2b692e790e85b2e94994aca63e207776d2","description":["Number of partitions on which the index has already been created or attached, including both direct and indirect partitions. 0 during a REINDEX, or when the index is not partitioned."],"description_zh":"已创建或附加索引的分区数量，包括直接分区和间接分区。在 REINDEX 期间，或索引未分区时，此值为 0。","description_zh_html":"\u003cp\u003epg_stat_progress_create_index.partitions_done 统计字段。\u003c/p\u003e\u003cdl\u003e\u003cdt\u003e视图\u003c/dt\u003e\u003cdd\u003e\u003ccode\u003epg_stat_progress_create_index\u003c/code\u003e\u003c/dd\u003e\u003cdt\u003e字段\u003c/dt\u003e\u003cdd\u003e\u003ccode\u003epartitions_done\u003c/code\u003e\u003c/dd\u003e\u003cdt\u003eSQL 类型\u003c/dt\u003e\u003cdd\u003e\u003ccode\u003ebigint\u003c/code\u003e\u003c/dd\u003e\u003c/dl\u003e\u003ch3\u003e同版本中文手册定义\u003c/h3\u003e\u003cp\u003e已创建或附加索引的分区数量，包括直接分区和间接分区。在 REINDEX 期间，或索引未分区时，此值为 0。\u003c/p\u003e\u003cp\u003e\u003ca href=\"/zh/docs/18/progress-reporting.html#\"\u003e查看完整中文手册与上下文\u003c/a\u003e。\u003c/p\u003e","documented":true,"facts":[{"label":"View","value":"pg_stat_progress_create_index"},{"label":"Field","value":"partitions_done"},{"label":"SQL type","value":"bigint"},{"label":"Units named in the field definition","value":"Not specified"},{"label":"Reset observation","value":"No stats_reset field is documented for this view"}],"facts_zh":[{"label":"视图","value":"pg_stat_progress_create_index"},{"label":"字段","value":"partitions_done"},{"label":"SQL 类型","value":"bigint"},{"label":"字段定义记载的单位","value":"未指定"},{"label":"重置条件","value":"手册未为此视图记载 stats_reset 字段"}],"field":"partitions_done","manual_html":"","manual_path":"/docs/18/progress-reporting.html","related":[{"label":"pg_stat_progress_create_index columns","url":"/wiki/catalog/pg_stat_progress_create_index/?v=18"},{"label":"Statistics collection and reset functions","url":"/docs/18/monitoring-stats.html"}],"release":{"channel":"stable","label":"18.6","major":"18","ref":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","revision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"},"sections":[{"paragraphs":["Whenever CREATE INDEX or REINDEX is running, the pg_stat_progress_create_index view will contain one row for each backend that is currently creating indexes. The tables below describe the information that will be reported and provide information about how to interpret it."],"title":"View semantics"},{"paragraphs":["Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name."],"title":"Collection and reset context"},{"code":"SELECT partitions_done FROM pg_catalog.pg_stat_progress_create_index;","paragraphs":["Example query; no execution result or measured value is asserted."],"title":"Inspect this field"}],"sections_zh":[{"paragraphs":["每当运行 CREATE INDEX 或 REINDEX 时， pg_stat_progress_create_index 视图将包含当前正在创建索引的每个后端的一行。下面的表描述了将要报告的信息，并提供了关于如何解释它的信息。"],"title":"视图语义"},{"paragraphs":["重置范围和可见性请参阅下方同版本的统计信息收集与视图文档。不根据字段名称推断各字段的重置规则。"],"title":"采集与重置语义"},{"code":"SELECT partitions_done FROM pg_catalog.pg_stat_progress_create_index;","paragraphs":["示例查询；不表示已执行，也不提供实测值。"],"title":"查看此字段"}],"signature":"SELECT partitions_done FROM pg_catalog.pg_stat_progress_create_index;","source_only":false,"sources":[{"label":"PostgreSQL 18 English manual","path":"progress-reporting.html","sha256":"a1f46d2b670502bfe75f1cf5192050ef2ef68202a8f928c4915abea0f4f71ae6","url":"/docs/18/progress-reporting.html#PG-STAT-PROGRESS-CREATE-INDEX-VIEW"}],"sql_type":"bigint","tables":[],"tables_zh":[],"units_mentioned":[],"view":"pg_stat_progress_create_index","zh_from":{"authored_translation":"source-derived-structured-summary","body_sha256":"8f539f033cf11676f149dea18f3a2b156db37abeb2a11ceb2537625bef3d2c0e","kind":"same-version-chinese-manual-with-source-derived-structured-summary","manual":{"anchor":"","build_id":107,"column":"partitions_done","extraction":"exact-catalog-field","locale":"zh-Hans","page_key":"progress-reporting.html","source_hash":"59d508f5be60d650bf0ed9ec10531162651c9eb030752aec3874544e10c879e2","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","url":"/zh/docs/18/progress-reporting.html#","version":"18"},"runtime_rerun":false,"source_facts_revision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}},"ManualEvidence":{"manual_path":"/docs/18/progress-reporting.html","release":{"channel":"stable","label":"18.6","major":"18","ref":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","revision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"},"sources":[{"label":"PostgreSQL 18 English manual","path":"progress-reporting.html","sha256":"a1f46d2b670502bfe75f1cf5192050ef2ef68202a8f928c4915abea0f4f71ae6","url":"/docs/18/progress-reporting.html#PG-STAT-PROGRESS-CREATE-INDEX-VIEW"}]},"MeasuredEvidence":{}},"Text":{"Collection":"metric","Key":"pg_stat_progress_create_index-partitions_done","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_stat_progress_create_index.partitions_done","Summary":"Number of partitions on which the index has already been created or attached, including both direct and indirect partitions. 0 during a REINDEX, or when the index is not partitioned.","BodyHTML":"\u003cp\u003eNumber of partitions on which the index has already been created or attached, including both direct and indirect partitions. 0 during a REINDEX, or when the index is not partitioned.\u003c/p\u003e","SourceRevision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","ContentHash":"5727739fbee273333841a1792bfe0ba34fff85684b118f470440dcc49f37cc7e","Payload":{"description":["Number of partitions on which the index has already been created or attached, including both direct and indirect partitions. 0 during a REINDEX, or when the index is not partitioned."],"manual_html":"","related":[{"label":"pg_stat_progress_create_index columns","url":"/wiki/catalog/pg_stat_progress_create_index/?v=18"},{"label":"Statistics collection and reset functions","url":"/docs/18/monitoring-stats.html"}],"sections":[{"paragraphs":["Whenever CREATE INDEX or REINDEX is running, the pg_stat_progress_create_index view will contain one row for each backend that is currently creating indexes. The tables below describe the information that will be reported and provide information about how to interpret it."],"title":"View semantics"},{"paragraphs":["Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name."],"title":"Collection and reset context"},{"code":"SELECT partitions_done FROM pg_catalog.pg_stat_progress_create_index;","paragraphs":["Example query; no execution result or measured value is asserted."],"title":"Inspect this field"}],"tables":[]}},"RequestedLocale":"en","Fallback":false,"Versions":["12","13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}