explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OtXq

Settings
# exclusive inclusive rows x rows loops node
1. 19,771.665 40,565.674 ↓ 1.8 921,611 1

insert on pg_temp_7.tt5 (cost=1.13..113,412.76 rows=524,486 width=73) (actual time=0.594..40,565.674 rows=921,611 loops=1)

  • output: 0
  • buffers: shared hit=70,626, local hit=3,686,223 read=67,624 dirtied=67,500 written=66,556
2. 9,946.414 20,794.009 ↓ 1.8 921,611 1

hash semi join (cost=1.13..113,412.76 rows=524,486 width=73) (actual time=0.192..20,794.009 rows=921,611 loops=1)

  • output: 'модификатор_3_втдокументыотобранные'::mvarchar(35), t1.ЗаказКлиента, t1.ЗаказКлиента, t1.ЗаказКлиента, t1.Склад
  • hash cond: (t1.Склад = t2._q_001_f_001rref)
  • buffers: shared hit=70,626, local hit=1
3. 10,847.499 10,847.499 ↓ 1.5 930,937 1

seq scan on public.РегистрНакопления.ЗаказыКлиентов t1 (cost=0.00..107,288.26 rows=611,900 width=41) (actual time=0.072..10,847.499 rows=930,937 loops=1)

  • output: t1.Период, t1._recordertref, t1._recorderrref, t1._lineno, t1.Активность, t1.ВидДвижения, t1.ЗаказКлиента, t1.ЗаказКлиента, t1.ЗаказКлиента, t1._fld34102rref, t1._fld34103rref, t1._fld34104, t1.Склад, t1._fld73121rref, t1._fld34106, t1.КОформлению, t1._fld34108, t1._fld34109rref, t1.ОбластьДанныхОсновныеДанные
  • filter: (t1.Активность and (t1.КОформлению > '0'::numeric) and (t1.ОбластьДанныхОсновныеДанные = '0'::numeric) and (t1.ВидДвижения = '1'::numeric))
  • rows removed by filter: 1,889,070
  • buffers: shared hit=70,626
4. 0.049 0.096 ↑ 1.0 6 1

hash (cost=1.06..1.06 rows=6 width=17) (actual time=0.091..0.096 rows=6 loops=1)

  • output: t2._q_001_f_001rref
  • buckets: 1,024 batches: 1 memory usage: 9kb
  • buffers: local hit=1
5. 0.047 0.047 ↑ 1.0 6 1

seq scan on pg_temp_7.tt4 t2 (cost=0.00..1.06 rows=6 width=17) (actual time=0.012..0.047 rows=6 loops=1)

  • output: t2._q_001_f_001rref
  • buffers: local hit=1
Planning time : 0.902 ms
Execution time : 46,073.198 ms