explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FYea

Settings
# exclusive inclusive rows x rows loops node
1. 245.910 727.923 ↓ 3.4 13,646 1

insert on pg_temp_3.tt17 (cost=0.22..98,791.43 rows=4,027 width=73) (actual time=0.731..727.923 rows=13,646 loops=1)

  • output: 0
  • buffers: shared hit=11634, local hit=42842 read=409 dirtied=407
2. 160.908 482.013 ↓ 3.4 13,646 1

nested loop (cost=0.22..98,791.43 rows=4,027 width=73) (actual time=0.293..482.013 rows=13,646 loops=1)

  • output: 'модификатор_3-4_втдокументыотобранные'::mvarchar(37), t1._q_001_f_001_type, t1._q_001_f_001_rtref, t1._q_001_f_001_rrref, t1._q_001_f_002rref
  • buffers: shared hit=11634, local hit=25
3. 7.540 7.540 ↑ 1.0 1,445 1

seq scan on pg_temp_3.tt15 t1 (cost=0.00..39.45 rows=1,445 width=41) (actual time=0.016..7.540 rows=1,445 loops=1)

  • output: t1._q_001_f_000, t1._q_001_f_001_type, t1._q_001_f_001_rtref, t1._q_001_f_001_rrref, t1._q_001_f_002rref
  • buffers: local hit=25
4. 313.565 313.565 ↓ 4.5 9 1,445

index scan using РегистрНакопления.ЗаказыКлиентов_3 on public.РегистрНакопления.ЗаказыКлиентов t2 (cost=0.22..68.32 rows=2 width=41) (actual time=0.146..0.217 rows=9 loops=1,445)

  • output: t2.Период, t2._recordertref, t2._recorderrref, t2._lineno, t2.Активность, t2.ВидДвижения, t2.ЗаказКлиента, t2.ЗаказКлиента, t2.ЗаказКлиента, t2._fld34102rref, t2._fld34103rref, t2._fld34104, t2.Склад, t2._fld73121rref, t2._fld34106, t2.КОформлению, t2._fld34108, t2._fld34109rref, t2.ОбластьДанныхОсновныеДанные
  • index cond: ((t2.ОбластьДанныхОсновныеДанные = '0'::numeric) and (t2.ЗаказКлиента = t1._q_001_f_001_type) and (t2.ЗаказКлиента = t1._q_001_f_001_rtref) and (t2.ЗаказКлиента = t1._q_001_f_001_rrref))
  • filter: (t2.Активность and (t2.КОформлению > '0'::numeric) and (t2.ВидДвижения = '1'::numeric) and (t1._q_001_f_002rref = t2.Склад))
  • rows removed by filter: 22
  • buffers: shared hit=11634
Planning time : 0.839 ms
Execution time : 904.779 ms