|
Помогите с планом запроса из технологического журнала. | ☑ | ||
---|---|---|---|---|
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) А в чем дичь?
Смотрю на этот план - ничего криминального не вижу. Или я не прав? Просто выскочило странно долгое время (обычно тут затыков нет), решил поковыряться. Суть запроса простая: | РегистрНакопления.ЯчейкиСклада.Остатки( | &ДатаОстатков, | Склад = &Склад | И Номенклатура В (&МассивНоменклатуры) | И Серия В (&МассивСерий)) КАК ЯчейкиСкладаОстатки | ЛЕВОЕ СОЕДИНЕНИЕ РезервыЯчеек КАК РезервыЯчеек | ПО ЯчейкиСкладаОстатки.Номенклатура = РезервыЯчеек.Номенклатура | И ЯчейкиСкладаОстатки.Серия = РезервыЯчеек.Серия | И ЯчейкиСкладаОстатки.Ячейка = РезервыЯчеек.Ячейка | ЛЕВОЕ СОЕДИНЕНИЕ РасходВЗаданиях КАК РасходВЗаданиях | ПО ЯчейкиСкладаОстатки.Номенклатура = РасходВЗаданиях.Номенклатура | И ЯчейкиСкладаОстатки.Серия = РасходВЗаданиях.Серия | И ЯчейкиСкладаОстатки.Ячейка = РасходВЗаданиях.Ячейка |
Форум | Правила | Описание | Объявления | Секции | Поиск | Книга знаний | Вики-миста |