Skip to content

Instantly share code, notes, and snippets.

@gsmolk

gsmolk/gist:59cc48707d90afe67c972999ae992c6d

Last active July 22, 2016 15:16
Show Gist options
  • Save gsmolk/59cc48707d90afe67c972999ae992c6d to your computer and use it in GitHub Desktop.
Save gsmolk/59cc48707d90afe67c972999ae992c6d to your computer and use it in GitHub Desktop.
Download ZIP
1c
Raw
gistfile1.txt
SELECT
T1._Q_000_F_000,
T3._Fld10125RRef,
T1._Q_000_F_002RRef,
T1._Q_000_F_003RRef,
T1._Q_000_F_004RRef,
CASE WHEN T2._Fld2270RRef = '\\204\\246\\023\\033m\\305UZF''\\350WWPv\\207'::bytea THEN CASE WHEN T1._Q_000_F_005RRef IS NOT NULL THEN '\\000\\000\\000\\243'::bytea END WHEN T2._Fld2270RRef = '\\201F\\\\nu\\257Q\\301Fp\\027O\\211\\214\\001{'::bytea THEN CASE WHEN T1._Q_000_F_006RRef IS NOT NULL THEN '\\000\\000\\000\\243'::bytea END WHEN T2._Fld2270RRef = '\\265\\256T\\022\\026\\311\\033\\007L\\370\\272\\253\\322W\\276\\225'::bytea THEN CASE WHEN T1._Q_000_F_007RRef IS NOT NULL THEN '\\000\\000\\000\\243'::bytea END WHEN T2._Fld2270RRef = '\\261\\006hU\\025\\215\\313\\224N\\251\\312\\337\\346T\\353\\217'::bytea THEN CASE WHEN T1._Q_000_F_008RRef IS NOT NULL THEN '\\000\\000\\000\\257'::bytea END END,
CASE WHEN T2._Fld2270RRef = '\\204\\246\\023\\033m\\305UZF''\\350WWPv\\207'::bytea THEN T1._Q_000_F_005RRef WHEN T2._Fld2270RRef = '\\201F\\\\nu\\257Q\\301Fp\\027O\\211\\214\\001{'::bytea THEN T1._Q_000_F_006RRef WHEN T2._Fld2270RRef = '\\265\\256T\\022\\026\\311\\033\\007L\\370\\272\\253\\322W\\276\\225'::bytea THEN T1._Q_000_F_007RRef WHEN T2._Fld2270RRef = '\\261\\006hU\\025\\215\\313\\224N\\251\\312\\337\\346T\\353\\217'::bytea THEN T1._Q_000_F_008RRef END
FROM tt9104 T1
INNER JOIN _Reference112 T2
ON (T2._IDRRef = T1._Q_000_F_002RRef)
LEFT OUTER JOIN _InfoRg10121 T3
ON (((((T3._Fld10122RRef = T1._Q_000_F_002RRef) AND (T3._Fld10123RRef = T1._Q_000_F_003RRef)) AND (T3._Fld18417RRef = T1._Q_000_F_004RRef)) AND (T3._Fld10124_TYPE = '\\010'::bytea AND T3._Fld10124_RTRef = CASE WHEN T2._Fld2270RRef = '\\204\\246\\023\\033m\\305UZF''\\350WWPv\\207'::bytea THEN CASE WHEN T1._Q_000_F_005RRef IS NOT NULL THEN '\\000\\000\\000\\243'::bytea END WHEN T2._Fld2270RRef = '\\201F\\\\nu\\257Q\\301Fp\\027O\\211\\214\\001{'::bytea THEN CASE WHEN T1._Q_000_F_006RRef IS NOT NULL THEN '\\000\\000\\000\\243'::bytea END WHEN T2._Fld2270RRef = '\\265\\256T\\022\\026\\311\\033\\007L\\370\\272\\253\\322W\\276\\225'::bytea THEN CASE WHEN T1._Q_000_F_007RRef IS NOT NULL THEN '\\000\\000\\000\\243'::bytea END WHEN T2._Fld2270RRef = '\\261\\006hU\\025\\215\\313\\224N\\251\\312\\337\\346T\\353\\217'::bytea THEN CASE WHEN T1._Q_000_F_008RRef IS NOT NULL THEN '\\000\\000\\000\\257'::bytea END END AND T3._Fld10124_RRRef = CASE WHEN T2._Fld2270RRef = '\\204\\246\\023\\033m\\305UZF''\\350WWPv\\207'::bytea THEN T1._Q_000_F_005RRef WHEN T2._Fld2270RRef = '\\201F\\\\nu\\257Q\\301Fp\\027O\\211\\214\\001{'::bytea THEN T1._Q_000_F_006RRef WHEN T2._Fld2270RRef = '\\265\\256T\\022\\026\\311\\033\\007L\\370\\272\\253\\322W\\276\\225'::bytea THEN T1._Q_000_F_007RRef WHEN T2._Fld2270RRef = '\\261\\006hU\\025\\215\\313\\224N\\251\\312\\337\\346T\\353\\217'::bytea THEN T1._Q_000_F_008RRef END))) AND (T3._Fld608 = 0)
WHERE ((T2._Fld608 = 0)) AND ((T3._Fld10125RRef IS NULL OR (T3._Fld10125RRef <> T1._Q_000_F_001RRef)))",Result=PGRES_TUPLES_OK,Context='Форма.Записать : Документ.ВозвратТоваровПоставщику.Форма.ФормаДокумента
Документ.ВозвратТоваровПоставщику.МодульОбъекта : 454 : РегистрыСведений.АналитикаУчетаНоменклатуры.ЗаполнитьВКоллекции(Товары, МестаУчета);
РегистрСведений.АналитикаУчетаНоменклатуры.МодульМенеджера : 205 : Выборка = Запрос.Выполнить().Выбрать();'
41:14.845001-13281000,DBPOSTGRS,5,process=rphost,p:processName=asku_PG_838,t:clientID=8951,t:applicationName=1CV8C,t:computerName=ufps-1cap01,t:connectID=5162,SessionID=1573,Usr=Администратор,AppID=1CV8C,Trans=1,dbpid=45203,Sql="SELECT
T1._Q_000_F_000,
T3._Fld10125RRef,
T1._Q_000_F_002RRef,
T1._Q_000_F_003RRef,
T1._Q_000_F_004RRef,
CASE WHEN T2._Fld2270RRef = '\\204\\246\\023\\033m\\305UZF''\\350WWPv\\207'::bytea THEN CASE WHEN T1._Q_000_F_005RRef IS NOT NULL THEN '\\000\\000\\000\\243'::bytea END WHEN T2._Fld2270RRef = '\\201F\\\\nu\\257Q\\301Fp\\027O\\211\\214\\001{'::bytea THEN CASE WHEN T1._Q_000_F_006RRef IS NOT NULL THEN '\\000\\000\\000\\243'::bytea END WHEN T2._Fld2270RRef = '\\265\\256T\\022\\026\\311\\033\\007L\\370\\272\\253\\322W\\276\\225'::bytea THEN CASE WHEN T1._Q_000_F_007RRef IS NOT NULL THEN '\\000\\000\\000\\243'::bytea END WHEN T2._Fld2270RRef = '\\261\\006hU\\025\\215\\313\\224N\\251\\312\\337\\346T\\353\\217'::bytea THEN CASE WHEN T1._Q_000_F_008RRef IS NOT NULL THEN '\\000\\000\\000\\257'::bytea END END,
CASE WHEN T2._Fld2270RRef = '\\204\\246\\023\\033m\\305UZF''\\350WWPv\\207'::bytea THEN T1._Q_000_F_005RRef WHEN T2._Fld2270RRef = '\\201F\\\\nu\\257Q\\301Fp\\027O\\211\\214\\001{'::bytea THEN T1._Q_000_F_006RRef WHEN T2._Fld2270RRef = '\\265\\256T\\022\\026\\311\\033\\007L\\370\\272\\253\\322W\\276\\225'::bytea THEN T1._Q_000_F_007RRef WHEN T2._Fld2270RRef = '\\261\\006hU\\025\\215\\313\\224N\\251\\312\\337\\346T\\353\\217'::bytea THEN T1._Q_000_F_008RRef END
FROM tt9104 T1
INNER JOIN _Reference112 T2
ON (T2._IDRRef = T1._Q_000_F_002RRef)
LEFT OUTER JOIN _InfoRg10121 T3
ON (((((T3._Fld10122RRef = T1._Q_000_F_002RRef) AND (T3._Fld10123RRef = T1._Q_000_F_003RRef)) AND (T3._Fld18417RRef = T1._Q_000_F_004RRef)) AND (T3._Fld10124_TYPE = '\\010'::bytea AND T3._Fld10124_RTRef = CASE WHEN T2._Fld2270RRef = '\\204\\246\\023\\033m\\305UZF''\\350WWPv\\207'::bytea THEN CASE WHEN T1._Q_000_F_005RRef IS NOT NULL THEN '\\000\\000\\000\\243'::bytea END WHEN T2._Fld2270RRef = '\\201F\\\\nu\\257Q\\301Fp\\027O\\211\\214\\001{'::bytea THEN CASE WHEN T1._Q_000_F_006RRef IS NOT NULL THEN '\\000\\000\\000\\243'::bytea END WHEN T2._Fld2270RRef = '\\265\\256T\\022\\026\\311\\033\\007L\\370\\272\\253\\322W\\276\\225'::bytea THEN CASE WHEN T1._Q_000_F_007RRef IS NOT NULL THEN '\\000\\000\\000\\243'::bytea END WHEN T2._Fld2270RRef = '\\261\\006hU\\025\\215\\313\\224N\\251\\312\\337\\346T\\353\\217'::bytea THEN CASE WHEN T1._Q_000_F_008RRef IS NOT NULL THEN '\\000\\000\\000\\257'::bytea END END AND T3._Fld10124_RRRef = CASE WHEN T2._Fld2270RRef = '\\204\\246\\023\\033m\\305UZF''\\350WWPv\\207'::bytea THEN T1._Q_000_F_005RRef WHEN T2._Fld2270RRef = '\\201F\\\\nu\\257Q\\301Fp\\027O\\211\\214\\001{'::bytea THEN T1._Q_000_F_006RRef WHEN T2._Fld2270RRef = '\\265\\256T\\022\\026\\311\\033\\007L\\370\\272\\253\\322W\\276\\225'::bytea THEN T1._Q_000_F_007RRef WHEN T2._Fld2270RRef = '\\261\\006hU\\025\\215\\313\\224N\\251\\312\\337\\346T\\353\\217'::bytea THEN T1._Q_000_F_008RRef END))) AND (T3._Fld608 = 0)
WHERE ((T2._Fld608 = 0)) AND ((T3._Fld10125RRef IS NULL OR (T3._Fld10125RRef <> T1._Q_000_F_001RRef)))",planSQLText="Hash Right Join (cost=617.76..1038.73 rows=120 width=187) (actual time=6908.031..6908.031 rows=0 loops=1)
Hash Cond: ((t3._fld10122rref = t1._q_000_f_002rref) AND (t3._fld10123rref = t1._q_000_f_003rref) AND (t3._fld18417rref = t1._q_000_f_004rref) AND (t3._fld10124_rtref = CASE WHEN (t2._fld2270rref = '\\x84a6131b6dc5555a4627e85757507687'::bytea) THEN CASE WHEN (t1._q_000_f_005rref IS NOT NULL) THEN '\\x000000a3'::bytea ELSE NULL::bytea END WHEN (t2._fld2270rref = '\\x81465c6e75af51c14670174f898c017b'::bytea) THEN CASE WHEN (t1._q_000_f_006rref IS NOT NULL) THEN '\\x000000a3'::bytea ELSE NULL::bytea END WHEN (t2._fld2270rref = '\\xb5ae541216c91b074cf8baabd257be95'::bytea) THEN CASE WHEN (t1._q_000_f_007rref IS NOT NULL) THEN '\\x000000a3'::bytea ELSE NULL::bytea END WHEN (t2._fld2270rref = '\\xb1066855158dcb944ea9cadfe654eb8f'::bytea) THEN CASE WHEN (t1._q_000_f_008rref IS NOT NULL) THEN '\\x000000af'::bytea ELSE NULL::bytea END ELSE NULL::bytea END) AND (t3._fld10124_rrref = CASE WHEN (t2._fld2270rref = '\\x84a6131b6dc5555a4627e85757507687'::bytea) THEN t1._q_000_f_005rref WHEN (t2._fld2270rref = '\\x81465c6e75af51c14670174f898c017b'::bytea) THEN t1._q_000_f_006rref WHEN (t2._fld2270rref = '\\xb5ae541216c91b074cf8baabd257be95'::bytea) THEN t1._q_000_f_007rref WHEN (t2._fld2270rref = '\\xb1066855158dcb944ea9cadfe654eb8f'::bytea) THEN t1._q_000_f_008rref ELSE NULL::bytea END))
Filter: ((t3._fld10125rref IS NULL) OR (t3._fld10125rref <> t1._q_000_f_001rref))
Rows Removed by Filter: 49
-> Bitmap Heap Scan on _inforg10121 t3 (cost=9.64..423.43 rows=106 width=192) (actual time=2341.782..3798.448 rows=4232611 loops=1)
Recheck Cond: ((_fld608 = '0'::numeric) AND (_fld10124_type = '\\x08'::bytea))
Heap Blocks: exact=76957
-> Bitmap Index Scan on _inforg10121_bydims10127_rrrr (cost=0.00..9.62 rows=106 width=0) (actual time=2298.909..2298.909 rows=4232611 loops=1)
Index Cond: ((_fld608 = '0'::numeric) AND (_fld10124_type = '\\x08'::bytea))
-> Hash (cost=605.40..605.40 rows=121 width=172) (actual time=1.371..1.371 rows=49 loops=1)
Buckets: 1024 Batches: 1 Memory Usage: 18kB
-> Nested Loop (cost=0.42..605.40 rows=121 width=172) (actual time=0.548..1.172 rows=49 loops=1)
-> Seq Scan on tt9104 t1 (cost=0.00..2.49 rows=49 width=140) (actual time=0.064..0.074 rows=49 loops=1)
-> Index Scan using _reference112hpk on _reference112 t2 (cost=0.42..12.28 rows=2 width=64) (actual time=0.015..0.016 rows=1 loops=49)
Index Cond: ((_fld608 = '0'::numeric) AND (_idrref = t1._q_000_f_002rref))
Planning time: 2.233 ms
Execution time: 6908.188 ms
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment