![]() Columns blocks_total (set to the total size of the index) and blocks_done contain the progress information for this phase.ĬREATE INDEX CONCURRENTLY is sorting the output of the index scanning phase.ĬREATE INDEX CONCURRENTLY is scanning the table to validate the index tuples collected in the previous two phases. This phase is skipped when not in concurrent mode. Columns lockers_total, lockers_done and current_locker_pid contain the progress information for this phase.ĬREATE INDEX CONCURRENTLY is scanning the index searching for tuples that need to be validated. Typically, blocks_total and blocks_done will contain progress data, as well as potentially tuples_total and tuples_done.ĬREATE INDEX CONCURRENTLY or REINDEX CONCURRENTLY is waiting for transactions with write locks that can potentially write into the table to finish. In this phase, access methods that support progress reporting fill in their own progress data, and the subphase is indicated in this column. The index is being built by the access method-specific code. Columns lockers_total, lockers_done and current_locker_pid contain the progress information for this phase. This phase is expected to be very brief.ĬREATE INDEX CONCURRENTLY or REINDEX CONCURRENTLY is waiting for transactions with write locks that can potentially see the table to finish. This field is 0 during a REINDEX.ĬREATE INDEX or REINDEX is preparing to create the index. When creating an index on a partitioned table, this column is set to the number of partitions on which the index has been created. When creating an index on a partitioned table, this column is set to the total number of partitions on which the index is to be created. Number of tuples already processed in the current phase. ![]() Total number of tuples to be processed in the current phase. Number of blocks already processed in the current phase. Total number of blocks to be processed in the current phase. Process ID of the locker currently being waited for. Total number of lockers to wait for, when applicable. The command that is running: CREATE INDEX, CREATE INDEX CONCURRENTLY, REINDEX, or REINDEX CONCURRENTLY.Ĭurrent processing phase of index creation. During a non-concurrent CREATE INDEX, this is 0. OID of the index being created or reindexed. OID of the table on which the index is being created. Name of the database to which this backend is connected. OID of the database to which this backend is connected.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |