Имя: Пароль:
1C
1С v8
Помогите с планом запроса из технологического журнала.
0 ptiz
 
22.03.19
09:29
Этот запрос выполнялся 20 секунд.
За что отвечает каждая цифра в начале, до текста? Не могу найти расшифровку.

0, 0, 26.3, 0, 2.63E-006, 212, 1.05, 1,   |--Compute Scalar(DEFINE:([Expr1026]=CASE WHEN [fk].[dbo].[_Reference82].[_Fld14374RRef] as [T7].[_Fld14374RRef]=[@P1] THEN (1.0) ELSE CASE WHEN [fk].[dbo].[_Reference82].[_Fld14374RRef] as [T7].[_Fld14374RRef]=[@P2] THEN (2.0) ELSE CASE WHEN [fk].[dbo].[_Reference82].[_Fld14374RRef] as [T7].[_Fld14374RRef]=[@P3] THEN (3.0) ELSE CASE WHEN [fk].[dbo].[_Reference82].[_Fld14374RRef] as [T7].[_Fld14374RRef]=[@P4] THEN (4.0) ELSE CASE WHEN [fk].[dbo].[_Reference82].[_Fld14374RRef] as [T7].[_Fld14374RRef]=[@P5] THEN (5.0) ELSE (999.0) END END END END END, [Expr1027]=CASE WHEN [fk].[dbo].[_Reference82].[_Fld14374RRef] as [T7].[_Fld14374RRef]=[@P6] THEN (3.0) ELSE CASE WHEN [fk].[dbo].[_Reference82].[_Fld14374RRef] as [T7].[_Fld14374RRef]=[@P7] THEN (4.0) ELSE CASE WHEN [fk].[dbo].[_Reference82].[_Fld14374RRef] as [T7].[_Fld14374RRef]=[@P8] THEN (5.0) ELSE CASE WHEN [fk].[dbo].[_Reference82].[_Fld14374RRef] as [T7].[_Fld14374RRef]=[@P9] THEN (2.0) ELSE CASE WHEN [fk].[dbo].[_Reference82].[_Fld14374RRef] as [T7].[_Fld14374RRef]=[@P10] THEN (1.0) ELSE (999.0) END END END END END, [Expr1028]=[fk].[dbo].[_AccumRgT10170].[_Fld10164] as [T2].[_Fld10164]-[Expr1032], [Expr1029]=([fk].[dbo].[_AccumRgT10170].[_Fld10164] as [T2].[_Fld10164]-[Expr1032])-[Expr1033]))
523, 1, 26.3, 0, 0.00011, 215, 1.05, 1,        |--Nested Loops(Left Outer Join, OUTER REFERENCES:([T2].[_Fld10163RRef], [Expr1038]) WITH UNORDERED PREFETCH)
523, 1, 26.3, 0, 0.00011, 210, 0.974, 1,             |--Nested Loops(Left Outer Join, OUTER REFERENCES:([T2].[_Fld10162RRef], [Expr1037]) WITH UNORDERED PREFETCH)
523, 1, 26.3, 0, 0.00011, 198, 0.902, 1,             |    |--Nested Loops(Left Outer Join, OUTER REFERENCES:([T2].[_Fld10161RRef], [Expr1036]) WITH UNORDERED PREFETCH)
0, 0, 26.3, 0, 2.63E-006, 110, 0.827, 1,             |    |    |--Compute Scalar(DEFINE:([Expr1033]=isnull([tempdb].[dbo].[#tt87].[_Q_000_F_004] as [T6].[_Q_000_F_004],(0.))))
523, 1, 26.3, 0, 0.00088, 110, 0.827, 1,             |    |    |    |--Nested Loops(Left Outer Join, WHERE:([fk].[dbo].[_AccumRgT10170].[_Fld10162RRef] as [T2].[_Fld10162RRef]=[tempdb].[dbo].[#tt87].[_Q_000_F_002RRef] as [T6].[_Q_000_F_002RRef] AND [fk].[dbo].[_AccumRgT10170].[_Fld10163RRef] as [T2].[_Fld10163RRef]=[tempdb].[dbo].[#tt87].[_Q_000_F_003RRef] as [T6].[_Q_000_F_003RRef] AND [fk].[dbo].[_AccumRgT10170].[_Fld10161RRef] as [T2].[_Fld10161RRef]=[tempdb].[dbo].[#tt87].[_Q_000_F_001RRef] as [T6].[_Q_000_F_001RRef]))
523, 1, 26.3, 0, 5.97E-005, 97, 0.82, 1,             |    |    |         |--Filter(WHERE:(([fk].[dbo].[_AccumRgT10170].[_Fld10164] as [T2].[_Fld10164]-[Expr1032])>(0.000)))
0, 0, 87.7, 0, 8.77E-006, 97, 0.82, 1,             |    |    |         |    |--Compute Scalar(DEFINE:([Expr1032]=isnull([tempdb].[dbo].[#tt81].[_Q_000_F_003] as [T5].[_Q_000_F_003],(0.000))))
554, 1, 87.7, 0, 0.0248, 97, 0.82, 1,             |    |    |         |         |--Hash Match(Left Outer Join, HASH:([T2].[_Fld10162RRef], [T2].[_Fld10163RRef], [T2].[_Fld10161RRef])=([T5].[_Q_000_F_000RRef], [T5].[_Q_000_F_001RRef], [T5].[_Q_000_F_002RRef]), RESIDUAL:([fk].[dbo].[_AccumRgT10170].[_Fld10162RRef] as [T2].[_Fld10162RRef]=[tempdb].[dbo].[#tt81].[_Q_000_F_000RRef] as [T5].[_Q_000_F_000RRef] AND [fk].[dbo].[_AccumRgT10170].[_Fld10163RRef] as [T2].[_Fld10163RRef]=[tempdb].[dbo].[#tt81].[_Q_000_F_001RRef] as [T5].[_Q_000_F_001RRef] AND [fk].[dbo].[_AccumRgT10170].[_Fld10161RRef] as [T2].[_Fld10161RRef]=[tempdb].[dbo].[#tt81].[_Q_000_F_002RRef] as [T5].[_Q_000_F_002RRef]))
554, 1, 75.6, 0, 0.000316, 84, 0.79, 1,             |    |    |         |              |--Nested Loops(Left Semi Join, OUTER REFERENCES:([T2].[_Fld10162RRef]))
554, 1, 75.6, 0, 0.000313, 84, 0.774, 1,             |    |    |         |              |    |--Nested Loops(Left Semi Join, OUTER REFERENCES:([T2].[_Fld10163RRef]))
554, 1, 74.8, 0, 0.0245, 84, 0.759, 1,             |    |    |         |              |    |    |--Hash Match(Right Semi Join, HASH:([T10].[_INVALUELISTRRef])=([T2].[_Fld10162RRef]), RESIDUAL:([fk].[dbo].[_AccumRgT10170].[_Fld10162RRef] as [T2].[_Fld10162RRef]=[tempdb].[dbo].[#tt128].[_INVALUELISTRRef] as [T10].[_INVALUELISTRRef]))
199, 1, 199, 0.00313, 0.000376, 23, 0.0035, 1,             |    |    |         |              |    |    |    |--Index Seek(OBJECT:([tempdb].[dbo].[#tt128] AS [T10]), SEEK:([T10].[_INVALUELISTRRef] IsNotNull) ORDERED FORWARD)
554, 1, 349, 0, 0.142, 84, 0.731, 1,             |    |    |         |              |    |    |    |--Hash Match(Inner Join, HASH:([T4].[_INVALUELISTRRef])=([T2].[_Fld10163RRef]), RESIDUAL:([fk].[dbo].[_AccumRgT10170].[_Fld10163RRef] as [T2].[_Fld10163RRef]=[tempdb].[dbo].[#tt129].[_INVALUELISTRRef] as [T4].[_INVALUELISTRRef]))
199, 1, 199, 0, 0.000199, 23, 0.0037, 1,             |    |    |         |              |    |    |         |--Stream Aggregate(GROUP BY:([T4].[_INVALUELISTRRef]))
199, 1, 199, 0.00313, 0.000376, 23, 0.0035, 1,             |    |    |         |              |    |    |         |    |--Index Seek(OBJECT:([tempdb].[dbo].[#tt129] AS [T4]), SEEK:([T4].[_INVALUELISTRRef] IsNotNull) ORDERED FORWARD)
27346, 1, 1.83E+004, 0.509, 0.0427, 84, 0.551, 1,             |    |    |         |              |    |    |         |--Clustered Index Seek(OBJECT:([fk].[dbo].[_AccumRgT10170].[_Accum10170_ByDims_TRRRR] AS [T2]), SEEK:([T2].[_Period]=[@P11] AND [T2].[_Fld10160RRef]=[@P12]),  WHERE:([fk].[dbo].[_AccumRgT10170].[_Fld10164] as [T2].[_Fld10164]<(0.000) OR [fk].[dbo].[_AccumRgT10170].[_Fld10164] as [T2].[_Fld10164]>(0.000)) ORDERED FORWARD)
554, 554, 1, 0.00313, 0.000158, 23, 0.015, 74.8,             |    |    |         |              |    |    |--Index Seek(OBJECT:([tempdb].[dbo].[#tt127] AS [T11]), SEEK:([T11].[_INVALUELISTRRef]=[fk].[dbo].[_AccumRgT10170].[_Fld10163RRef] as [T2].[_Fld10163RRef]),  WHERE:([tempdb].[dbo].[#tt127].[_INVALUELISTRRef] as [T11].[_INVALUELISTRRef] IS NOT NULL) ORDERED FORWARD)
554, 554, 1, 0.00313, 0.000158, 23, 0.0151, 75.6,             |    |    |         |              |    |--Index Seek(OBJECT:([tempdb].[dbo].[#tt130] AS [T3]), SEEK:([T3].[_INVALUELISTRRef]=[fk].[dbo].[_AccumRgT10170].[_Fld10162RRef] as [T2].[_Fld10162RRef]),  WHERE:([tempdb].[dbo].[#tt130].[_INVALUELISTRRef] as [T3].[_INVALUELISTRRef] IS NOT NULL) ORDERED FORWARD)
284, 1, 284, 0.00535, 0.000469, 68, 0.00582, 1,             |    |    |         |              |--Table Scan(OBJECT:([tempdb].[dbo].[#tt81] AS [T5]))
4184, 523, 8, 0.0032, 8.73E-005, 68, 0.0055, 26.3,             |    |    |         |--Table Scan(OBJECT:([tempdb].[dbo].[#tt87] AS [T6]))
523, 523, 1, 0.00313, 0.000158, 94, 0.0748, 26.3,             |    |    |--Clustered Index Seek(OBJECT:([fk].[dbo].[_Reference82].[PK___Referen__AC8ED0C43DB4BC3B] AS [T7]), SEEK:([T7].[_IDRRef]=[fk].[dbo].[_AccumRgT10170].[_Fld10161RRef] as [T2].[_Fld10161RRef]) ORDERED FORWARD)
523, 523, 1, 0.00313, 0.000158, 19, 0.0722, 26.3,             |    |--Clustered Index Seek(OBJECT:([fk].[dbo].[_Reference37].[PK___Referen__AC8ED0C45681355C] AS [T8]), SEEK:([T8].[_IDRRef]=[fk].[dbo].[_AccumRgT10170].[_Fld10162RRef] as [T2].[_Fld10162RRef]) ORDERED FORWARD)
523, 523, 1, 0.00313, 0.000158, 12, 0.075, 26.3,             |--Clustered Index Seek(OBJECT:([fk].[dbo].[_Reference78].[PK___Referen__AC8ED0C46EADC4A8] AS [T9]), SEEK:([T9].[_IDRRef]=[fk].[dbo].[_AccumRgT10170].[_Fld10163RRef] as [T2].[_Fld10163RRef]) ORDERED FORWARD)
1 ptiz
 
22.03.19
11:12
Спецы по SQL, вы куда пропали?
2 Timon1405
 
22.03.19
11:30
(0) гадаете по фотографии?
Rows, Executes, Estimate rows, Estimate IO, Estimate CPU, Avg row size, Totat subtree cost, Estimate executions
3 polosov
 
22.03.19
11:46
(1) Лучше покажи эту дичь в формате запроса 1с.
4 ptiz
 
22.03.19
11:51
(2) О! Спасибо. А где это можно было найти?
5 ptiz
 
22.03.19
12:03
(3) А в чем дичь?
Смотрю на этот план - ничего криминального не вижу. Или я не прав?
Просто выскочило странно долгое время (обычно тут затыков нет), решил поковыряться.

Суть запроса простая:
                          |    РегистрНакопления.ЯчейкиСклада.Остатки(
                          |            &ДатаОстатков,
                          |            Склад = &Склад
                          |                И Номенклатура В (&МассивНоменклатуры)
                          |                И Серия В (&МассивСерий)) КАК ЯчейкиСкладаОстатки
                          |        ЛЕВОЕ СОЕДИНЕНИЕ РезервыЯчеек КАК РезервыЯчеек
                          |        ПО ЯчейкиСкладаОстатки.Номенклатура = РезервыЯчеек.Номенклатура
                          |            И ЯчейкиСкладаОстатки.Серия = РезервыЯчеек.Серия
                          |            И ЯчейкиСкладаОстатки.Ячейка = РезервыЯчеек.Ячейка
                          |        ЛЕВОЕ СОЕДИНЕНИЕ РасходВЗаданиях КАК РасходВЗаданиях
                          |        ПО ЯчейкиСкладаОстатки.Номенклатура = РасходВЗаданиях.Номенклатура
                          |            И ЯчейкиСкладаОстатки.Серия = РасходВЗаданиях.Серия
                          |            И ЯчейкиСкладаОстатки.Ячейка = РасходВЗаданиях.Ячейка