SET client_min_messages=error; SET enable_mergejoin = off; SET escape_string_warning = off; SET cpu_operator_cost = 0.001; set client_encoding = 'utf8'; SET lock_timeout = 20000; EXPLAIN (ANALYZE, BUFFERS, SETTINGS) SELECT CASE WHEN (EXISTS(SELECT TRUE AS Q_001_F_000_ FROM _InfoRg8199 T23 LEFT OUTER JOIN _InfoRg10621 T24 ON ((T24._Fld10622RRef = T23._Fld8201RRef) AND (T24._Fld15131RRef = '\\210@\\000PV\\276\\307<\\021\\360\\244\\243?\\321i\\276'::bytea)) AND (T24._Fld809 = CAST(0 AS NUMERIC)) WHERE ((T23._Fld809 = CAST(0 AS NUMERIC))) AND ((T23._Fld8200_TYPE = '\\010'::bytea AND T23._Fld8200_RTRef = '\\000\\000\\000\\177'::bytea AND T23._Fld8200_RRRef = T1._IDRRef) AND (NOT (((T24._Fld10622RRef IS NULL))))))) AND COALESCE(T2.SDBL_RLS_SIGNAL_,TRUE) = TRUE AND COALESCE(T6.SDBL_RLS_SIGNAL_,TRUE) = TRUE AND COALESCE(T18.SDBL_RLS_SIGNAL_,TRUE) = TRUE THEN TRUE ELSE FALSE END, T1._IDRRef FROM _Reference127 T1 LEFT OUTER JOIN (SELECT CASE WHEN (EXISTS(SELECT TRUE AS Q_001_F_000_ FROM _InfoRg8199 T4 LEFT OUTER JOIN _InfoRg10621 T5 ON ((T5._Fld10622RRef = T4._Fld8201RRef) AND (T5._Fld15131RRef = '\\210@\\000PV\\276\\307<\\021\\360\\244\\243?\\321i\\276'::bytea)) AND (T5._Fld809 = CAST(0 AS NUMERIC)) WHERE ((T4._Fld809 = CAST(0 AS NUMERIC))) AND ((T4._Fld8200_TYPE = '\\010'::bytea AND T4._Fld8200_RTRef = '\\000\\000\\000\\177'::bytea AND T4._Fld8200_RRRef = T3._Fld12031RRef) AND (NOT (((T5._Fld10622RRef IS NULL))))))) THEN TRUE ELSE FALSE END AS SDBL_RLS_SIGNAL_, T3._Fld809 AS Fld809_, T3._Fld12031RRef AS Fld12031RRef FROM _InfoRg12030 T3 WHERE (T3._Fld809 = CAST(0 AS NUMERIC))) T2 ON (T1._IDRRef = T2.Fld12031RRef) LEFT OUTER JOIN (SELECT CASE WHEN (EXISTS(SELECT 1 FROM (SELECT 1 AS SDBL_DUMMY) SDBL_DUAL LEFT OUTER JOIN _Reference312 T8 ON (T7._Fld11507_TYPE = '\\010'::bytea AND T7._Fld11507_RTRef = '\\000\\000\\0018'::bytea AND T7._Fld11507_RRRef = T8._IDRRef) AND (T8._Fld809 = CAST(0 AS NUMERIC)) LEFT OUTER JOIN _Reference312 T9 ON (T7._Fld11509_TYPE = '\\010'::bytea AND T7._Fld11509_RTRef = '\\000\\000\\0018'::bytea AND T7._Fld11509_RRRef = T9._IDRRef) AND (T9._Fld809 = CAST(0 AS NUMERIC)) WHERE ((T7._Fld11507_TYPE = '\\010'::bytea AND T7._Fld11507_RTRef = '\\000\\000\\0018'::bytea) AND EXISTS(SELECT TRUE AS Q_001_F_000_ FROM _InfoRg8199 T10 LEFT OUTER JOIN _InfoRg10621 T11 ON ((T10._Fld8201RRef = T11._Fld10622RRef)) AND (T11._Fld809 = CAST(0 AS NUMERIC)) WHERE ((T10._Fld809 = CAST(0 AS NUMERIC))) AND ((T10._Fld8200_TYPE = (T8._Fld4781_TYPE) AND T10._Fld8200_RTRef = (T8._Fld4781_RTRef) AND T10._Fld8200_RRRef = (T8._Fld4781_RRRef)) AND (T11._Fld15131RRef = '\\210@\\000PV\\276\\307<\\021\\360\\244\\243?\\321i\\276'::bytea))) OR (NOT (((T7._Fld11507_TYPE = '\\010'::bytea AND T7._Fld11507_RTRef = '\\000\\000\\0018'::bytea)))) AND EXISTS(SELECT TRUE AS Q_002_F_000_ FROM _InfoRg8199 T12 LEFT OUTER JOIN _InfoRg10621 T13 ON ((T12._Fld8201RRef = T13._Fld10622RRef)) AND (T13._Fld809 = CAST(0 AS NUMERIC)) WHERE ((T12._Fld809 = CAST(0 AS NUMERIC))) AND ((T12._Fld8200_TYPE = T7._Fld11507_TYPE AND T12._Fld8200_RTRef = T7._Fld11507_RTRef AND T12._Fld8200_RRRef = T7._Fld11507_RRRef) AND (T13._Fld15131RRef = '\\210@\\000PV\\276\\307<\\021\\360\\244\\243?\\321i\\276'::bytea)))) AND ((T7._Fld11509_TYPE = '\\001'::bytea AND T7._Fld11509_RTRef = '\\000\\000\\000\\000'::bytea AND T7._Fld11509_RRRef = '\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000'::bytea) OR (T7._Fld11509_TYPE = '\\010'::bytea AND T7._Fld11509_RTRef = '\\000\\000\\0018'::bytea) AND EXISTS(SELECT TRUE AS Q_003_F_000_ FROM _InfoRg8199 T14 LEFT OUTER JOIN _InfoRg10621 T15 ON ((T14._Fld8201RRef = T15._Fld10622RRef)) AND (T15._Fld809 = CAST(0 AS NUMERIC)) WHERE ((T14._Fld809 = CAST(0 AS NUMERIC))) AND ((T14._Fld8200_TYPE = (T9._Fld4781_TYPE) AND T14._Fld8200_RTRef = (T9._Fld4781_RTRef) AND T14._Fld8200_RRRef = (T9._Fld4781_RRRef)) AND (T15._Fld15131RRef = '\\210@\\000PV\\276\\307<\\021\\360\\244\\243?\\321i\\276'::bytea))) OR (NOT (((T7._Fld11509_TYPE = '\\010'::bytea AND T7._Fld11509_RTRef = '\\000\\000\\0018'::bytea)))) AND EXISTS(SELECT TRUE AS Q_004_F_000_ FROM _InfoRg8199 T16 LEFT OUTER JOIN _InfoRg10621 T17 ON ((T16._Fld8201RRef = T17._Fld10622RRef)) AND (T17._Fld809 = CAST(0 AS NUMERIC)) WHERE ((T16._Fld809 = CAST(0 AS NUMERIC))) AND ((T16._Fld8200_TYPE = T7._Fld11509_TYPE AND T16._Fld8200_RTRef = T7._Fld11509_RTRef AND T16._Fld8200_RRRef = T7._Fld11509_RRRef) AND (T17._Fld15131RRef = '\\210@\\000PV\\276\\307<\\021\\360\\244\\243?\\321i\\276'::bytea)))))) THEN TRUE ELSE FALSE END AS SDBL_RLS_SIGNAL_, T7._Fld809 AS Fld809_, T7._Fld11509_TYPE AS Fld11509_TYPE, T7._Fld11509_RTRef AS Fld11509_RTRef, T7._Fld11509_RRRef AS Fld11509_RRRef, T7._Fld11508RRef AS Fld11508RRef, T7._Fld11507_TYPE AS Fld11507_TYPE, T7._Fld11507_RTRef AS Fld11507_RTRef, T7._Fld11507_RRRef AS Fld11507_RRRef FROM _InfoRg11506 T7 WHERE (T7._Fld809 = CAST(0 AS NUMERIC))) T6 ON ('\\010'::bytea = T6.Fld11507_TYPE AND '\\000\\000\\000\\177'::bytea = T6.Fld11507_RTRef AND T1._IDRRef = T6.Fld11507_RRRef) AND (T6.Fld11508RRef = '\\237X\\000PV\\276\\306\\177\\021\\360\\211l\\367\\233\\277\\234'::bytea) LEFT OUTER JOIN (SELECT CASE WHEN (EXISTS(SELECT 1 FROM (SELECT 1 AS SDBL_DUMMY) SDBL_DUAL LEFT OUTER JOIN _Reference147 T20 ON ((T19._Fld8928RRef = T20._IDRRef)) AND (T20._Fld809 = CAST(0 AS NUMERIC)) WHERE (T20._Fld2132_TYPE = '\\010'::bytea AND T20._Fld2132_RTRef = '\\000\\000\\001\\020'::bytea AND T20._Fld2132_RRRef IN ('\\210@\\000PV\\276\\307<\\021\\360\\244\\2439#x\\310'::bytea)) OR (T20._Fld2135 = FALSE) AND EXISTS(SELECT TRUE AS Q_001_F_000_ FROM _InfoRg8199 T21 WHERE ((T21._Fld809 = CAST(0 AS NUMERIC))) AND (('\\010'::bytea = T21._Fld8200_TYPE AND '\\000\\000\\000\\223'::bytea = T21._Fld8200_RTRef AND T20._IDRRef = T21._Fld8200_RRRef) AND EXISTS(SELECT TRUE AS Q_002_F_000_ FROM _InfoRg10621 T22 WHERE ((T22._Fld809 = CAST(0 AS NUMERIC))) AND ((T21._Fld8201RRef = T22._Fld10622RRef) AND (T22._Fld15131RRef = '\\210@\\000PV\\276\\307<\\021\\360\\244\\243?\\321i\\276'::bytea))))))) THEN TRUE ELSE FALSE END AS SDBL_RLS_SIGNAL_, T19._Fld8928RRef AS Fld8928RRef, T19._Fld8927_TYPE AS Fld8927_TYPE, T19._Fld8927_RTRef AS Fld8927_RTRef, T19._Fld8927_RRRef AS Fld8927_RRRef, T19._Fld809 AS Fld809_ FROM _InfoRg8926 T19 WHERE (T19._Fld809 = CAST(0 AS NUMERIC))) T18 ON ('\\010'::bytea = T18.Fld8927_TYPE AND '\\000\\000\\000\\177'::bytea = T18.Fld8927_RTRef AND T1._IDRRef = T18.Fld8927_RRRef) WHERE ((T1._Fld809 = CAST(0 AS NUMERIC))) AND ((T1._IDRRef = '\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000'::bytea) AND (T1._Fld1806RRef = '\\203\\356\\000PV\\276+c\\021\\360\\215L\\342i\\233\\304'::bytea))