PostgreSQL对象重组工具【pg_reorg】(三)
t: CREATE TYPE reorg.pk_16843 AS (id integer)
LOG: statement: CREATE TABLE reorg.log_16843 (id bigserial PRIMARY KEY, pkreorg.pk_16843, row t1)
LOG: statement: CREATE TRIGGER z_reorg_trigger BEFORE INSERT OR DELETE ORUPDATE ON t1 FOR EACH ROW EXECUTE PROCEDURE reorg.reorg_trigger('INSERT INTOreorg.log_16843(pk, row) VALUES( CASE WHEN $1 IS NULL THEN NULL ELSE(ROW($1.id)::reorg.pk_16843) END, $2)')
LOG: statement: SELECT reorg.disable_autovacuum('reorg.log_16843')
LOG: statement: COMMIT
LOG: statement: BEGIN ISOLATION LEVEL SERIALIZABLE
LOG: statement: SELECT set_config('work_mem',current_setting('maintenance_work_mem'), true)
LOG: statement: SET LOCAL synchronize_seqscans = off
LOG: statement: SELECT reorg.array_accum(virtualtransaction) FROM pg_locksWHERE locktype = 'virtualxid' AND pid <> pg_backend_pid() AND(virtualxid, virtualtransaction) <> ('1/1', '-1/0')
LOG: statement: DELETE FROM reorg.log_16843
LOG: statement: CREATE TABLE reorg.table_16843 WITH (oids=false) TABLESPACEpg_default AS SELECT id,name FROM ONLY t1
LOG: statement: SELECT reorg.disable_autovacuum('reorg.table_16843')
LOG: statement: COMMIT
LOG: execute : SELECT indexrelid,reorg.reorg_indexdef(indexrelid, indrelid), indisvalid,pg_get_indexdef(indexrelid) FROM pg_index WHERE indrelid = $1
DETAIL: parameters: $1 = '16843'
LOG: statement: CREATE UNIQUE INDEX index_16849 ON reorg.table_16843 USINGbtree (id)
LOG: execute : SELECT reorg.reorg_apply($1, $2, $3, $4, $5,$6)
DETAIL: parameters: $1 = 'SELECT * FROM reorg.log_16843 ORDER BY id LIMIT $1',$2 = 'INSERT INTO reorg.table_16843 VALUES ($1.*)', $3 = 'DELETE FROMreorg.table_16843 WHERE (id) = ($1.id)', $4 = 'UPDATE reorg.table_16843 SET(id, name) = ($2.id, $2.name) WHERE (id) = ($1.id)', $5 = 'DELETE FROMreorg.log_16843 WHERE id = $1', $6 = '1000'
LOG: execute
: SELECT pid FROM pg_locks WHERE locktype ='virtualxid' AND pid <> pg_backend_pid() AND virtualtransaction = ANY($1)
DETAIL: parameters: $1 = '{}'
LOG: statement: BEGIN ISOLATION LEVEL READ COMMITTED
LOG: statement: SET LOCAL statement_timeout = 100
LOG: statement: LOCK TABLE t1 IN ACCESS EXCLUSIVE MODE
LOG: statement: RESET statement_timeout
LOG: execute : SELECT reorg.reorg_apply($1, $2, $3, $4, $5,$6)
DETAIL: parameters: $1 = 'SELECT * FROM reorg.log_16843 ORDER BY id LIMIT $1',$2 = 'INSERT INTO reorg.table_16843 VALUES ($1.*)', $3 = 'DELETE FROMreorg.table_16843 WHERE (id) = ($1.id)', $4 = 'UPDATE reorg.table_16843 SET(id, name) = ($2.id, $2.name) WHERE (id) = ($1.id)', $5 = 'DELETE FROMreorg.log_16843 WHERE id = $1', $6 = '0'
LOG: execute : SELECT reorg.reorg_swap($1)
DETAIL: parameters: $1 = '16843'
LOG: statement: COMMIT
LOG: statement: BEGIN ISOLATION LEVEL READ COMMITTED
LOG: execute : SELECT reorg.reorg_drop($1)
DETAIL: parameters: $1 = '16843'
LOG: statement: COMMIT
LOG: statement: BEGIN ISOLATION LEVEL READ COMMITTED
LOG: statement: ANALYZE t1
LOG: statement: COMMIT