for _r in 
			select *
			from dblink(_cs,  /* здесь быстро */
			$$
				select id, ext_id, deal_id, create_moment, amount, statement_id
				from main.deferred_transaction 
				where statement_id is not null and id > $$ || _last_trn_id::text || $$
				order by id
				limit 10000
			$$
			) as trn(id int, ext_id text, deal_id int, create_moment timestamp, amount numeric, statement_id text)
	loop
	_ma := clock_timestamp();
	perform platbox.transaction_insert(_r.id, _r.ext_id, _r.deal_id, _r.create_moment, _r.amount);
	_mb := clock_timestamp();
	perform platbox.transaction_confirm(ARRAY[_r.id], _r.statement_id);
	_i := _i + 1;
	_da := _da + (_mb - _ma);
	_db := _db + (clock_timestamp() - _mb);

	if _i % 1000 = 0 then
		raise notice '%: % (% + %)', _i, _da + _db, _da, _db;
		_da := 0; _db := 0;
		end if;
		
	end loop;
/*
первая партия 10000:
NOTICE:  start 12:39:34.369506
NOTICE:  1000: 00:00:02.846582 (00:00:02.185875 + 00:00:00.660707)
NOTICE:  2000: 00:00:04.500944 (00:00:03.475017 + 00:00:01.025927)
NOTICE:  3000: 00:00:06.143909 (00:00:04.754663 + 00:00:01.389246)
NOTICE:  4000: 00:00:07.799562 (00:00:06.039108 + 00:00:01.760454)
NOTICE:  5000: 00:00:09.518673 (00:00:07.373768 + 00:00:02.144905)
NOTICE:  6000: 00:00:11.664035 (00:00:09.073877 + 00:00:02.590158)
NOTICE:  7000: 00:00:13.533564 (00:00:10.485787 + 00:00:03.047777)
NOTICE:  8000: 00:00:15.483501 (00:00:11.951818 + 00:00:03.531683)
NOTICE:  9000: 00:00:17.455596 (00:00:13.453719 + 00:00:04.001877)
NOTICE:  10000: 00:00:19.399203 (00:00:14.943903 + 00:00:04.4553)
NOTICE:  10000, finish 12:41:22.902658
Запрос успешно выполнен без возвращаемых данных за 108939 мс.

вторая партия 10000:
NOTICE:  start 12:41:44.797815
NOTICE:  1000: 00:00:06.803871 (00:00:03.328762 + 00:00:03.475109)
NOTICE:  2000: 00:00:08.596835 (00:00:04.720047 + 00:00:03.876788)
NOTICE:  3000: 00:00:07.686614 (00:00:05.962124 + 00:00:01.72449)
NOTICE:  4000: 00:00:07.666654 (00:00:07.02673 + 00:00:00.639924)
NOTICE:  5000: 00:00:08.905079 (00:00:08.215187 + 00:00:00.689892)
NOTICE:  6000: 00:00:10.162505 (00:00:09.412222 + 00:00:00.750283)
NOTICE:  7000: 00:00:11.417373 (00:00:10.60263 + 00:00:00.814743)
NOTICE:  8000: 00:00:12.674767 (00:00:11.793804 + 00:00:00.880963)
NOTICE:  9000: 00:00:14.017387 (00:00:13.055482 + 00:00:00.961905)
NOTICE:  10000: 00:00:15.357751 (00:00:14.318372 + 00:00:01.039379)
NOTICE:  10000, finish 12:43:30.04386
Запрос успешно выполнен без возвращаемых данных за 105650 мс.

третья партия 10000:
NOTICE:  start 12:44:38.612634
NOTICE:  1000: 00:00:02.700358 (00:00:02.182794 + 00:00:00.517564)
NOTICE:  2000: 00:00:04.320822 (00:00:03.764731 + 00:00:00.556091)
NOTICE:  3000: 00:00:05.972332 (00:00:05.366343 + 00:00:00.605989)
NOTICE:  4000: 00:00:07.623809 (00:00:06.97151 + 00:00:00.652299)
NOTICE:  5000: 00:00:09.230104 (00:00:08.539776 + 00:00:00.690328)
NOTICE:  6000: 00:00:10.847671 (00:00:10.116547 + 00:00:00.731124)
NOTICE:  7000: 00:00:12.545055 (00:00:11.74776 + 00:00:00.797295)
NOTICE:  8000: 00:00:14.328765 (00:00:13.45609 + 00:00:00.872675)
NOTICE:  9000: 00:00:16.194939 (00:00:15.244556 + 00:00:00.950383)
NOTICE:  10000: 00:00:18.077916 (00:00:17.044863 + 00:00:01.033053)
NOTICE:  10000, finish 12:46:20.754079
Запрос успешно выполнен без возвращаемых данных за 102570 мс.

(выполняем VACUUM ANALYZE)

и снова...
NOTICE:  start 12:57:16.7977
NOTICE:  1000: 00:00:02.776203 (00:00:02.264289 + 00:00:00.511914)
NOTICE:  2000: 00:00:04.461631 (00:00:03.902963 + 00:00:00.558668)
NOTICE:  3000: 00:00:06.15496 (00:00:05.549169 + 00:00:00.605791)
NOTICE:  4000: 00:00:07.842916 (00:00:07.191169 + 00:00:00.651747)
NOTICE:  5000: 00:00:09.485969 (00:00:08.782869 + 00:00:00.7031)
NOTICE:  6000: 00:00:11.201791 (00:00:10.436283 + 00:00:00.765508)
NOTICE:  7000: 00:00:12.913846 (00:00:12.089559 + 00:00:00.824287)
NOTICE:  8000: 00:00:14.71476 (00:00:13.814709 + 00:00:00.900051)
NOTICE:  9000: 00:00:16.512243 (00:00:15.53318 + 00:00:00.979063)
NOTICE:  10000: 00:00:18.417055 (00:00:17.351377 + 00:00:01.065678)
NOTICE:  10000, finish 12:59:01.516679
Запрос успешно выполнен без возвращаемых данных за 105114 мс.

*/

do
$$
declare _i int;
begin

	create temporary table hot_test(num int, amount numeric) on commit drop;
	
	insert into hot_test values (1, 1234), (2, 2345), (3, 3456), (4, 4567);
	for _i in 1..1000 loop
		update hot_test set num = num, amount = amount;
		end loop;
	
end
$$
/*
1000 - 102 ms
5000 - 1778 ms
10000 - 6844 ms
*/