Advertisement
Guest User

Untitled

a guest
Feb 11th, 2019
202
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.82 KB | None | 0 0
  1. WITH cte_000000000B91F4D0_17 AS (SELECT t_03.puid AS revPuid, t_04.pdate_released AS revDateRel, t_03.ritems_tagu AS myItem, t_04.puid AS rlsPuid, t_04.pname AS rlsName FROM PWORKSPACEOBJECT t_01 , PRELEASE_STATUS_LIST t_02 , PITEMREVISION t_03 , PRELEASESTATUS t_04,#PRefbindtag3 WHERE ( ( ( ( ( t_03.ritems_tagu = #PRefbindtag3.puid AND ( t_04.pdate_released <= CONVERT(datetime, '2019-02-10 17:15:42', 120) ) ) AND ( t_04.pname = 'F' ) ) AND ( t_02.pvalu_0 = t_04.puid ) ) AND ( t_01.pactive_seq != 0 ) ) AND ( t_01.puid = t_02.puid AND t_02.puid = t_03.puid ) ) ) SELECT DISTINCT t_06.myItem, t_06.revPuid, t_07.rDate, t_06.rlsPuid FROM cte_000000000B91F4D0_17 t_06 , (SELECT MAX ( t_05.revDateRel ) AS rDate, t_05.myItem AS dtItem FROM cte_000000000B91F4D0_17 t_05 GROUP BY t_05.myItem) t_07 WHERE ( ( ( t_06.myItem = t_07.dtItem ) AND ( t_06.revDateRel = t_07.rDate ) ) AND ( t_06.rlsName = 'F' ) ) ORDER BY t_07.rDate DESC ;
  2. NOTE - 2019/2/10-17:18:35.192 UTC - PC3550.10336.01.XXX.00090 - ===>Took 137.142 seconds to execute that SQL (returning 76 rows) - Teamcenter.POM at D:\workdir\tc10171a01x_win64\src\foundation\pom\eim\eim_enquire.cxx(5722)
  3. Subtree Cost: Est.IO: Est.Cpu: Est.Rows Statement Text:
  4. ____________________________________________________________________________________
  5. 1.32190299 0.0000 0.0000 1 WITH cte_000000000B91F4D0_17 AS (SELECT t_03.puid AS revPuid, t_04.pdate_released AS revDateRel, t_03.ritems_tagu AS myItem, t_04.puid AS rlsPuid, t_04.pname AS rlsName FROM PWORKSPACEOBJECT t_01 , PRELEASE_STATUS_LIST t_02 , PITEMREVISION t_03 , PRELEASESTATUS t_04,#PRefbindtag3 WHERE ( ( ( ( ( t
  6. 1.32190299 0.0113 0.0001 1 |--Sort(DISTINCT ORDER BY:([Expr1014] DESC, [t_03].[puid] ASC, [t_04].[puid] ASC))
  7. 1.31054175 0.0000 0.0000 1 |--Nested Loops(Inner Join, OUTER REFERENCES:([t_03].[puid]) OPTIMIZED)
  8. 1.30725384 0.0000 0.0000 1 |--Nested Loops(Inner Join, OUTER REFERENCES:([t_03].[puid], [t_04].[puid]))
  9. 1.30396664 0.0000 0.0000 1 | |--Nested Loops(Inner Join, OUTER REFERENCES:([Expr1014]))
  10. 1.30066180 0.0000 0.0000 1 | | |--Nested Loops(Inner Join, OUTER REFERENCES:([t_03].[ritems_tagu]))
  11. 1.29737389 0.0000 0.0220 1 | | | |--Hash Match(Inner Join, HASH:([t_03].[ritems_tagu])=([tempdb].[dbo].[#PRefbindtag3].[puid]), RESIDUAL:([tempdb].[dbo].[#PRefbindtag3].[puid]=[TCEUP01].[dbo].[PITEMREVISION].[ritems_tagu] as [t_03].[ritems_tagu]))
  12. 1.27095151 0.0000 0.0003 70 | | | | |--Stream Aggregate(GROUP BY:([t_03].[ritems_tagu]) DEFINE:([Expr1014]=MAX([TCEUP01].[dbo].[PRELEASESTATUS].[pdate_released] as [t_04].[pdate_released])))
  13. 1.27068985 0.0000 0.0016 378 | | | | | |--Nested Loops(Inner Join, OUTER REFERENCES:([t_03].[puid], [Expr1018]) WITH ORDERED PREFETCH)
  14. 0.98885566 0.0000 0.0019 378 | | | | | |--Nested Loops(Inner Join, OUTER REFERENCES:([t_02].[pvalu_0], [Expr1017]) WITH ORDERED PREFETCH)
  15. 0.65494531 0.0000 0.0019 449 | | | | | | |--Nested Loops(Inner Join, OUTER REFERENCES:([t_03].[puid], [Expr1016]) WITH ORDERED PREFETCH)
  16. 0.32131171 0.0000 0.0019 448 | | | | | | | |--Nested Loops(Inner Join, OUTER REFERENCES:([tempdb].[dbo].[#PRefbindtag3].[puid], [Expr1015]) WITH ORDERED PREFETCH)
  17. 0.02131891 0.0113 0.0056 406 | | | | | | | | |--Sort(ORDER BY:([tempdb].[dbo].[#PRefbindtag3].[puid] ASC))
  18. 0.00446934 0.0039 0.0006 406 | | | | | | | | | |--Table Scan(OBJECT:([tempdb].[dbo].[#PRefbindtag3]))
  19. 0.29812005 0.0031 0.0002 1 | | | | | | | | |--Index Seek(OBJECT:([TCEUP01].[dbo].[PITEMREVISION].[PIPITEMREVISION_0] AS [t_03]), SEEK:([t_03].[ritems_tagu]=[tempdb].[dbo].[#PRefbindtag3].[puid]) ORDERED FORWARD)
  20. 0.33175850 0.0031 0.0002 1 | | | | | | | |--Clustered Index Seek(OBJECT:([TCEUP01].[dbo].[PRELEASE_STATUS_LIST].[PIPRELEASE_STATUS] AS [t_02]), SEEK:([t_02].[puid]=[TCEUP01].[dbo].[PITEMREVISION].[puid] as [t_03].[puid]) ORDERED FORWARD)
  21. 0.33203524 0.0031 0.0002 1 | | | | | | |--Index Seek(OBJECT:([TCEUP01].[dbo].[PRELEASESTATUS].[PIPRELEASESTATU_0] AS [t_04]), SEEK:([t_04].[puid]=[TCEUP01].[dbo].[PRELEASE_STATUS_LIST].[pvalu_0] as [t_02].[pvalu_0] AND [t_04].[pname]='F' AND [t_04].[pdate_released] <= '2019-02-10 17:15:42.
  22. 0.28007069 0.0031 0.0002 1 | | | | | |--Clustered Index Seek(OBJECT:([TCEUP01].[dbo].[PWORKSPACEOBJECT].[PIPWORKSPACEOBJEC] AS [t_01]), SEEK:([t_01].[puid]=[TCEUP01].[dbo].[PITEMREVISION].[puid] as [t_03].[puid]), WHERE:([TCEUP01].[dbo].[PWORKSPACEOBJECT].[pactive_seq] as [t_01].[pactive_seq
  23. 0.00446934 0.0039 0.0006 406 | | | | |--Table Scan(OBJECT:([tempdb].[dbo].[#PRefbindtag3]))
  24. 0.00328322 0.0031 0.0002 1 | | | |--Index Seek(OBJECT:([TCEUP01].[dbo].[PITEMREVISION].[PIPITEMREVISION_0] AS [t_03]), SEEK:([t_03].[ritems_tagu]=[TCEUP01].[dbo].[PITEMREVISION].[ritems_tagu] as [t_03].[ritems_tagu]) ORDERED FORWARD)
  25. 0.00329969 0.0031 0.0002 1 | | |--Index Seek(OBJECT:([TCEUP01].[dbo].[PRELEASESTATUS].[EN_PIPRELEASESTATUS_1] AS [t_04]), SEEK:([t_04].[pname]='F' AND [t_04].[pdate_released]=[Expr1014]), WHERE:([TCEUP01].[dbo].[PRELEASESTATUS].[pdate_released] as [t_04].[pdate_released]<='2019-02-10 17:15:42.000') ORDERE
  26. 0.00328310 0.0031 0.0002 1 | |--Index Seek(OBJECT:([TCEUP01].[dbo].[PRELEASE_STATUS_LIST].[PIPRELEASE_STAT_0] AS [t_02]), SEEK:([t_02].[pvalu_0]=[TCEUP01].[dbo].[PRELEASESTATUS].[puid] as [t_04].[puid] AND [t_02].[puid]=[TCEUP01].[dbo].[PITEMREVISION].[puid] as [t_03].[puid]) ORDERED FORWARD)
  27. 0.00328318 0.0031 0.0002 1 |--Clustered Index Seek(OBJECT:([TCEUP01].[dbo].[PWORKSPACEOBJECT].[PIPWORKSPACEOBJEC] AS [t_01]), SEEK:([t_01].[puid]=[TCEUP01].[dbo].[PITEMREVISION].[puid] as [t_03].[puid]), WHERE:([TCEUP01].[dbo].[PWORKSPACEOBJECT].[pactive_seq] as [t_01].[pactive_seq]<>(0)) ORDERED FORWARD)
  28.  
  29. NOTE - 2019/2/10-17:18:35.208 UTC - PC3550.10336.01.XXX.00090 - That SQL took a long time to execute -- set TC_SLOW_SQL to -1.0 to suppress this analysis - Teamcenter.POM at D:\workdir\tc10171a01x_win64\src\foundation\pom\eim\eim_enquire.cxx(5801)
  30. 137 seconds to POM DB x-act
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement