explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BdXZ

Settings
# exclusive inclusive rows x rows loops node
1. 4.063 71.130 ↓ 171.0 171 1

Hash Left Join (cost=26.71..73.26 rows=1 width=421) (actual time=6.847..71.130 rows=171 loops=1)

  • Output: '\\x81498a0aa21cb6ea4de6174a115f7bfa'::bytea, CASE WHEN (t5._q_001_f_002 IS NULL) THEN false ELSE true END, COALESCE(t5._q_001_f_002, '0'::numeric), '\\xae62da2282d4265b11e903ba63e94820'::bytea, CASE WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001fe'::bytea)) THEN t6._date_time WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f4'::bytea)) THEN t7._date_time WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f2'::bytea)) THEN t8._date_time WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000021d'::bytea)) THEN t9._date_time WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001d8'::bytea)) THEN t10._date_time WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001e1'::bytea)) THEN t11._date_time WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001a4'::bytea)) THEN t12._date_time WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x00000195'::bytea)) THEN t13._date_time WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000020d'::bytea)) THEN t14._date_time WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000006d'::bytea)) THEN t15._fld20593 WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x00000069'::bytea)) THEN t16._fld20366 WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001dd'::bytea)) THEN t17._date_time WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001da'::bytea)) THEN t18._date_time WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001de'::bytea)) THEN t19._date_time WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001db'::bytea)) THEN t20._date_time WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f3'::bytea)) THEN t21._date_time WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x00000193'::bytea)) THEN t22._date_time WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001e3'::bytea)) THEN t23._date_time WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000019a'::bytea)) THEN t24._date_time WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f0'::bytea)) THEN t25._date_time ELSE NULL::timestamp without time zone END, CASE WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001fe'::bytea)) THEN (t6._number)::mvarchar WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f4'::bytea)) THEN (t7._number)::mvarchar WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f2'::bytea)) THEN (t8._number)::mvarchar WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000021d'::bytea)) THEN (t9._number)::mvarchar WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001d8'::bytea)) THEN (t10._number)::mvarchar WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001e1'::bytea)) THEN (t11._number)::mvarchar WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001a4'::bytea)) THEN (t12._number)::mvarchar WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x00000195'::bytea)) THEN (t13._number)::mvarchar WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000020d'::bytea)) THEN (t14._number)::mvarchar WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000006d'::bytea)) THEN t15._fld20594 WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x00000069'::bytea)) THEN t16._fld20367 WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001dd'::bytea)) THEN (t17._number)::mvarchar WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001da'::bytea)) THEN (t18._number)::mvarchar WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001de'::bytea)) THEN (t19._number)::mvarchar WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001db'::bytea)) THEN (t20._number)::mvarchar WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f3'::bytea)) THEN t21._number WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x00000193'::bytea)) THEN (t22._number)::mvarchar WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001e3'::bytea)) THEN (t23._number)::mvarchar WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000019a'::bytea)) THEN (t24._number)::mvarchar WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f0'::bytea)) THEN (t25._number)::mvarchar ELSE NULL::mvarchar(1) END, t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, ''::mvarchar, t2._fld18000rref, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, COALESCE(CASE WHEN ((t4._q_001_f_004_type = '\\x08'::bytea) AND (t4._q_001_f_004_rtref = '\\x0000006d'::bytea)) THEN t26._fld20612 WHEN ((t4._q_001_f_004_type = '\\x08'::bytea) AND (t4._q_001_f_004_rtref = '\\x00000069'::bytea)) THEN t27._fld20389 ELSE NULL::boolean END, false), CASE WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x00000069'::bytea)) THEN CASE WHEN (COALESCE(t16._fld20381rref, '\\x00000000000000000000000000000000'::bytea) = '\\x00000000000000000000000000000000'::bytea) THEN t28._fld24847rref ELSE CASE WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001fe'::bytea)) THEN t6._fld7896rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f4'::bytea)) THEN t7._fld7449rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f2'::bytea)) THEN t8._fld7246rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000020d'::bytea)) THEN t14._fld8554rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000006d'::bytea)) THEN t15._fld20603rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x00000069'::bytea)) THEN t16._fld20381rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f3'::bytea)) THEN t21._fld7396rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f0'::bytea)) THEN t25._fld7061rref ELSE NULL::bytea END END ELSE CASE WHEN ((CASE WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001fe'::bytea)) THEN t6._fld7912_type WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f4'::bytea)) THEN t7._fld7464_type WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f2'::bytea)) THEN CASE WHEN (t8._fld7233rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000021d'::bytea)) THEN CASE WHEN (t9._fld9106rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001d8'::bytea)) THEN CASE WHEN (t10._fld5630rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001e1'::bytea)) THEN t11._fld6230_type WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001a4'::bytea)) THEN CASE WHEN (t12._fld3492rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x00000195'::bytea)) THEN CASE WHEN (t13._fld2533rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000020d'::bytea)) THEN t14._fld8588_type WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001dd'::bytea)) THEN CASE WHEN (t17._fld6043rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001da'::bytea)) THEN CASE WHEN (t18._fld5795rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001de'::bytea)) THEN CASE WHEN (t19._fld6136rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001db'::bytea)) THEN CASE WHEN (t20._fld5877rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f3'::bytea)) THEN CASE WHEN (t21._fld7386rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x00000193'::bytea)) THEN CASE WHEN (t22._fld2307rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001e3'::bytea)) THEN CASE WHEN (t23._fld6304rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000019a'::bytea)) THEN CASE WHEN (t24._fld2885rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f0'::bytea)) THEN t25._fld7084_type ELSE NULL::bytea END = '\\x08'::bytea) AND (CASE WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001fe'::bytea)) THEN t6._fld7912_rtref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f4'::bytea)) THEN t7._fld7464_rtref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f2'::bytea)) THEN CASE WHEN (t8._fld7233rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000021d'::bytea)) THEN CASE WHEN (t9._fld9106rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001d8'::bytea)) THEN CASE WHEN (t10._fld5630rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001e1'::bytea)) THEN t11._fld6230_rtref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001a4'::bytea)) THEN CASE WHEN (t12._fld3492rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x00000195'::bytea)) THEN CASE WHEN (t13._fld2533rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000020d'::bytea)) THEN t14._fld8588_rtref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001dd'::bytea)) THEN CASE WHEN (t17._fld6043rref IS NOT NULL) THEN '\\x0000006d'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001da'::bytea)) THEN CASE WHEN (t18._fld5795rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001de'::bytea)) THEN CASE WHEN (t19._fld6136rref IS NOT NULL) THEN '\\x0000006d'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001db'::bytea)) THEN CASE WHEN (t20._fld5877rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f3'::bytea)) THEN CASE WHEN (t21._fld7386rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x00000193'::bytea)) THEN CASE WHEN (t22._fld2307rref IS NOT NULL) THEN '\\x0000006d'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001e3'::bytea)) THEN CASE WHEN (t23._fld6304rref IS NOT NULL) THEN '\\x0000006d'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000019a'::bytea)) THEN CASE WHEN (t24._fld2885rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f0'::bytea)) THEN t25._fld7084_rtref ELSE NULL::bytea END = '\\x00000069'::bytea)) THEN CASE WHEN (COALESCE(t29._fld20381rref, '\\x00000000000000000000000000000000'::bytea) = '\\x00000000000000000000000000000000'::bytea) THEN t28._fld24847rref ELSE CASE WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001fe'::bytea)) THEN CASE WHEN ((t6._fld7912_type = '\\x08'::bytea) AND (t6._fld7912_rtref = '\\x0000006d'::bytea)) THEN t30._fld20603rref WHEN ((t6._fld7912_type = '\\x08'::bytea) AND (t6._fld7912_rtref = '\\x00000069'::bytea)) THEN t31._fld20381rref ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f4'::bytea)) THEN CASE WHEN ((t7._fld7464_type = '\\x08'::bytea) AND (t7._fld7464_rtref = '\\x0000006d'::bytea)) THEN t32._fld20603rref WHEN ((t7._fld7464_type = '\\x08'::bytea) AND (t7._fld7464_rtref = '\\x00000069'::bytea)) THEN t33._fld20381rref ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f2'::bytea)) THEN t34._fld20381rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000021d'::bytea)) THEN t35._fld20381rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001d8'::bytea)) THEN t36._fld20381rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001e1'::bytea)) THEN CASE WHEN ((t11._fld6230_type = '\\x08'::bytea) AND (t11._fld6230_rtref = '\\x0000006d'::bytea)) THEN t37._fld20603rref WHEN ((t11._fld6230_type = '\\x08'::bytea) AND (t11._fld6230_rtref = '\\x00000069'::bytea)) THEN t38._fld20381rref ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001a4'::bytea)) THEN t39._fld20381rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x00000195'::bytea)) THEN t40._fld20381rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000020d'::bytea)) THEN CASE WHEN ((t14._fld8588_type = '\\x08'::bytea) AND (t14._fld8588_rtref = '\\x0000006d'::bytea)) THEN t41._fld20603rref WHEN ((t14._fld8588_type = '\\x08'::bytea) AND (t14._fld8588_rtref = '\\x00000069'::bytea)) THEN t42._fld20381rref ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001dd'::bytea)) THEN t43._fld20603rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001da'::bytea)) THEN t44._fld20381rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001de'::bytea)) THEN t45._fld20603rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001db'::bytea)) THEN t46._fld20381rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f3'::bytea)) THEN t47._fld20381rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x00000193'::bytea)) THEN t48._fld20603rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001e3'::bytea)) THEN t49._fld20603rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000019a'::bytea)) THEN t50._fld20381rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f0'::bytea)) THEN CASE WHEN ((t25._fld7084_type = '\\x08'::bytea) AND (t25._fld7084_rtref = '\\x0000006d'::bytea)) THEN t51._fld20603rref WHEN ((t25._fld7084_type = '\\x08'::bytea) AND (t25._fld7084_rtref = '\\x00000069'::bytea)) THEN t52._fld20381rref ELSE NULL::bytea END ELSE NULL::bytea END END WHEN ((CASE WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001fe'::bytea)) THEN t6._fld7912_type WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f4'::bytea)) THEN t7._fld7464_type WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f2'::bytea)) THEN CASE WHEN (t8._fld7233rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000021d'::bytea)) THEN CASE WHEN (t9._fld9106rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001d8'::bytea)) THEN CASE WHEN (t10._fld5630rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001e1'::bytea)) THEN t11._fld6230_type WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001a4'::bytea)) THEN CASE WHEN (t12._fld3492rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x00000195'::bytea)) THEN CASE WHEN (t13._fld2533rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000020d'::bytea)) THEN t14._fld8588_type WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001dd'::bytea)) THEN CASE WHEN (t17._fld6043rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001da'::bytea)) THEN CASE WHEN (t18._fld5795rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001de'::bytea)) THEN CASE WHEN (t19._fld6136rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001db'::bytea)) THEN CASE WHEN (t20._fld5877rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f3'::bytea)) THEN CASE WHEN (t21._fld7386rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x00000193'::bytea)) THEN CASE WHEN (t22._fld2307rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001e3'::bytea)) THEN CASE WHEN (t23._fld6304rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000019a'::bytea)) THEN CASE WHEN (t24._fld2885rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f0'::bytea)) THEN t25._fld7084_type ELSE NULL::bytea END = '\\x08'::bytea) AND (CASE WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001fe'::bytea)) THEN t6._fld7912_rtref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f4'::bytea)) THEN t7._fld7464_rtref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f2'::bytea)) THEN CASE WHEN (t8._fld7233rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000021d'::bytea)) THEN CASE WHEN (t9._fld9106rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001d8'::bytea)) THEN CASE WHEN (t10._fld5630rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001e1'::bytea)) THEN t11._fld6230_rtref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001a4'::bytea)) THEN CASE WHEN (t12._fld3492rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x00000195'::bytea)) THEN CASE WHEN (t13._fld2533rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000020d'::bytea)) THEN t14._fld8588_rtref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001dd'::bytea)) THEN CASE WHEN (t17._fld6043rref IS NOT NULL) THEN '\\x0000006d'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001da'::bytea)) THEN CASE WHEN (t18._fld5795rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001de'::bytea)) THEN CASE WHEN (t19._fld6136rref IS NOT NULL) THEN '\\x0000006d'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001db'::bytea)) THEN CASE WHEN (t20._fld5877rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f3'::bytea)) THEN CASE WHEN (t21._fld7386rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x00000193'::bytea)) THEN CASE WHEN (t22._fld2307rref IS NOT NULL) THEN '\\x0000006d'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001e3'::bytea)) THEN CASE WHEN (t23._fld6304rref IS NOT NULL) THEN '\\x0000006d'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000019a'::bytea)) THEN CASE WHEN (t24._fld2885rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f0'::bytea)) THEN t25._fld7084_rtref ELSE NULL::bytea END = '\\x0000006d'::bytea)) THEN t53._fld20605rref ELSE '\\x00000000000000000000000000000000'::bytea END END, CASE WHEN (t2._fld18001 > '0'::numeric) THEN t2._fld18001 ELSE '0'::numeric END, CASE WHEN ((t2._fld18002 - t2._fld18003) > '0'::numeric) THEN (t2._fld18002 - t2._fld18003) ELSE '0'::numeric END, CASE WHEN (t2._fld18001 < '0'::numeric) THEN (- t2._fld18001) ELSE '0'::numeric END
  • Inner Unique: true
  • Hash Cond: (CASE WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001fe'::bytea)) THEN t6._fld7912_rrref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f4'::bytea)) THEN t7._fld7464_rrref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f2'::bytea)) THEN t8._fld7233rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000021d'::bytea)) THEN t9._fld9106rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001d8'::bytea)) THEN t10._fld5630rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001e1'::bytea)) THEN t11._fld6230_rrref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001a4'::bytea)) THEN t12._fld3492rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x00000195'::bytea)) THEN t13._fld2533rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000020d'::bytea)) THEN t14._fld8588_rrref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001dd'::bytea)) THEN t17._fld6043rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001da'::bytea)) THEN t18._fld5795rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001de'::bytea)) THEN t19._fld6136rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001db'::bytea)) THEN t20._fld5877rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f3'::bytea)) THEN t21._fld7386rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x00000193'::bytea)) THEN t22._fld2307rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001e3'::bytea)) THEN t23._fld6304rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000019a'::bytea)) THEN t24._fld2885rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f0'::bytea)) THEN t25._fld7084_rrref ELSE NULL::bytea END = t53._idrref)
  • Join Filter: ((CASE WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001fe'::bytea)) THEN t6._fld7912_type WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f4'::bytea)) THEN t7._fld7464_type WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f2'::bytea)) THEN CASE WHEN (t8._fld7233rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000021d'::bytea)) THEN CASE WHEN (t9._fld9106rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001d8'::bytea)) THEN CASE WHEN (t10._fld5630rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001e1'::bytea)) THEN t11._fld6230_type WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001a4'::bytea)) THEN CASE WHEN (t12._fld3492rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x00000195'::bytea)) THEN CASE WHEN (t13._fld2533rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000020d'::bytea)) THEN t14._fld8588_type WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001dd'::bytea)) THEN CASE WHEN (t17._fld6043rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001da'::bytea)) THEN CASE WHEN (t18._fld5795rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001de'::bytea)) THEN CASE WHEN (t19._fld6136rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001db'::bytea)) THEN CASE WHEN (t20._fld5877rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f3'::bytea)) THEN CASE WHEN (t21._fld7386rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x00000193'::bytea)) THEN CASE WHEN (t22._fld2307rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001e3'::bytea)) THEN CASE WHEN (t23._fld6304rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000019a'::bytea)) THEN CASE WHEN (t24._fld2885rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f0'::bytea)) THEN t25._fld7084_type ELSE NULL::bytea END = '\\x08'::bytea) AND (CASE WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001fe'::bytea)) THEN t6._fld7912_rtref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f4'::bytea)) THEN t7._fld7464_rtref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f2'::bytea)) THEN CASE WHEN (t8._fld7233rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000021d'::bytea)) THEN CASE WHEN (t9._fld9106rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001d8'::bytea)) THEN CASE WHEN (t10._fld5630rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001e1'::bytea)) THEN t11._fld6230_rtref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001a4'::bytea)) THEN CASE WHEN (t12._fld3492rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x00000195'::bytea)) THEN CASE WHEN (t13._fld2533rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000020d'::bytea)) THEN t14._fld8588_rtref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001dd'::bytea)) THEN CASE WHEN (t17._fld6043rref IS NOT NULL) THEN '\\x0000006d'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001da'::bytea)) THEN CASE WHEN (t18._fld5795rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001de'::bytea)) THEN CASE WHEN (t19._fld6136rref IS NOT NULL) THEN '\\x0000006d'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001db'::bytea)) THEN CASE WHEN (t20._fld5877rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f3'::bytea)) THEN CASE WHEN (t21._fld7386rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x00000193'::bytea)) THEN CASE WHEN (t22._fld2307rref IS NOT NULL) THEN '\\x0000006d'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001e3'::bytea)) THEN CASE WHEN (t23._fld6304rref IS NOT NULL) THEN '\\x0000006d'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000019a'::bytea)) THEN CASE WHEN (t24._fld2885rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f0'::bytea)) THEN t25._fld7084_rtref ELSE NULL::bytea END = '\\x0000006d'::bytea))
  • Buffers: shared hit=7953 dirtied=1, local hit=343
2. 0.335 67.032 ↓ 171.0 171 1

Nested Loop Left Join (cost=25.49..71.62 rows=1 width=1,858) (actual time=6.570..67.032 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t9._date_time, t9._number, t9._fld9106rref, t10._date_time, t10._number, t10._fld5630rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t13._date_time, t13._number, t13._fld2533rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref, t17._date_time, t17._number, t17._fld6043rref, t18._date_time, t18._number, t18._fld5795rref, t19._date_time, t19._number, t19._fld6136rref, t20._date_time, t20._number, t20._fld5877rref, t21._date_time, t21._number, t21._fld7396rref, t21._fld7386rref, t22._date_time, t22._number, t22._fld2307rref, t23._date_time, t23._number, t23._fld6304rref, t24._date_time, t24._number, t24._fld2885rref, t25._date_time, t25._number, t25._fld7061rref, t25._fld7084_type, t25._fld7084_rtref, t25._fld7084_rrref, t26._fld20612, t27._fld20389, t28._fld24847rref, t29._fld20381rref, t30._fld20603rref, t31._fld20381rref, t32._fld20603rref, t33._fld20381rref, t34._fld20381rref, t35._fld20381rref, t36._fld20381rref, t37._fld20603rref, t38._fld20381rref, t39._fld20381rref, t40._fld20381rref, t41._fld20603rref, t42._fld20381rref, t43._fld20603rref, t44._fld20381rref, t45._fld20603rref, t46._fld20381rref, t47._fld20381rref, t48._fld20603rref, t49._fld20603rref, t50._fld20381rref, t51._fld20603rref, t52._fld20381rref
  • Inner Unique: true
  • Join Filter: ((t25._fld7084_type = '\\x08'::bytea) AND (t25._fld7084_rtref = '\\x00000069'::bytea))
  • Buffers: shared hit=7952 dirtied=1, local hit=343
3. 0.379 66.697 ↓ 171.0 171 1

Nested Loop Left Join (cost=25.38..71.48 rows=1 width=1,841) (actual time=6.563..66.697 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t9._date_time, t9._number, t9._fld9106rref, t10._date_time, t10._number, t10._fld5630rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t13._date_time, t13._number, t13._fld2533rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref, t17._date_time, t17._number, t17._fld6043rref, t18._date_time, t18._number, t18._fld5795rref, t19._date_time, t19._number, t19._fld6136rref, t20._date_time, t20._number, t20._fld5877rref, t21._date_time, t21._number, t21._fld7396rref, t21._fld7386rref, t22._date_time, t22._number, t22._fld2307rref, t23._date_time, t23._number, t23._fld6304rref, t24._date_time, t24._number, t24._fld2885rref, t25._date_time, t25._number, t25._fld7061rref, t25._fld7084_type, t25._fld7084_rtref, t25._fld7084_rrref, t26._fld20612, t27._fld20389, t28._fld24847rref, t29._fld20381rref, t30._fld20603rref, t31._fld20381rref, t32._fld20603rref, t33._fld20381rref, t34._fld20381rref, t35._fld20381rref, t36._fld20381rref, t37._fld20603rref, t38._fld20381rref, t39._fld20381rref, t40._fld20381rref, t41._fld20603rref, t42._fld20381rref, t43._fld20603rref, t44._fld20381rref, t45._fld20603rref, t46._fld20381rref, t47._fld20381rref, t48._fld20603rref, t49._fld20603rref, t50._fld20381rref, t51._fld20603rref
  • Inner Unique: true
  • Join Filter: ((t25._fld7084_type = '\\x08'::bytea) AND (t25._fld7084_rtref = '\\x0000006d'::bytea))
  • Buffers: shared hit=7952 dirtied=1, local hit=343
4. 0.347 66.318 ↓ 171.0 171 1

Nested Loop Left Join (cost=25.33..71.39 rows=1 width=1,824) (actual time=6.556..66.318 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t9._date_time, t9._number, t9._fld9106rref, t10._date_time, t10._number, t10._fld5630rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t13._date_time, t13._number, t13._fld2533rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref, t17._date_time, t17._number, t17._fld6043rref, t18._date_time, t18._number, t18._fld5795rref, t19._date_time, t19._number, t19._fld6136rref, t20._date_time, t20._number, t20._fld5877rref, t21._date_time, t21._number, t21._fld7396rref, t21._fld7386rref, t22._date_time, t22._number, t22._fld2307rref, t23._date_time, t23._number, t23._fld6304rref, t24._date_time, t24._number, t24._fld2885rref, t25._date_time, t25._number, t25._fld7061rref, t25._fld7084_type, t25._fld7084_rtref, t25._fld7084_rrref, t26._fld20612, t27._fld20389, t28._fld24847rref, t29._fld20381rref, t30._fld20603rref, t31._fld20381rref, t32._fld20603rref, t33._fld20381rref, t34._fld20381rref, t35._fld20381rref, t36._fld20381rref, t37._fld20603rref, t38._fld20381rref, t39._fld20381rref, t40._fld20381rref, t41._fld20603rref, t42._fld20381rref, t43._fld20603rref, t44._fld20381rref, t45._fld20603rref, t46._fld20381rref, t47._fld20381rref, t48._fld20603rref, t49._fld20603rref, t50._fld20381rref
  • Inner Unique: true
  • Buffers: shared hit=7952 dirtied=1, local hit=343
5. 0.255 65.971 ↓ 171.0 171 1

Nested Loop Left Join (cost=25.22..69.06 rows=1 width=1,807) (actual time=6.550..65.971 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t9._date_time, t9._number, t9._fld9106rref, t10._date_time, t10._number, t10._fld5630rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t13._date_time, t13._number, t13._fld2533rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref, t17._date_time, t17._number, t17._fld6043rref, t18._date_time, t18._number, t18._fld5795rref, t19._date_time, t19._number, t19._fld6136rref, t20._date_time, t20._number, t20._fld5877rref, t21._date_time, t21._number, t21._fld7396rref, t21._fld7386rref, t22._date_time, t22._number, t22._fld2307rref, t23._date_time, t23._number, t23._fld6304rref, t24._date_time, t24._number, t24._fld2885rref, t25._date_time, t25._number, t25._fld7061rref, t25._fld7084_type, t25._fld7084_rtref, t25._fld7084_rrref, t26._fld20612, t27._fld20389, t28._fld24847rref, t29._fld20381rref, t30._fld20603rref, t31._fld20381rref, t32._fld20603rref, t33._fld20381rref, t34._fld20381rref, t35._fld20381rref, t36._fld20381rref, t37._fld20603rref, t38._fld20381rref, t39._fld20381rref, t40._fld20381rref, t41._fld20603rref, t42._fld20381rref, t43._fld20603rref, t44._fld20381rref, t45._fld20603rref, t46._fld20381rref, t47._fld20381rref, t48._fld20603rref, t49._fld20603rref
  • Inner Unique: true
  • Buffers: shared hit=7952 dirtied=1, local hit=343
6. 0.728 65.545 ↓ 171.0 171 1

Nested Loop Left Join (cost=25.16..68.99 rows=1 width=1,790) (actual time=6.544..65.545 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t9._date_time, t9._number, t9._fld9106rref, t10._date_time, t10._number, t10._fld5630rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t13._date_time, t13._number, t13._fld2533rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref, t17._date_time, t17._number, t17._fld6043rref, t18._date_time, t18._number, t18._fld5795rref, t19._date_time, t19._number, t19._fld6136rref, t20._date_time, t20._number, t20._fld5877rref, t21._date_time, t21._number, t21._fld7396rref, t21._fld7386rref, t22._date_time, t22._number, t22._fld2307rref, t23._date_time, t23._number, t23._fld6304rref, t24._date_time, t24._number, t24._fld2885rref, t25._date_time, t25._number, t25._fld7061rref, t25._fld7084_type, t25._fld7084_rtref, t25._fld7084_rrref, t26._fld20612, t27._fld20389, t28._fld24847rref, t29._fld20381rref, t30._fld20603rref, t31._fld20381rref, t32._fld20603rref, t33._fld20381rref, t34._fld20381rref, t35._fld20381rref, t36._fld20381rref, t37._fld20603rref, t38._fld20381rref, t39._fld20381rref, t40._fld20381rref, t41._fld20603rref, t42._fld20381rref, t43._fld20603rref, t44._fld20381rref, t45._fld20603rref, t46._fld20381rref, t47._fld20381rref, t48._fld20603rref
  • Inner Unique: true
  • Join Filter: (t22._fld2307rref = t48._idrref)
  • Rows Removed by Join Filter: 1710
  • Buffers: shared hit=7952 dirtied=1, local hit=343
7. 0.372 62.936 ↓ 171.0 171 1

Nested Loop Left Join (cost=25.16..67.77 rows=1 width=1,773) (actual time=6.510..62.936 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t9._date_time, t9._number, t9._fld9106rref, t10._date_time, t10._number, t10._fld5630rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t13._date_time, t13._number, t13._fld2533rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref, t17._date_time, t17._number, t17._fld6043rref, t18._date_time, t18._number, t18._fld5795rref, t19._date_time, t19._number, t19._fld6136rref, t20._date_time, t20._number, t20._fld5877rref, t21._date_time, t21._number, t21._fld7396rref, t21._fld7386rref, t22._date_time, t22._number, t22._fld2307rref, t23._date_time, t23._number, t23._fld6304rref, t24._date_time, t24._number, t24._fld2885rref, t25._date_time, t25._number, t25._fld7061rref, t25._fld7084_type, t25._fld7084_rtref, t25._fld7084_rrref, t26._fld20612, t27._fld20389, t28._fld24847rref, t29._fld20381rref, t30._fld20603rref, t31._fld20381rref, t32._fld20603rref, t33._fld20381rref, t34._fld20381rref, t35._fld20381rref, t36._fld20381rref, t37._fld20603rref, t38._fld20381rref, t39._fld20381rref, t40._fld20381rref, t41._fld20603rref, t42._fld20381rref, t43._fld20603rref, t44._fld20381rref, t45._fld20603rref, t46._fld20381rref, t47._fld20381rref
  • Inner Unique: true
  • Buffers: shared hit=7781 dirtied=1, local hit=343
8. 0.433 62.564 ↓ 171.0 171 1

Nested Loop Left Join (cost=25.05..67.54 rows=1 width=1,756) (actual time=6.503..62.564 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t9._date_time, t9._number, t9._fld9106rref, t10._date_time, t10._number, t10._fld5630rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t13._date_time, t13._number, t13._fld2533rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref, t17._date_time, t17._number, t17._fld6043rref, t18._date_time, t18._number, t18._fld5795rref, t19._date_time, t19._number, t19._fld6136rref, t20._date_time, t20._number, t20._fld5877rref, t21._date_time, t21._number, t21._fld7396rref, t21._fld7386rref, t22._date_time, t22._number, t22._fld2307rref, t23._date_time, t23._number, t23._fld6304rref, t24._date_time, t24._number, t24._fld2885rref, t25._date_time, t25._number, t25._fld7061rref, t25._fld7084_type, t25._fld7084_rtref, t25._fld7084_rrref, t26._fld20612, t27._fld20389, t28._fld24847rref, t29._fld20381rref, t30._fld20603rref, t31._fld20381rref, t32._fld20603rref, t33._fld20381rref, t34._fld20381rref, t35._fld20381rref, t36._fld20381rref, t37._fld20603rref, t38._fld20381rref, t39._fld20381rref, t40._fld20381rref, t41._fld20603rref, t42._fld20381rref, t43._fld20603rref, t44._fld20381rref, t45._fld20603rref, t46._fld20381rref
  • Inner Unique: true
  • Buffers: shared hit=7781 dirtied=1, local hit=343
9. 0.786 62.131 ↓ 171.0 171 1

Nested Loop Left Join (cost=24.94..65.21 rows=1 width=1,739) (actual time=6.495..62.131 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t9._date_time, t9._number, t9._fld9106rref, t10._date_time, t10._number, t10._fld5630rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t13._date_time, t13._number, t13._fld2533rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref, t17._date_time, t17._number, t17._fld6043rref, t18._date_time, t18._number, t18._fld5795rref, t19._date_time, t19._number, t19._fld6136rref, t20._date_time, t20._number, t20._fld5877rref, t21._date_time, t21._number, t21._fld7396rref, t21._fld7386rref, t22._date_time, t22._number, t22._fld2307rref, t23._date_time, t23._number, t23._fld6304rref, t24._date_time, t24._number, t24._fld2885rref, t25._date_time, t25._number, t25._fld7061rref, t25._fld7084_type, t25._fld7084_rtref, t25._fld7084_rrref, t26._fld20612, t27._fld20389, t28._fld24847rref, t29._fld20381rref, t30._fld20603rref, t31._fld20381rref, t32._fld20603rref, t33._fld20381rref, t34._fld20381rref, t35._fld20381rref, t36._fld20381rref, t37._fld20603rref, t38._fld20381rref, t39._fld20381rref, t40._fld20381rref, t41._fld20603rref, t42._fld20381rref, t43._fld20603rref, t44._fld20381rref, t45._fld20603rref
  • Inner Unique: true
  • Join Filter: (t19._fld6136rref = t45._idrref)
  • Rows Removed by Join Filter: 1710
  • Buffers: shared hit=7781 dirtied=1, local hit=343
10. 0.454 59.464 ↓ 171.0 171 1

Nested Loop Left Join (cost=24.94..63.99 rows=1 width=1,722) (actual time=6.466..59.464 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t9._date_time, t9._number, t9._fld9106rref, t10._date_time, t10._number, t10._fld5630rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t13._date_time, t13._number, t13._fld2533rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref, t17._date_time, t17._number, t17._fld6043rref, t18._date_time, t18._number, t18._fld5795rref, t19._date_time, t19._number, t19._fld6136rref, t20._date_time, t20._number, t20._fld5877rref, t21._date_time, t21._number, t21._fld7396rref, t21._fld7386rref, t22._date_time, t22._number, t22._fld2307rref, t23._date_time, t23._number, t23._fld6304rref, t24._date_time, t24._number, t24._fld2885rref, t25._date_time, t25._number, t25._fld7061rref, t25._fld7084_type, t25._fld7084_rtref, t25._fld7084_rrref, t26._fld20612, t27._fld20389, t28._fld24847rref, t29._fld20381rref, t30._fld20603rref, t31._fld20381rref, t32._fld20603rref, t33._fld20381rref, t34._fld20381rref, t35._fld20381rref, t36._fld20381rref, t37._fld20603rref, t38._fld20381rref, t39._fld20381rref, t40._fld20381rref, t41._fld20603rref, t42._fld20381rref, t43._fld20603rref, t44._fld20381rref
  • Inner Unique: true
  • Buffers: shared hit=7610 dirtied=1, local hit=343
11. 1.054 59.010 ↓ 171.0 171 1

Nested Loop Left Join (cost=24.83..61.65 rows=1 width=1,705) (actual time=6.458..59.010 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t9._date_time, t9._number, t9._fld9106rref, t10._date_time, t10._number, t10._fld5630rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t13._date_time, t13._number, t13._fld2533rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref, t17._date_time, t17._number, t17._fld6043rref, t18._date_time, t18._number, t18._fld5795rref, t19._date_time, t19._number, t19._fld6136rref, t20._date_time, t20._number, t20._fld5877rref, t21._date_time, t21._number, t21._fld7396rref, t21._fld7386rref, t22._date_time, t22._number, t22._fld2307rref, t23._date_time, t23._number, t23._fld6304rref, t24._date_time, t24._number, t24._fld2885rref, t25._date_time, t25._number, t25._fld7061rref, t25._fld7084_type, t25._fld7084_rtref, t25._fld7084_rrref, t26._fld20612, t27._fld20389, t28._fld24847rref, t29._fld20381rref, t30._fld20603rref, t31._fld20381rref, t32._fld20603rref, t33._fld20381rref, t34._fld20381rref, t35._fld20381rref, t36._fld20381rref, t37._fld20603rref, t38._fld20381rref, t39._fld20381rref, t40._fld20381rref, t41._fld20603rref, t42._fld20381rref, t43._fld20603rref
  • Inner Unique: true
  • Join Filter: (t17._fld6043rref = t43._idrref)
  • Rows Removed by Join Filter: 1710
  • Buffers: shared hit=7610 dirtied=1, local hit=343
12. 0.339 55.733 ↓ 171.0 171 1

Nested Loop Left Join (cost=24.83..60.43 rows=1 width=1,688) (actual time=6.420..55.733 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t9._date_time, t9._number, t9._fld9106rref, t10._date_time, t10._number, t10._fld5630rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t13._date_time, t13._number, t13._fld2533rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref, t17._date_time, t17._number, t17._fld6043rref, t18._date_time, t18._number, t18._fld5795rref, t19._date_time, t19._number, t19._fld6136rref, t20._date_time, t20._number, t20._fld5877rref, t21._date_time, t21._number, t21._fld7396rref, t21._fld7386rref, t22._date_time, t22._number, t22._fld2307rref, t23._date_time, t23._number, t23._fld6304rref, t24._date_time, t24._number, t24._fld2885rref, t25._date_time, t25._number, t25._fld7061rref, t25._fld7084_type, t25._fld7084_rtref, t25._fld7084_rrref, t26._fld20612, t27._fld20389, t28._fld24847rref, t29._fld20381rref, t30._fld20603rref, t31._fld20381rref, t32._fld20603rref, t33._fld20381rref, t34._fld20381rref, t35._fld20381rref, t36._fld20381rref, t37._fld20603rref, t38._fld20381rref, t39._fld20381rref, t40._fld20381rref, t41._fld20603rref, t42._fld20381rref
  • Inner Unique: true
  • Join Filter: ((t14._fld8588_type = '\\x08'::bytea) AND (t14._fld8588_rtref = '\\x00000069'::bytea))
  • Buffers: shared hit=7439 dirtied=1, local hit=343
13. 0.354 55.394 ↓ 171.0 171 1

Nested Loop Left Join (cost=24.72..60.28 rows=1 width=1,671) (actual time=6.414..55.394 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t9._date_time, t9._number, t9._fld9106rref, t10._date_time, t10._number, t10._fld5630rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t13._date_time, t13._number, t13._fld2533rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref, t17._date_time, t17._number, t17._fld6043rref, t18._date_time, t18._number, t18._fld5795rref, t19._date_time, t19._number, t19._fld6136rref, t20._date_time, t20._number, t20._fld5877rref, t21._date_time, t21._number, t21._fld7396rref, t21._fld7386rref, t22._date_time, t22._number, t22._fld2307rref, t23._date_time, t23._number, t23._fld6304rref, t24._date_time, t24._number, t24._fld2885rref, t25._date_time, t25._number, t25._fld7061rref, t25._fld7084_type, t25._fld7084_rtref, t25._fld7084_rrref, t26._fld20612, t27._fld20389, t28._fld24847rref, t29._fld20381rref, t30._fld20603rref, t31._fld20381rref, t32._fld20603rref, t33._fld20381rref, t34._fld20381rref, t35._fld20381rref, t36._fld20381rref, t37._fld20603rref, t38._fld20381rref, t39._fld20381rref, t40._fld20381rref, t41._fld20603rref
  • Inner Unique: true
  • Join Filter: ((t14._fld8588_type = '\\x08'::bytea) AND (t14._fld8588_rtref = '\\x0000006d'::bytea))
  • Buffers: shared hit=7439 dirtied=1, local hit=343
14. 0.355 55.040 ↓ 171.0 171 1

Nested Loop Left Join (cost=24.67..60.20 rows=1 width=1,654) (actual time=6.407..55.040 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t9._date_time, t9._number, t9._fld9106rref, t10._date_time, t10._number, t10._fld5630rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t13._date_time, t13._number, t13._fld2533rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref, t17._date_time, t17._number, t17._fld6043rref, t18._date_time, t18._number, t18._fld5795rref, t19._date_time, t19._number, t19._fld6136rref, t20._date_time, t20._number, t20._fld5877rref, t21._date_time, t21._number, t21._fld7396rref, t21._fld7386rref, t22._date_time, t22._number, t22._fld2307rref, t23._date_time, t23._number, t23._fld6304rref, t24._date_time, t24._number, t24._fld2885rref, t25._date_time, t25._number, t25._fld7061rref, t25._fld7084_type, t25._fld7084_rtref, t25._fld7084_rrref, t26._fld20612, t27._fld20389, t28._fld24847rref, t29._fld20381rref, t30._fld20603rref, t31._fld20381rref, t32._fld20603rref, t33._fld20381rref, t34._fld20381rref, t35._fld20381rref, t36._fld20381rref, t37._fld20603rref, t38._fld20381rref, t39._fld20381rref, t40._fld20381rref
  • Inner Unique: true
  • Buffers: shared hit=7439 dirtied=1, local hit=343
15. 0.327 54.685 ↓ 171.0 171 1

Nested Loop Left Join (cost=24.56..58.86 rows=1 width=1,637) (actual time=6.399..54.685 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t9._date_time, t9._number, t9._fld9106rref, t10._date_time, t10._number, t10._fld5630rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t13._date_time, t13._number, t13._fld2533rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref, t17._date_time, t17._number, t17._fld6043rref, t18._date_time, t18._number, t18._fld5795rref, t19._date_time, t19._number, t19._fld6136rref, t20._date_time, t20._number, t20._fld5877rref, t21._date_time, t21._number, t21._fld7396rref, t21._fld7386rref, t22._date_time, t22._number, t22._fld2307rref, t23._date_time, t23._number, t23._fld6304rref, t24._date_time, t24._number, t24._fld2885rref, t25._date_time, t25._number, t25._fld7061rref, t25._fld7084_type, t25._fld7084_rtref, t25._fld7084_rrref, t26._fld20612, t27._fld20389, t28._fld24847rref, t29._fld20381rref, t30._fld20603rref, t31._fld20381rref, t32._fld20603rref, t33._fld20381rref, t34._fld20381rref, t35._fld20381rref, t36._fld20381rref, t37._fld20603rref, t38._fld20381rref, t39._fld20381rref
  • Inner Unique: true
  • Buffers: shared hit=7439 dirtied=1, local hit=343
16. 0.366 54.358 ↓ 171.0 171 1

Nested Loop Left Join (cost=24.44..58.71 rows=1 width=1,620) (actual time=6.394..54.358 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t9._date_time, t9._number, t9._fld9106rref, t10._date_time, t10._number, t10._fld5630rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t13._date_time, t13._number, t13._fld2533rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref, t17._date_time, t17._number, t17._fld6043rref, t18._date_time, t18._number, t18._fld5795rref, t19._date_time, t19._number, t19._fld6136rref, t20._date_time, t20._number, t20._fld5877rref, t21._date_time, t21._number, t21._fld7396rref, t21._fld7386rref, t22._date_time, t22._number, t22._fld2307rref, t23._date_time, t23._number, t23._fld6304rref, t24._date_time, t24._number, t24._fld2885rref, t25._date_time, t25._number, t25._fld7061rref, t25._fld7084_type, t25._fld7084_rtref, t25._fld7084_rrref, t26._fld20612, t27._fld20389, t28._fld24847rref, t29._fld20381rref, t30._fld20603rref, t31._fld20381rref, t32._fld20603rref, t33._fld20381rref, t34._fld20381rref, t35._fld20381rref, t36._fld20381rref, t37._fld20603rref, t38._fld20381rref
  • Inner Unique: true
  • Join Filter: ((t11._fld6230_type = '\\x08'::bytea) AND (t11._fld6230_rtref = '\\x00000069'::bytea))
  • Buffers: shared hit=7439 dirtied=1, local hit=343
17. 0.404 53.992 ↓ 171.0 171 1

Nested Loop Left Join (cost=24.33..58.47 rows=1 width=1,603) (actual time=6.388..53.992 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t9._date_time, t9._number, t9._fld9106rref, t10._date_time, t10._number, t10._fld5630rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t13._date_time, t13._number, t13._fld2533rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref, t17._date_time, t17._number, t17._fld6043rref, t18._date_time, t18._number, t18._fld5795rref, t19._date_time, t19._number, t19._fld6136rref, t20._date_time, t20._number, t20._fld5877rref, t21._date_time, t21._number, t21._fld7396rref, t21._fld7386rref, t22._date_time, t22._number, t22._fld2307rref, t23._date_time, t23._number, t23._fld6304rref, t24._date_time, t24._number, t24._fld2885rref, t25._date_time, t25._number, t25._fld7061rref, t25._fld7084_type, t25._fld7084_rtref, t25._fld7084_rrref, t26._fld20612, t27._fld20389, t28._fld24847rref, t29._fld20381rref, t30._fld20603rref, t31._fld20381rref, t32._fld20603rref, t33._fld20381rref, t34._fld20381rref, t35._fld20381rref, t36._fld20381rref, t37._fld20603rref
  • Inner Unique: true
  • Join Filter: ((t11._fld6230_type = '\\x08'::bytea) AND (t11._fld6230_rtref = '\\x0000006d'::bytea))
  • Buffers: shared hit=7439 dirtied=1, local hit=343
18. 0.351 53.588 ↓ 171.0 171 1

Nested Loop Left Join (cost=24.28..58.39 rows=1 width=1,586) (actual time=6.382..53.588 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t9._date_time, t9._number, t9._fld9106rref, t10._date_time, t10._number, t10._fld5630rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t13._date_time, t13._number, t13._fld2533rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref, t17._date_time, t17._number, t17._fld6043rref, t18._date_time, t18._number, t18._fld5795rref, t19._date_time, t19._number, t19._fld6136rref, t20._date_time, t20._number, t20._fld5877rref, t21._date_time, t21._number, t21._fld7396rref, t21._fld7386rref, t22._date_time, t22._number, t22._fld2307rref, t23._date_time, t23._number, t23._fld6304rref, t24._date_time, t24._number, t24._fld2885rref, t25._date_time, t25._number, t25._fld7061rref, t25._fld7084_type, t25._fld7084_rtref, t25._fld7084_rrref, t26._fld20612, t27._fld20389, t28._fld24847rref, t29._fld20381rref, t30._fld20603rref, t31._fld20381rref, t32._fld20603rref, t33._fld20381rref, t34._fld20381rref, t35._fld20381rref, t36._fld20381rref
  • Inner Unique: true
  • Buffers: shared hit=7439 dirtied=1, local hit=343
19. 0.384 53.237 ↓ 171.0 171 1

Nested Loop Left Join (cost=24.17..56.06 rows=1 width=1,569) (actual time=6.375..53.237 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t9._date_time, t9._number, t9._fld9106rref, t10._date_time, t10._number, t10._fld5630rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t13._date_time, t13._number, t13._fld2533rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref, t17._date_time, t17._number, t17._fld6043rref, t18._date_time, t18._number, t18._fld5795rref, t19._date_time, t19._number, t19._fld6136rref, t20._date_time, t20._number, t20._fld5877rref, t21._date_time, t21._number, t21._fld7396rref, t21._fld7386rref, t22._date_time, t22._number, t22._fld2307rref, t23._date_time, t23._number, t23._fld6304rref, t24._date_time, t24._number, t24._fld2885rref, t25._date_time, t25._number, t25._fld7061rref, t25._fld7084_type, t25._fld7084_rtref, t25._fld7084_rrref, t26._fld20612, t27._fld20389, t28._fld24847rref, t29._fld20381rref, t30._fld20603rref, t31._fld20381rref, t32._fld20603rref, t33._fld20381rref, t34._fld20381rref, t35._fld20381rref
  • Inner Unique: true
  • Buffers: shared hit=7439 dirtied=1, local hit=343
20. 0.360 52.169 ↓ 171.0 171 1

Nested Loop Left Join (cost=24.06..55.36 rows=1 width=1,552) (actual time=6.357..52.169 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t9._date_time, t9._number, t9._fld9106rref, t10._date_time, t10._number, t10._fld5630rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t13._date_time, t13._number, t13._fld2533rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref, t17._date_time, t17._number, t17._fld6043rref, t18._date_time, t18._number, t18._fld5795rref, t19._date_time, t19._number, t19._fld6136rref, t20._date_time, t20._number, t20._fld5877rref, t21._date_time, t21._number, t21._fld7396rref, t21._fld7386rref, t22._date_time, t22._number, t22._fld2307rref, t23._date_time, t23._number, t23._fld6304rref, t24._date_time, t24._number, t24._fld2885rref, t25._date_time, t25._number, t25._fld7061rref, t25._fld7084_type, t25._fld7084_rtref, t25._fld7084_rrref, t26._fld20612, t27._fld20389, t28._fld24847rref, t29._fld20381rref, t30._fld20603rref, t31._fld20381rref, t32._fld20603rref, t33._fld20381rref, t34._fld20381rref
  • Inner Unique: true
  • Buffers: shared hit=7097 dirtied=1, local hit=343
21. 0.383 51.809 ↓ 171.0 171 1

Nested Loop Left Join (cost=23.95..55.21 rows=1 width=1,535) (actual time=6.350..51.809 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t9._date_time, t9._number, t9._fld9106rref, t10._date_time, t10._number, t10._fld5630rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t13._date_time, t13._number, t13._fld2533rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref, t17._date_time, t17._number, t17._fld6043rref, t18._date_time, t18._number, t18._fld5795rref, t19._date_time, t19._number, t19._fld6136rref, t20._date_time, t20._number, t20._fld5877rref, t21._date_time, t21._number, t21._fld7396rref, t21._fld7386rref, t22._date_time, t22._number, t22._fld2307rref, t23._date_time, t23._number, t23._fld6304rref, t24._date_time, t24._number, t24._fld2885rref, t25._date_time, t25._number, t25._fld7061rref, t25._fld7084_type, t25._fld7084_rtref, t25._fld7084_rrref, t26._fld20612, t27._fld20389, t28._fld24847rref, t29._fld20381rref, t30._fld20603rref, t31._fld20381rref, t32._fld20603rref, t33._fld20381rref
  • Inner Unique: true
  • Join Filter: ((t7._fld7464_type = '\\x08'::bytea) AND (t7._fld7464_rtref = '\\x00000069'::bytea))
  • Buffers: shared hit=7097 dirtied=1, local hit=343
22. 0.335 51.426 ↓ 171.0 171 1

Nested Loop Left Join (cost=23.84..55.06 rows=1 width=1,518) (actual time=6.342..51.426 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t9._date_time, t9._number, t9._fld9106rref, t10._date_time, t10._number, t10._fld5630rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t13._date_time, t13._number, t13._fld2533rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref, t17._date_time, t17._number, t17._fld6043rref, t18._date_time, t18._number, t18._fld5795rref, t19._date_time, t19._number, t19._fld6136rref, t20._date_time, t20._number, t20._fld5877rref, t21._date_time, t21._number, t21._fld7396rref, t21._fld7386rref, t22._date_time, t22._number, t22._fld2307rref, t23._date_time, t23._number, t23._fld6304rref, t24._date_time, t24._number, t24._fld2885rref, t25._date_time, t25._number, t25._fld7061rref, t25._fld7084_type, t25._fld7084_rtref, t25._fld7084_rrref, t26._fld20612, t27._fld20389, t28._fld24847rref, t29._fld20381rref, t30._fld20603rref, t31._fld20381rref, t32._fld20603rref
  • Inner Unique: true
  • Join Filter: ((t7._fld7464_type = '\\x08'::bytea) AND (t7._fld7464_rtref = '\\x0000006d'::bytea))
  • Buffers: shared hit=7097 dirtied=1, local hit=343
23. 0.328 51.091 ↓ 171.0 171 1

Nested Loop Left Join (cost=23.78..54.97 rows=1 width=1,501) (actual time=6.336..51.091 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t9._date_time, t9._number, t9._fld9106rref, t10._date_time, t10._number, t10._fld5630rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t13._date_time, t13._number, t13._fld2533rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref, t17._date_time, t17._number, t17._fld6043rref, t18._date_time, t18._number, t18._fld5795rref, t19._date_time, t19._number, t19._fld6136rref, t20._date_time, t20._number, t20._fld5877rref, t21._date_time, t21._number, t21._fld7396rref, t21._fld7386rref, t22._date_time, t22._number, t22._fld2307rref, t23._date_time, t23._number, t23._fld6304rref, t24._date_time, t24._number, t24._fld2885rref, t25._date_time, t25._number, t25._fld7061rref, t25._fld7084_type, t25._fld7084_rtref, t25._fld7084_rrref, t26._fld20612, t27._fld20389, t28._fld24847rref, t29._fld20381rref, t30._fld20603rref, t31._fld20381rref
  • Inner Unique: true
  • Join Filter: ((t6._fld7912_type = '\\x08'::bytea) AND (t6._fld7912_rtref = '\\x00000069'::bytea))
  • Buffers: shared hit=7097 dirtied=1, local hit=343
24. 0.403 50.763 ↓ 171.0 171 1

Nested Loop Left Join (cost=23.67..54.74 rows=1 width=1,484) (actual time=6.328..50.763 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t9._date_time, t9._number, t9._fld9106rref, t10._date_time, t10._number, t10._fld5630rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t13._date_time, t13._number, t13._fld2533rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref, t17._date_time, t17._number, t17._fld6043rref, t18._date_time, t18._number, t18._fld5795rref, t19._date_time, t19._number, t19._fld6136rref, t20._date_time, t20._number, t20._fld5877rref, t21._date_time, t21._number, t21._fld7396rref, t21._fld7386rref, t22._date_time, t22._number, t22._fld2307rref, t23._date_time, t23._number, t23._fld6304rref, t24._date_time, t24._number, t24._fld2885rref, t25._date_time, t25._number, t25._fld7061rref, t25._fld7084_type, t25._fld7084_rtref, t25._fld7084_rrref, t26._fld20612, t27._fld20389, t28._fld24847rref, t29._fld20381rref, t30._fld20603rref
  • Inner Unique: true
  • Join Filter: ((t6._fld7912_type = '\\x08'::bytea) AND (t6._fld7912_rtref = '\\x0000006d'::bytea))
  • Buffers: shared hit=7097 dirtied=1, local hit=343
25. 0.954 50.360 ↓ 171.0 171 1

Nested Loop Left Join (cost=23.62..54.66 rows=1 width=1,467) (actual time=6.320..50.360 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t9._date_time, t9._number, t9._fld9106rref, t10._date_time, t10._number, t10._fld5630rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t13._date_time, t13._number, t13._fld2533rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref, t17._date_time, t17._number, t17._fld6043rref, t18._date_time, t18._number, t18._fld5795rref, t19._date_time, t19._number, t19._fld6136rref, t20._date_time, t20._number, t20._fld5877rref, t21._date_time, t21._number, t21._fld7396rref, t21._fld7386rref, t22._date_time, t22._number, t22._fld2307rref, t23._date_time, t23._number, t23._fld6304rref, t24._date_time, t24._number, t24._fld2885rref, t25._date_time, t25._number, t25._fld7061rref, t25._fld7084_type, t25._fld7084_rtref, t25._fld7084_rrref, t26._fld20612, t27._fld20389, t28._fld24847rref, t29._fld20381rref
  • Inner Unique: true
  • Join Filter: ((CASE WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001fe'::bytea)) THEN t6._fld7912_type WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f4'::bytea)) THEN t7._fld7464_type WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f2'::bytea)) THEN CASE WHEN (t8._fld7233rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000021d'::bytea)) THEN CASE WHEN (t9._fld9106rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001d8'::bytea)) THEN CASE WHEN (t10._fld5630rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001e1'::bytea)) THEN t11._fld6230_type WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001a4'::bytea)) THEN CASE WHEN (t12._fld3492rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x00000195'::bytea)) THEN CASE WHEN (t13._fld2533rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000020d'::bytea)) THEN t14._fld8588_type WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001dd'::bytea)) THEN CASE WHEN (t17._fld6043rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001da'::bytea)) THEN CASE WHEN (t18._fld5795rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001de'::bytea)) THEN CASE WHEN (t19._fld6136rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001db'::bytea)) THEN CASE WHEN (t20._fld5877rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f3'::bytea)) THEN CASE WHEN (t21._fld7386rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x00000193'::bytea)) THEN CASE WHEN (t22._fld2307rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001e3'::bytea)) THEN CASE WHEN (t23._fld6304rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000019a'::bytea)) THEN CASE WHEN (t24._fld2885rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f0'::bytea)) THEN t25._fld7084_type ELSE NULL::bytea END = '\\x08'::bytea) AND (CASE WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001fe'::bytea)) THEN t6._fld7912_rtref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f4'::bytea)) THEN t7._fld7464_rtref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f2'::bytea)) THEN CASE WHEN (t8._fld7233rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000021d'::bytea)) THEN CASE WHEN (t9._fld9106rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001d8'::bytea)) THEN CASE WHEN (t10._fld5630rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001e1'::bytea)) THEN t11._fld6230_rtref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001a4'::bytea)) THEN CASE WHEN (t12._fld3492rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x00000195'::bytea)) THEN CASE WHEN (t13._fld2533rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000020d'::bytea)) THEN t14._fld8588_rtref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001dd'::bytea)) THEN CASE WHEN (t17._fld6043rref IS NOT NULL) THEN '\\x0000006d'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001da'::bytea)) THEN CASE WHEN (t18._fld5795rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001de'::bytea)) THEN CASE WHEN (t19._fld6136rref IS NOT NULL) THEN '\\x0000006d'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001db'::bytea)) THEN CASE WHEN (t20._fld5877rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f3'::bytea)) THEN CASE WHEN (t21._fld7386rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x00000193'::bytea)) THEN CASE WHEN (t22._fld2307rref IS NOT NULL) THEN '\\x0000006d'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001e3'::bytea)) THEN CASE WHEN (t23._fld6304rref IS NOT NULL) THEN '\\x0000006d'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000019a'::bytea)) THEN CASE WHEN (t24._fld2885rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f0'::bytea)) THEN t25._fld7084_rtref ELSE NULL::bytea END = '\\x00000069'::bytea))
  • Buffers: shared hit=7097 dirtied=1, local hit=343
26. 0.732 48.722 ↓ 171.0 171 1

Nested Loop Left Join (cost=23.47..52.21 rows=1 width=1,450) (actual time=6.279..48.722 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t9._date_time, t9._number, t9._fld9106rref, t10._date_time, t10._number, t10._fld5630rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t13._date_time, t13._number, t13._fld2533rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref, t17._date_time, t17._number, t17._fld6043rref, t18._date_time, t18._number, t18._fld5795rref, t19._date_time, t19._number, t19._fld6136rref, t20._date_time, t20._number, t20._fld5877rref, t21._date_time, t21._number, t21._fld7396rref, t21._fld7386rref, t22._date_time, t22._number, t22._fld2307rref, t23._date_time, t23._number, t23._fld6304rref, t24._date_time, t24._number, t24._fld2885rref, t25._date_time, t25._number, t25._fld7061rref, t25._fld7084_type, t25._fld7084_rtref, t25._fld7084_rrref, t26._fld20612, t27._fld20389, t28._fld24847rref
  • Inner Unique: true
  • Join Filter: (CASE WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f2'::bytea)) THEN CASE WHEN (t8._fld7262rref IS NOT NULL) THEN '\\x0000012f'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000021d'::bytea)) THEN CASE WHEN (t9._fld9105rref IS NOT NULL) THEN '\\x0000012f'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001d8'::bytea)) THEN CASE WHEN (t10._fld5604rref IS NOT NULL) THEN '\\x0000012d'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001a4'::bytea)) THEN CASE WHEN (t12._fld3465rref IS NOT NULL) THEN '\\x0000012f'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x00000195'::bytea)) THEN CASE WHEN (t13._fld2515rref IS NOT NULL) THEN '\\x0000012f'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001da'::bytea)) THEN CASE WHEN (t18._fld5773rref IS NOT NULL) THEN '\\x0000012f'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001db'::bytea)) THEN CASE WHEN (t20._fld5864rref IS NOT NULL) THEN '\\x0000012f'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f3'::bytea)) THEN CASE WHEN (t21._fld7367rref IS NOT NULL) THEN '\\x0000012f'::bytea ELSE NULL::bytea END WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000019a'::bytea)) THEN CASE WHEN (t24._fld2875rref IS NOT NULL) THEN '\\x0000012f'::bytea ELSE NULL::bytea END ELSE NULL::bytea END = '\\x0000012f'::bytea)
  • Buffers: shared hit=6755 dirtied=1, local hit=343
27. 0.431 47.135 ↓ 171.0 171 1

Nested Loop Left Join (cost=23.34..49.83 rows=1 width=1,646) (actual time=6.215..47.135 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t8._fld7262rref, t9._date_time, t9._number, t9._fld9106rref, t9._fld9105rref, t10._date_time, t10._number, t10._fld5630rref, t10._fld5604rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t12._fld3465rref, t13._date_time, t13._number, t13._fld2533rref, t13._fld2515rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref, t17._date_time, t17._number, t17._fld6043rref, t18._date_time, t18._number, t18._fld5795rref, t18._fld5773rref, t19._date_time, t19._number, t19._fld6136rref, t20._date_time, t20._number, t20._fld5877rref, t20._fld5864rref, t21._date_time, t21._number, t21._fld7396rref, t21._fld7386rref, t21._fld7367rref, t22._date_time, t22._number, t22._fld2307rref, t23._date_time, t23._number, t23._fld6304rref, t24._date_time, t24._number, t24._fld2885rref, t24._fld2875rref, t25._date_time, t25._number, t25._fld7061rref, t25._fld7084_type, t25._fld7084_rtref, t25._fld7084_rrref, t26._fld20612, t27._fld20389
  • Inner Unique: true
  • Join Filter: ((t4._q_001_f_004_type = '\\x08'::bytea) AND (t4._q_001_f_004_rtref = '\\x00000069'::bytea))
  • Buffers: shared hit=6413 dirtied=1, local hit=343
28. 1.459 45.678 ↓ 171.0 171 1

Nested Loop Left Join (cost=23.23..47.49 rows=1 width=1,645) (actual time=6.192..45.678 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t8._fld7262rref, t9._date_time, t9._number, t9._fld9106rref, t9._fld9105rref, t10._date_time, t10._number, t10._fld5630rref, t10._fld5604rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t12._fld3465rref, t13._date_time, t13._number, t13._fld2533rref, t13._fld2515rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref, t17._date_time, t17._number, t17._fld6043rref, t18._date_time, t18._number, t18._fld5795rref, t18._fld5773rref, t19._date_time, t19._number, t19._fld6136rref, t20._date_time, t20._number, t20._fld5877rref, t20._fld5864rref, t21._date_time, t21._number, t21._fld7396rref, t21._fld7386rref, t21._fld7367rref, t22._date_time, t22._number, t22._fld2307rref, t23._date_time, t23._number, t23._fld6304rref, t24._date_time, t24._number, t24._fld2885rref, t24._fld2875rref, t25._date_time, t25._number, t25._fld7061rref, t25._fld7084_type, t25._fld7084_rtref, t25._fld7084_rrref, t26._fld20612
  • Inner Unique: true
  • Join Filter: ((t4._q_001_f_004_type = '\\x08'::bytea) AND (t4._q_001_f_004_rtref = '\\x0000006d'::bytea) AND (t4._q_001_f_004_rrref = t26._idrref))
  • Rows Removed by Join Filter: 1710
  • Buffers: shared hit=6071 dirtied=1, local hit=343
29. 0.337 41.996 ↓ 171.0 171 1

Nested Loop Left Join (cost=23.23..46.25 rows=1 width=1,644) (actual time=6.136..41.996 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t8._fld7262rref, t9._date_time, t9._number, t9._fld9106rref, t9._fld9105rref, t10._date_time, t10._number, t10._fld5630rref, t10._fld5604rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t12._fld3465rref, t13._date_time, t13._number, t13._fld2533rref, t13._fld2515rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref, t17._date_time, t17._number, t17._fld6043rref, t18._date_time, t18._number, t18._fld5795rref, t18._fld5773rref, t19._date_time, t19._number, t19._fld6136rref, t20._date_time, t20._number, t20._fld5877rref, t20._fld5864rref, t21._date_time, t21._number, t21._fld7396rref, t21._fld7386rref, t21._fld7367rref, t22._date_time, t22._number, t22._fld2307rref, t23._date_time, t23._number, t23._fld6304rref, t24._date_time, t24._number, t24._fld2885rref, t24._fld2875rref, t25._date_time, t25._number, t25._fld7061rref, t25._fld7084_type, t25._fld7084_rtref, t25._fld7084_rrref
  • Inner Unique: true
  • Join Filter: ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f0'::bytea))
  • Buffers: shared hit=5900 dirtied=1, local hit=343
30. 0.388 39.094 ↓ 171.0 171 1

Nested Loop Left Join (cost=23.06..45.10 rows=1 width=1,568) (actual time=6.021..39.094 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t8._fld7262rref, t9._date_time, t9._number, t9._fld9106rref, t9._fld9105rref, t10._date_time, t10._number, t10._fld5630rref, t10._fld5604rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t12._fld3465rref, t13._date_time, t13._number, t13._fld2533rref, t13._fld2515rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref, t17._date_time, t17._number, t17._fld6043rref, t18._date_time, t18._number, t18._fld5795rref, t18._fld5773rref, t19._date_time, t19._number, t19._fld6136rref, t20._date_time, t20._number, t20._fld5877rref, t20._fld5864rref, t21._date_time, t21._number, t21._fld7396rref, t21._fld7386rref, t21._fld7367rref, t22._date_time, t22._number, t22._fld2307rref, t23._date_time, t23._number, t23._fld6304rref, t24._date_time, t24._number, t24._fld2885rref, t24._fld2875rref
  • Inner Unique: true
  • Join Filter: ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000019a'::bytea))
  • Buffers: shared hit=5387 dirtied=1, local hit=343
31. 0.432 38.364 ↓ 171.0 171 1

Nested Loop Left Join (cost=23.01..45.01 rows=1 width=1,464) (actual time=6.001..38.364 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t8._fld7262rref, t9._date_time, t9._number, t9._fld9106rref, t9._fld9105rref, t10._date_time, t10._number, t10._fld5630rref, t10._fld5604rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t12._fld3465rref, t13._date_time, t13._number, t13._fld2533rref, t13._fld2515rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref, t17._date_time, t17._number, t17._fld6043rref, t18._date_time, t18._number, t18._fld5795rref, t18._fld5773rref, t19._date_time, t19._number, t19._fld6136rref, t20._date_time, t20._number, t20._fld5877rref, t20._fld5864rref, t21._date_time, t21._number, t21._fld7396rref, t21._fld7386rref, t21._fld7367rref, t22._date_time, t22._number, t22._fld2307rref, t23._date_time, t23._number, t23._fld6304rref
  • Inner Unique: true
  • Join Filter: ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001e3'::bytea))
  • Buffers: shared hit=5216 dirtied=1, local hit=343
32. 0.368 36.735 ↓ 171.0 171 1

Nested Loop Left Join (cost=22.90..44.81 rows=1 width=1,412) (actual time=5.935..36.735 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t8._fld7262rref, t9._date_time, t9._number, t9._fld9106rref, t9._fld9105rref, t10._date_time, t10._number, t10._fld5630rref, t10._fld5604rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t12._fld3465rref, t13._date_time, t13._number, t13._fld2533rref, t13._fld2515rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref, t17._date_time, t17._number, t17._fld6043rref, t18._date_time, t18._number, t18._fld5795rref, t18._fld5773rref, t19._date_time, t19._number, t19._fld6136rref, t20._date_time, t20._number, t20._fld5877rref, t20._fld5864rref, t21._date_time, t21._number, t21._fld7396rref, t21._fld7386rref, t21._fld7367rref, t22._date_time, t22._number, t22._fld2307rref
  • Inner Unique: true
  • Join Filter: ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x00000193'::bytea))
  • Buffers: shared hit=4874 dirtied=1, local hit=343
33. 0.364 36.025 ↓ 171.0 171 1

Nested Loop Left Join (cost=22.84..44.72 rows=1 width=1,340) (actual time=5.913..36.025 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t8._fld7262rref, t9._date_time, t9._number, t9._fld9106rref, t9._fld9105rref, t10._date_time, t10._number, t10._fld5630rref, t10._fld5604rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t12._fld3465rref, t13._date_time, t13._number, t13._fld2533rref, t13._fld2515rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref, t17._date_time, t17._number, t17._fld6043rref, t18._date_time, t18._number, t18._fld5795rref, t18._fld5773rref, t19._date_time, t19._number, t19._fld6136rref, t20._date_time, t20._number, t20._fld5877rref, t20._fld5864rref, t21._date_time, t21._number, t21._fld7396rref, t21._fld7386rref, t21._fld7367rref
  • Inner Unique: true
  • Join Filter: ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f3'::bytea))
  • Buffers: shared hit=4703 dirtied=1, local hit=343
34. 0.387 34.293 ↓ 171.0 171 1

Nested Loop Left Join (cost=22.73..44.56 rows=1 width=1,258) (actual time=5.850..34.293 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t8._fld7262rref, t9._date_time, t9._number, t9._fld9106rref, t9._fld9105rref, t10._date_time, t10._number, t10._fld5630rref, t10._fld5604rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t12._fld3465rref, t13._date_time, t13._number, t13._fld2533rref, t13._fld2515rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref, t17._date_time, t17._number, t17._fld6043rref, t18._date_time, t18._number, t18._fld5795rref, t18._fld5773rref, t19._date_time, t19._number, t19._fld6136rref, t20._date_time, t20._number, t20._fld5877rref, t20._fld5864rref
  • Inner Unique: true
  • Join Filter: ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001db'::bytea))
  • Buffers: shared hit=4359 dirtied=1, local hit=343
35. 0.418 33.735 ↓ 171.0 171 1

Nested Loop Left Join (cost=22.67..44.48 rows=1 width=1,154) (actual time=5.835..33.735 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t8._fld7262rref, t9._date_time, t9._number, t9._fld9106rref, t9._fld9105rref, t10._date_time, t10._number, t10._fld5630rref, t10._fld5604rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t12._fld3465rref, t13._date_time, t13._number, t13._fld2533rref, t13._fld2515rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref, t17._date_time, t17._number, t17._fld6043rref, t18._date_time, t18._number, t18._fld5795rref, t18._fld5773rref, t19._date_time, t19._number, t19._fld6136rref
  • Inner Unique: true
  • Join Filter: ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001de'::bytea))
  • Buffers: shared hit=4188 dirtied=1, local hit=343
36. 0.283 33.146 ↓ 171.0 171 1

Nested Loop Left Join (cost=22.62..44.39 rows=1 width=1,082) (actual time=5.816..33.146 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t8._fld7262rref, t9._date_time, t9._number, t9._fld9106rref, t9._fld9105rref, t10._date_time, t10._number, t10._fld5630rref, t10._fld5604rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t12._fld3465rref, t13._date_time, t13._number, t13._fld2533rref, t13._fld2515rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref, t17._date_time, t17._number, t17._fld6043rref, t18._date_time, t18._number, t18._fld5795rref, t18._fld5773rref
  • Inner Unique: true
  • Join Filter: ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001da'::bytea))
  • Buffers: shared hit=4017 dirtied=1, local hit=343
37. 0.310 32.521 ↓ 171.0 171 1

Nested Loop Left Join (cost=22.56..44.30 rows=1 width=978) (actual time=5.786..32.521 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t8._fld7262rref, t9._date_time, t9._number, t9._fld9106rref, t9._fld9105rref, t10._date_time, t10._number, t10._fld5630rref, t10._fld5604rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t12._fld3465rref, t13._date_time, t13._number, t13._fld2533rref, t13._fld2515rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref, t17._date_time, t17._number, t17._fld6043rref
  • Inner Unique: true
  • Join Filter: ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001dd'::bytea))
  • Buffers: shared hit=3846 dirtied=1, local hit=343
38. 0.362 31.698 ↓ 171.0 171 1

Nested Loop Left Join (cost=22.51..44.22 rows=1 width=926) (actual time=5.749..31.698 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t8._fld7262rref, t9._date_time, t9._number, t9._fld9106rref, t9._fld9105rref, t10._date_time, t10._number, t10._fld5630rref, t10._fld5604rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t12._fld3465rref, t13._date_time, t13._number, t13._fld2533rref, t13._fld2515rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref, t16._fld20366, t16._fld20367, t16._fld20381rref
  • Inner Unique: true
  • Join Filter: ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x00000069'::bytea))
  • Buffers: shared hit=3675 dirtied=1, local hit=343
39. 0.373 30.139 ↓ 171.0 171 1

Nested Loop Left Join (cost=22.40..44.06 rows=1 width=887) (actual time=5.715..30.139 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t8._fld7262rref, t9._date_time, t9._number, t9._fld9106rref, t9._fld9105rref, t10._date_time, t10._number, t10._fld5630rref, t10._fld5604rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t12._fld3465rref, t13._date_time, t13._number, t13._fld2533rref, t13._fld2515rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t15._fld20593, t15._fld20594, t15._fld20603rref
  • Inner Unique: true
  • Join Filter: ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000006d'::bytea))
  • Buffers: shared hit=3332 dirtied=1, local hit=343
40. 0.373 29.253 ↓ 171.0 171 1

Nested Loop Left Join (cost=22.34..43.98 rows=1 width=848) (actual time=5.666..29.253 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t8._fld7262rref, t9._date_time, t9._number, t9._fld9106rref, t9._fld9105rref, t10._date_time, t10._number, t10._fld5630rref, t10._fld5604rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t12._fld3465rref, t13._date_time, t13._number, t13._fld2533rref, t13._fld2515rref, t14._date_time, t14._number, t14._fld8554rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref
  • Inner Unique: true
  • Join Filter: ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000020d'::bytea))
  • Buffers: shared hit=3161 dirtied=1, local hit=343
41. 0.295 19.475 ↓ 171.0 171 1

Nested Loop Left Join (cost=22.23..43.51 rows=1 width=773) (actual time=5.608..19.475 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t8._fld7262rref, t9._date_time, t9._number, t9._fld9106rref, t9._fld9105rref, t10._date_time, t10._number, t10._fld5630rref, t10._fld5604rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t12._fld3465rref, t13._date_time, t13._number, t13._fld2533rref, t13._fld2515rref
  • Inner Unique: true
  • Join Filter: ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x00000195'::bytea))
  • Buffers: shared hit=2819 dirtied=1, local hit=343
42. 0.400 18.496 ↓ 171.0 171 1

Nested Loop Left Join (cost=22.17..43.42 rows=1 width=704) (actual time=5.564..18.496 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t8._fld7262rref, t9._date_time, t9._number, t9._fld9106rref, t9._fld9105rref, t10._date_time, t10._number, t10._fld5630rref, t10._fld5604rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t12._date_time, t12._number, t12._fld3492rref, t12._fld3465rref
  • Inner Unique: true
  • Join Filter: ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001a4'::bytea))
  • Buffers: shared hit=2648 dirtied=1, local hit=343
43. 0.389 16.386 ↓ 171.0 171 1

Nested Loop Left Join (cost=22.06..43.14 rows=1 width=636) (actual time=5.509..16.386 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t8._fld7262rref, t9._date_time, t9._number, t9._fld9106rref, t9._fld9105rref, t10._date_time, t10._number, t10._fld5630rref, t10._fld5604rref, t11._date_time, t11._number, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref
  • Inner Unique: true
  • Join Filter: ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001e1'::bytea))
  • Buffers: shared hit=2305 dirtied=1, local hit=343
44. 0.464 14.971 ↓ 171.0 171 1

Nested Loop Left Join (cost=21.95..42.98 rows=1 width=578) (actual time=5.418..14.971 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t8._fld7262rref, t9._date_time, t9._number, t9._fld9106rref, t9._fld9105rref, t10._date_time, t10._number, t10._fld5630rref, t10._fld5604rref
  • Inner Unique: true
  • Join Filter: ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001d8'::bytea))
  • Buffers: shared hit=1963 dirtied=1, local hit=343
45. 0.677 14.165 ↓ 171.0 171 1

Nested Loop Left Join (cost=21.89..42.89 rows=1 width=474) (actual time=5.396..14.165 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t8._fld7262rref, t9._date_time, t9._number, t9._fld9106rref, t9._fld9105rref
  • Inner Unique: true
  • Join Filter: ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000021d'::bytea))
  • Buffers: shared hit=1792 dirtied=1, local hit=343
46. 0.299 11.607 ↓ 171.0 171 1

Nested Loop Left Join (cost=21.78..42.75 rows=1 width=405) (actual time=5.301..11.607 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t8._date_time, t8._number, t8._fld7246rref, t8._fld7233rref, t8._fld7262rref
  • Inner Unique: true
  • Join Filter: ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f2'::bytea))
  • Buffers: shared hit=1277 dirtied=1, local hit=343
47. 0.324 9.598 ↓ 171.0 171 1

Nested Loop Left Join (cost=21.67..42.44 rows=1 width=319) (actual time=5.266..9.598 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t7._date_time, t7._number, t7._fld7449rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref
  • Inner Unique: true
  • Join Filter: ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f4'::bytea))
  • Buffers: shared hit=935 dirtied=1, local hit=343
48. 0.477 7.564 ↓ 171.0 171 1

Nested Loop Left Join (cost=21.55..42.18 rows=1 width=244) (actual time=5.224..7.564 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002, t6._date_time, t6._number, t6._fld7896rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref
  • Inner Unique: true
  • Join Filter: ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001fe'::bytea))
  • Buffers: shared hit=593 dirtied=1, local hit=343
49. 0.266 5.377 ↓ 171.0 171 1

Hash Right Join (cost=21.44..42.01 rows=1 width=168) (actual time=5.152..5.377 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t5._q_001_f_002
  • Hash Cond: ((CASE WHEN (t5._q_001_f_000rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END = t2._fld17999_type) AND (CASE WHEN (t5._q_001_f_000rref IS NOT NULL) THEN '\\x00000069'::bytea ELSE NULL::bytea END = t2._fld17999_rtref) AND (t5._q_001_f_000rref = t2._fld17999_rrref) AND (t5._q_001_f_001rref = t2._fld18000rref))
  • Buffers: shared hit=251 dirtied=1, local hit=343
50. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on pg_temp_23.tt13 t5 (cost=0.00..16.60 rows=660 width=94) (actual time=0.010..0.010 rows=0 loops=1)

  • Output: t5._q_001_f_000rref, t5._q_001_f_001rref, t5._q_001_f_002
51. 0.300 5.101 ↓ 171.0 171 1

Hash (cost=21.43..21.43 rows=1 width=138) (actual time=5.101..5.101 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref
  • Buckets: 1024 Batches: 1 Memory Usage: 38kB
  • Buffers: shared hit=251 dirtied=1, local hit=343
52. 0.226 4.801 ↓ 171.0 171 1

Nested Loop Semi Join (cost=0.27..21.43 rows=1 width=138) (actual time=1.648..4.801 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref
  • Buffers: shared hit=251 dirtied=1, local hit=343
53. 0.095 4.062 ↓ 10.7 171 1

Nested Loop (cost=0.22..20.33 rows=16 width=172) (actual time=1.612..4.062 rows=171 loops=1)

  • Output: t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t2._fld17998rref, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref, t4._q_001_f_000rref
  • Buffers: shared hit=251 dirtied=1, local hit=1
54. 0.017 0.017 ↑ 1.0 2 1

Seq Scan on pg_temp_23.tt23 t4 (cost=0.00..1.02 rows=2 width=99) (actual time=0.016..0.017 rows=2 loops=1)

  • Output: t4._q_001_f_000rref, t4._q_001_f_001rref, t4._q_001_f_002rref, t4._q_001_f_003_type, t4._q_001_f_003_rtref, t4._q_001_f_003_rrref, t4._q_001_f_004_type, t4._q_001_f_004_rtref, t4._q_001_f_004_rrref
  • Buffers: local hit=1
55. 3.950 3.950 ↓ 10.8 86 2

Index Scan using _accumrgt18024_1ng on public._accumrgt18024 t2 (cost=0.22..9.58 rows=8 width=73) (actual time=0.832..1.975 rows=86 loops=2)

  • Output: t2._period, t2._fld17998rref, t2._fld17999_type, t2._fld17999_rtref, t2._fld17999_rrref, t2._fld18000rref, t2._fld18001, t2._fld18002, t2._fld18003, t2._fld18004, t2._fld1177
  • Index Cond: ((t2._fld1177 = '0'::numeric) AND (t2._period = '3999-11-01 00:00:00'::timestamp without time zone) AND (t2._fld17998rref = t4._q_001_f_000rref))
  • Filter: (((t2._fld18002 <> '0'::numeric) OR (t2._fld18003 <> '0'::numeric) OR (t2._fld18001 <> '0'::numeric)) AND ((t2._fld18002 <> '0'::numeric) OR (t2._fld18003 <> '0'::numeric) OR (t2._fld18001 <> '0'::numeric)) AND (((t2._fld18002 - t2._fld18003) > '0'::numeric) OR ((t2._fld18002 - t2._fld18001) > '0'::numeric)))
  • Rows Removed by Filter: 33
  • Buffers: shared hit=251 dirtied=1
56. 0.513 0.513 ↑ 1.0 1 171

Index Only Scan using tmpind_0 on pg_temp_23.tt23 t3 (cost=0.05..0.07 rows=1 width=17) (actual time=0.003..0.003 rows=1 loops=171)

  • Output: t3._q_001_f_000rref
  • Index Cond: (t3._q_001_f_000rref = t2._fld17998rref)
  • Heap Fetches: 171
  • Buffers: local hit=342
57. 1.710 1.710 ↓ 0.0 0 171

Index Scan using _document510_s_hpkng on public._document510 t6 (cost=0.11..0.15 rows=1 width=93) (actual time=0.010..0.010 rows=0 loops=171)

  • Output: t6._idrref, t6._version, t6._marked, t6._date_time, t6._numberprefix, t6._number, t6._posted, t6._fld7876rref, t6._fld7877rref, t6._fld7878rref, t6._fld7879, t6._fld7880rref, t6._fld7881, t6._fld7882, t6._fld7883, t6._fld7884, t6._fld7885_type, t6._fld7885_rtref, t6._fld7885_rrref, t6._fld7886rref, t6._fld7887rref, t6._fld7888rref, t6._fld7889rref, t6._fld7890rref, t6._fld7891rref, t6._fld7892rref, t6._fld7893rref, t6._fld7894, t6._fld7895, t6._fld7896rref, t6._fld7897_type, t6._fld7897_rtref, t6._fld7897_rrref, t6._fld7898rref, t6._fld7899, t6._fld7900, t6._fld7901, t6._fld7902rref, t6._fld7903rref, t6._fld7904rref, t6._fld7905, t6._fld7906, t6._fld7907, t6._fld7908, t6._fld7909, t6._fld7910rref, t6._fld7911rref, t6._fld7912_type, t6._fld7912_rtref, t6._fld7912_rrref, t6._fld7913, t6._fld7914rref, t6._fld7915, t6._fld7916rref, t6._fld7917, t6._fld1177
  • Index Cond: ((t6._fld1177 = '0'::numeric) AND (t2._fld17999_rrref = t6._idrref))
  • Buffers: shared hit=342
58. 1.710 1.710 ↓ 0.0 0 171

Index Scan using _document500_s_hpkng on public._document500 t7 (cost=0.11..0.25 rows=1 width=92) (actual time=0.010..0.010 rows=0 loops=171)

  • Output: t7._idrref, t7._version, t7._marked, t7._date_time, t7._numberprefix, t7._number, t7._posted, t7._fld7437rref, t7._fld7438rref, t7._fld7439, t7._fld7440rref, t7._fld7441, t7._fld7442, t7._fld7443, t7._fld7444rref, t7._fld7445rref, t7._fld7446rref, t7._fld7447rref, t7._fld7448rref, t7._fld7449rref, t7._fld7450rref, t7._fld7451, t7._fld7452_type, t7._fld7452_rtref, t7._fld7452_rrref, t7._fld7453rref, t7._fld7454_type, t7._fld7454_rtref, t7._fld7454_rrref, t7._fld7455, t7._fld7456rref, t7._fld7457, t7._fld7458rref, t7._fld7459rref, t7._fld7460, t7._fld7461rref, t7._fld7462rref, t7._fld7463rref, t7._fld7464_type, t7._fld7464_rtref, t7._fld7464_rrref, t7._fld7465, t7._fld7466rref, t7._fld7467, t7._fld7468rref, t7._fld7469, t7._fld1177
  • Index Cond: ((t7._fld1177 = '0'::numeric) AND (t2._fld17999_rrref = t7._idrref))
  • Buffers: shared hit=342
59. 1.710 1.710 ↓ 0.0 0 171

Index Scan using _document498_s_hpkng on public._document498 t8 (cost=0.11..0.29 rows=1 width=103) (actual time=0.010..0.010 rows=0 loops=171)

  • Output: t8._idrref, t8._version, t8._marked, t8._date_time, t8._numberprefix, t8._number, t8._posted, t8._fld7201rref, t8._fld7202rref, t8._fld7203rref, t8._fld7204rref, t8._fld7205rref, t8._fld7206rref, t8._fld7207, t8._fld7208, t8._fld7209rref, t8._fld7210rref, t8._fld7211rref, t8._fld7212, t8._fld7213rref, t8._fld7214, t8._fld7215, t8._fld7216rref, t8._fld7217rref, t8._fld7218, t8._fld7219rref, t8._fld7220, t8._fld7221rref, t8._fld7222, t8._fld7223, t8._fld7224rref, t8._fld7225rref, t8._fld7226rref, t8._fld7227rref, t8._fld7228rref, t8._fld7229, t8._fld7230, t8._fld7231rref, t8._fld7232, t8._fld7233rref, t8._fld7234rref, t8._fld7235rref, t8._fld7236rref, t8._fld7237, t8._fld7238, t8._fld7239rref, t8._fld7240, t8._fld7241_type, t8._fld7241_rtref, t8._fld7241_rrref, t8._fld7242, t8._fld7243, t8._fld7244, t8._fld7245rref, t8._fld7246rref, t8._fld7247rref, t8._fld7248rref, t8._fld7249rref, t8._fld7250, t8._fld7251, t8._fld7252, t8._fld7253, t8._fld7254, t8._fld7255, t8._fld7256, t8._fld7257, t8._fld7258, t8._fld7259rref, t8._fld7260rref, t8._fld7261, t8._fld7262rref, t8._fld7263rref, t8._fld7264, t8._fld7265, t8._fld7266rref, t8._fld7267, t8._fld7268, t8._fld7269rref, t8._fld7270rref, t8._fld7271rref, t8._fld7272, t8._fld28002rref, t8._fld28003, t8._fld1177
  • Index Cond: ((t8._fld1177 = '0'::numeric) AND (t2._fld17999_rrref = t8._idrref))
  • Buffers: shared hit=342
60. 1.881 1.881 ↑ 1.0 1 171

Index Scan using _document541_s_hpkng on public._document541 t9 (cost=0.11..0.13 rows=1 width=86) (actual time=0.011..0.011 rows=1 loops=171)

  • Output: t9._idrref, t9._version, t9._marked, t9._date_time, t9._numberprefix, t9._number, t9._posted, t9._fld9099rref, t9._fld9100rref, t9._fld9101rref, t9._fld9102rref, t9._fld9103rref, t9._fld9104rref, t9._fld9105rref, t9._fld9106rref, t9._fld9107rref, t9._fld9108rref, t9._fld9109rref, t9._fld9110rref, t9._fld9111rref, t9._fld9112, t9._fld9113, t9._fld9114, t9._fld9115rref, t9._fld9116_type, t9._fld9116_rtref, t9._fld9116_rrref, t9._fld9117, t9._fld9118rref, t9._fld9119_type, t9._fld9119_rtref, t9._fld9119_rrref, t9._fld9120, t9._fld9121rref, t9._fld9122rref, t9._fld9123rref, t9._fld9124, t9._fld9125rref, t9._fld9126, t9._fld9127, t9._fld9128rref, t9._fld9129rref, t9._fld9130rref, t9._fld9131rref, t9._fld26879rref, t9._fld29644, t9._fld1177
  • Index Cond: ((t9._fld1177 = '0'::numeric) AND (t2._fld17999_rrref = t9._idrref))
  • Buffers: shared hit=515
61. 0.342 0.342 ↓ 0.0 0 171

Index Scan using _document472_s_hpkng on public._document472 t10 (cost=0.06..0.08 rows=1 width=136) (actual time=0.002..0.002 rows=0 loops=171)

  • Output: t10._idrref, t10._version, t10._marked, t10._date_time, t10._numberprefix, t10._number, t10._posted, t10._fld5601rref, t10._fld5602rref, t10._fld5603rref, t10._fld5604rref, t10._fld5605rref, t10._fld5606rref, t10._fld5607, t10._fld5608rref, t10._fld5609rref, t10._fld5610rref, t10._fld5611, t10._fld5612rref, t10._fld5613, t10._fld5614, t10._fld5615rref, t10._fld5616, t10._fld5617, t10._fld5618rref, t10._fld5619, t10._fld5620rref, t10._fld5621rref, t10._fld5622rref, t10._fld5623, t10._fld5624, t10._fld5625, t10._fld5626, t10._fld5627, t10._fld5628, t10._fld5629rref, t10._fld5630rref, t10._fld5631rref, t10._fld5632rref, t10._fld5633rref, t10._fld5634, t10._fld5635rref, t10._fld5636rref, t10._fld5637, t10._fld5638rref, t10._fld5639rref, t10._fld5640rref, t10._fld1177
  • Index Cond: ((t10._fld1177 = '0'::numeric) AND (t2._fld17999_rrref = t10._idrref))
  • Buffers: shared hit=171
62. 1.026 1.026 ↓ 0.0 0 171

Index Scan using _document481_s_hpkng on public._document481 t11 (cost=0.11..0.15 rows=1 width=75) (actual time=0.006..0.006 rows=0 loops=171)

  • Output: t11._idrref, t11._version, t11._marked, t11._date_time, t11._numberprefix, t11._number, t11._posted, t11._fld6228rref, t11._fld6229_type, t11._fld6229_rtref, t11._fld6229_rrref, t11._fld6230_type, t11._fld6230_rtref, t11._fld6230_rrref, t11._fld6231rref, t11._fld6232, t11._fld6233, t11._fld6234, t11._fld6235, t11._fld6236rref, t11._fld6237rref, t11._fld6238, t11._fld6239rref, t11._fld6240rref, t11._fld6241rref, t11._fld6242rref, t11._fld1177
  • Index Cond: ((t11._fld1177 = '0'::numeric) AND (t2._fld17999_rrref = t11._idrref))
  • Buffers: shared hit=342
63. 1.710 1.710 ↓ 0.0 0 171

Index Scan using _document420_s_hpkng on public._document420 t12 (cost=0.11..0.27 rows=1 width=85) (actual time=0.010..0.010 rows=0 loops=171)

  • Output: t12._idrref, t12._version, t12._marked, t12._date_time, t12._numberprefix, t12._number, t12._posted, t12._fld3462rref, t12._fld3463rref, t12._fld3464rref, t12._fld3465rref, t12._fld3466rref, t12._fld3467rref, t12._fld3468rref, t12._fld3469, t12._fld3470rref, t12._fld3471, t12._fld3472, t12._fld3473, t12._fld3474, t12._fld3475, t12._fld3476rref, t12._fld3477rref, t12._fld3478rref, t12._fld3479, t12._fld3480, t12._fld3481, t12._fld3482, t12._fld3483rref, t12._fld3484rref, t12._fld3485, t12._fld3486, t12._fld3487, t12._fld3488rref, t12._fld3489rref, t12._fld3490rref, t12._fld3491, t12._fld3492rref, t12._fld3493rref, t12._fld3494_type, t12._fld3494_rtref, t12._fld3494_rrref, t12._fld3495, t12._fld3496, t12._fld3497rref, t12._fld3498, t12._fld3499rref, t12._fld3500, t12._fld3501, t12._fld3502rref, t12._fld3503rref, t12._fld3504, t12._fld3505, t12._fld3506rref, t12._fld3507rref, t12._fld3508rref, t12._fld3509rref, t12._fld3510, t12._fld3511, t12._fld3512, t12._fld3513, t12._fld3514, t12._fld3515, t12._fld3516, t12._fld3517, t12._fld3518, t12._fld3519rref, t12._fld3520rref, t12._fld3521, t12._fld3522rref, t12._fld3523rref, t12._fld3524, t12._fld26878rref, t12._fld26904, t12._fld26905rref, t12._fld1177
  • Index Cond: ((t12._fld1177 = '0'::numeric) AND (t2._fld17999_rrref = t12._idrref))
  • Buffers: shared hit=343
64. 0.684 0.684 ↓ 0.0 0 171

Index Scan using _document405_s_hpkng on public._document405 t13 (cost=0.06..0.07 rows=1 width=86) (actual time=0.004..0.004 rows=0 loops=171)

  • Output: t13._idrref, t13._version, t13._marked, t13._date_time, t13._numberprefix, t13._number, t13._posted, t13._fld2512rref, t13._fld2513rref, t13._fld2514rref, t13._fld2515rref, t13._fld2516rref, t13._fld2517rref, t13._fld2518rref, t13._fld2519rref, t13._fld2520, t13._fld2521, t13._fld2522rref, t13._fld2523, t13._fld2524rref, t13._fld2525rref, t13._fld2526rref, t13._fld2527rref, t13._fld2528rref, t13._fld2529rref, t13._fld2530rref, t13._fld2531rref, t13._fld2532rref, t13._fld2533rref, t13._fld2534, t13._fld2535rref, t13._fld2536rref, t13._fld2537rref, t13._fld2538rref, t13._fld2539rref, t13._fld2540, t13._fld2541, t13._fld2542rref, t13._fld2543, t13._fld2544, t13._fld2545rref, t13._fld2546, t13._fld2547, t13._fld2548, t13._fld2549, t13._fld2550, t13._fld2551, t13._fld2552, t13._fld2553, t13._fld2554, t13._fld2555rref, t13._fld2556, t13._fld2557, t13._fld2558rref, t13._fld2559, t13._fld2560, t13._fld2561rref, t13._fld2562, t13._fld2563rref, t13._fld2564, t13._fld2565, t13._fld2566rref, t13._fld2567rref, t13._fld2568, t13._fld2569, t13._fld1177
  • Index Cond: ((t13._fld1177 = '0'::numeric) AND (t2._fld17999_rrref = t13._idrref))
  • Buffers: shared hit=171
65. 9.405 9.405 ↓ 0.0 0 171

Index Scan using _document525_s_hpkng on public._document525 t14 (cost=0.11..0.46 rows=1 width=92) (actual time=0.055..0.055 rows=0 loops=171)

  • Output: t14._idrref, t14._version, t14._marked, t14._date_time, t14._numberprefix, t14._number, t14._posted, t14._fld8524, t14._fld8525rref, t14._fld8526, t14._fld8527rref, t14._fld8528, t14._fld8529rref, t14._fld8530, t14._fld8531rref, t14._fld8532rref, t14._fld8533rref, t14._fld8534rref, t14._fld8535rref, t14._fld8536, t14._fld8537rref, t14._fld8538rref, t14._fld8539rref, t14._fld8540, t14._fld8541rref, t14._fld8542, t14._fld8543, t14._fld8544, t14._fld8545, t14._fld8546, t14._fld8547, t14._fld8548, t14._fld8549, t14._fld8550, t14._fld8551, t14._fld8552, t14._fld8553rref, t14._fld8554rref, t14._fld8555rref, t14._fld8556, t14._fld8557, t14._fld8558rref, t14._fld8559, t14._fld8560, t14._fld8561, t14._fld8562, t14._fld8563, t14._fld8564_type, t14._fld8564_rtref, t14._fld8564_rrref, t14._fld8565, t14._fld8566, t14._fld8567rref, t14._fld8568, t14._fld8569, t14._fld8570, t14._fld8571, t14._fld8572, t14._fld8573, t14._fld8574, t14._fld8575, t14._fld8576, t14._fld8577, t14._fld8578, t14._fld8579, t14._fld8580, t14._fld8581, t14._fld8582_type, t14._fld8582_rtref, t14._fld8582_rrref, t14._fld8583, t14._fld8584rref, t14._fld8585, t14._fld8586rref, t14._fld8587rref, t14._fld8588_type, t14._fld8588_rtref, t14._fld8588_rrref, t14._fld8589, t14._fld8590, t14._fld8591, t14._fld8592rref, t14._fld8593rref, t14._fld8594rref, t14._fld8595, t14._fld8596, t14._fld8597, t14._fld8598, t14._fld8599rref, t14._fld8600rref, t14._fld8601rref, t14._fld8602, t14._fld1177
  • Index Cond: ((t14._fld1177 = '0'::numeric) AND (t2._fld17999_rrref = t14._idrref))
  • Buffers: shared hit=342
66. 0.513 0.513 ↓ 0.0 0 171

Index Scan using _reference109_s_hpkng on public._reference109 t15 (cost=0.05..0.07 rows=1 width=56) (actual time=0.003..0.003 rows=0 loops=171)

  • Output: t15._idrref, t15._version, t15._marked, t15._predefinedid, t15._description, t15._fld20584rref, t15._fld20585rref, t15._fld20586rref, t15._fld20587, t15._fld20588, t15._fld20589, t15._fld20590rref, t15._fld20591rref, t15._fld20592, t15._fld20593, t15._fld20594, t15._fld20595rref, t15._fld20596rref, t15._fld20597rref, t15._fld20598rref, t15._fld20599, t15._fld20600rref, t15._fld20601rref, t15._fld20602rref, t15._fld20603rref, t15._fld20604, t15._fld20605rref, t15._fld20606rref, t15._fld20607, t15._fld20608, t15._fld20609rref, t15._fld20610, t15._fld20611, t15._fld20612, t15._fld20613, t15._fld20614, t15._fld20615, t15._fld20616, t15._fld20617, t15._fld20618, t15._fld20619, t15._fld20620rref, t15._fld20621, t15._fld20622, t15._fld20623rref, t15._fld20624rref, t15._fld20625, t15._fld20626, t15._fld20627, t15._fld1177
  • Index Cond: ((t15._fld1177 = '0'::numeric) AND (t2._fld17999_rrref = t15._idrref))
  • Buffers: shared hit=171
67. 1.197 1.197 ↓ 0.0 0 171

Index Scan using _reference105_s_hpkng on public._reference105 t16 (cost=0.11..0.15 rows=1 width=56) (actual time=0.007..0.007 rows=0 loops=171)

  • Output: t16._idrref, t16._version, t16._marked, t16._predefinedid, t16._description, t16._fld20354rref, t16._fld20355rref, t16._fld20356rref, t16._fld20357, t16._fld20358, t16._fld20359, t16._fld20360rref, t16._fld20361rref, t16._fld20362rref, t16._fld20363, t16._fld20364, t16._fld20365rref, t16._fld20366, t16._fld20367, t16._fld20368rref, t16._fld20369rref, t16._fld20370rref, t16._fld20371rref, t16._fld20372, t16._fld20373rref, t16._fld20374rref, t16._fld20375rref, t16._fld20376, t16._fld20377, t16._fld20378rref, t16._fld20379, t16._fld20380rref, t16._fld20381rref, t16._fld20382, t16._fld20383, t16._fld20384, t16._fld20385, t16._fld20386, t16._fld20387, t16._fld20388, t16._fld20389, t16._fld20390, t16._fld20391, t16._fld20392rref, t16._fld20393, t16._fld20394, t16._fld20395rref, t16._fld20396rref, t16._fld20397rref, t16._fld20398, t16._fld20399, t16._fld20400rref, t16._fld20401rref, t16._fld20402, t16._fld28126, t16._fld20403, t16._fld20404, t16._fld20405, t16._fld20406rref, t16._fld20407, t16._fld20408rref, t16._fld20409, t16._fld20410rref, t16._fld20411rref, t16._fld20412rref, t16._fld20413, t16._fld20414, t16._fld20415, t16._fld20416, t16._fld20417, t16._fld20418, t16._fld20419, t16._fld20420, t16._fld1177
  • Index Cond: ((t16._fld1177 = '0'::numeric) AND (t2._fld17999_rrref = t16._idrref))
  • Buffers: shared hit=343
68. 0.513 0.513 ↓ 0.0 0 171

Index Scan using _document477_s_hpkng on public._document477 t17 (cost=0.05..0.07 rows=1 width=69) (actual time=0.003..0.003 rows=0 loops=171)

  • Output: t17._idrref, t17._version, t17._marked, t17._date_time, t17._numberprefix, t17._number, t17._posted, t17._fld6016rref, t17._fld6017rref, t17._fld6018rref, t17._fld6019, t17._fld6020rref, t17._fld6021rref, t17._fld6022rref, t17._fld6023, t17._fld6024rref, t17._fld6025, t17._fld6026, t17._fld6027rref, t17._fld6028, t17._fld6029, t17._fld6030rref, t17._fld6031, t17._fld6032rref, t17._fld6033rref, t17._fld6034, t17._fld6035, t17._fld6036, t17._fld6037, t17._fld6038rref, t17._fld6039rref, t17._fld6040, t17._fld6041, t17._fld6042rref, t17._fld6043rref, t17._fld6044rref, t17._fld6045rref, t17._fld6046, t17._fld6047rref, t17._fld6048, t17._fld6049rref, t17._fld6050rref, t17._fld6051rref, t17._fld6052rref, t17._fld6053rref, t17._fld1177
  • Index Cond: ((t17._fld1177 = '0'::numeric) AND (t2._fld17999_rrref = t17._idrref))
  • Buffers: shared hit=171
69. 0.342 0.342 ↓ 0.0 0 171

Index Scan using _document474_s_hpkng on public._document474 t18 (cost=0.06..0.08 rows=1 width=136) (actual time=0.002..0.002 rows=0 loops=171)

  • Output: t18._idrref, t18._version, t18._marked, t18._date_time, t18._numberprefix, t18._number, t18._posted, t18._fld5770rref, t18._fld5771rref, t18._fld5772rref, t18._fld5773rref, t18._fld5774rref, t18._fld5775, t18._fld5776rref, t18._fld5777rref, t18._fld5778rref, t18._fld5779, t18._fld5780rref, t18._fld5781, t18._fld5782, t18._fld5783rref, t18._fld5784, t18._fld5785, t18._fld5786rref, t18._fld5787rref, t18._fld5788rref, t18._fld5789rref, t18._fld5790, t18._fld5791, t18._fld5792, t18._fld5793, t18._fld5794rref, t18._fld5795rref, t18._fld5796rref, t18._fld5797rref, t18._fld5798rref, t18._fld5799rref, t18._fld5800, t18._fld5801, t18._fld5802rref, t18._fld5803rref, t18._fld1177
  • Index Cond: ((t18._fld1177 = '0'::numeric) AND (t2._fld17999_rrref = t18._idrref))
  • Buffers: shared hit=171
70. 0.171 0.171 ↓ 0.0 0 171

Index Scan using _document478_s_hpkng on public._document478 t19 (cost=0.06..0.07 rows=1 width=104) (actual time=0.001..0.001 rows=0 loops=171)

  • Output: t19._idrref, t19._version, t19._marked, t19._date_time, t19._numberprefix, t19._number, t19._posted, t19._fld6116rref, t19._fld6117rref, t19._fld6118rref, t19._fld6119, t19._fld6120rref, t19._fld6121rref, t19._fld6122rref, t19._fld6123, t19._fld6124, t19._fld6125rref, t19._fld6126rref, t19._fld6127, t19._fld6128, t19._fld6129, t19._fld6130, t19._fld6131rref, t19._fld6132rref, t19._fld6133, t19._fld6134, t19._fld6135rref, t19._fld6136rref, t19._fld6137rref, t19._fld6138rref, t19._fld6139, t19._fld6140rref, t19._fld6141, t19._fld6142rref, t19._fld6143_type, t19._fld6143_rtref, t19._fld6143_rrref, t19._fld6144rref, t19._fld6145_type, t19._fld6145_rtref, t19._fld6145_rrref, t19._fld6146rref, t19._fld6147rref, t19._fld6148rref, t19._fld6149rref, t19._fld6150rref, t19._fld1177
  • Index Cond: ((t19._fld1177 = '0'::numeric) AND (t2._fld17999_rrref = t19._idrref))
  • Buffers: shared hit=171
71. 0.171 0.171 ↓ 0.0 0 171

Index Scan using _document475_s_hpkng on public._document475 t20 (cost=0.06..0.08 rows=1 width=136) (actual time=0.001..0.001 rows=0 loops=171)

  • Output: t20._idrref, t20._version, t20._marked, t20._date_time, t20._numberprefix, t20._number, t20._posted, t20._fld5861rref, t20._fld5862rref, t20._fld5863rref, t20._fld5864rref, t20._fld5865rref, t20._fld5866, t20._fld5867rref, t20._fld5868rref, t20._fld5869, t20._fld5870rref, t20._fld5871, t20._fld5872, t20._fld5873, t20._fld5874rref, t20._fld5875, t20._fld5876rref, t20._fld5877rref, t20._fld5878rref, t20._fld5879rref, t20._fld5880, t20._fld5881rref, t20._fld5882rref, t20._fld1177
  • Index Cond: ((t20._fld1177 = '0'::numeric) AND (t2._fld17999_rrref = t20._idrref))
  • Buffers: shared hit=171
72. 1.368 1.368 ↓ 0.0 0 171

Index Scan using _document499_s_hpkng on public._document499 t21 (cost=0.11..0.15 rows=1 width=99) (actual time=0.008..0.008 rows=0 loops=171)

  • Output: t21._idrref, t21._version, t21._marked, t21._date_time, t21._numberprefix, t21._number, t21._posted, t21._fld7366rref, t21._fld7367rref, t21._fld7368rref, t21._fld7369rref, t21._fld7370rref, t21._fld7371rref, t21._fld7372, t21._fld7373rref, t21._fld7374, t21._fld7375rref, t21._fld7376, t21._fld7377, t21._fld7378rref, t21._fld7379rref, t21._fld7380, t21._fld7381, t21._fld7382rref, t21._fld7383, t21._fld7384rref, t21._fld7385rref, t21._fld7386rref, t21._fld7387rref, t21._fld7388rref, t21._fld7389rref, t21._fld7390rref, t21._fld7391, t21._fld7392, t21._fld7393, t21._fld7394rref, t21._fld7395rref, t21._fld7396rref, t21._fld7397rref, t21._fld7398, t21._fld7399, t21._fld7400rref, t21._fld7401rref, t21._fld1177
  • Index Cond: ((t21._fld1177 = '0'::numeric) AND (t2._fld17999_rrref = t21._idrref))
  • Buffers: shared hit=344
73. 0.342 0.342 ↓ 0.0 0 171

Index Scan using _document403_s_hpkng on public._document403 t22 (cost=0.06..0.07 rows=1 width=104) (actual time=0.002..0.002 rows=0 loops=171)

  • Output: t22._idrref, t22._version, t22._marked, t22._date_time, t22._numberprefix, t22._number, t22._posted, t22._fld2274rref, t22._fld2275rref, t22._fld2276rref, t22._fld2277rref, t22._fld2278, t22._fld2279rref, t22._fld2280, t22._fld2281rref, t22._fld2282rref, t22._fld2283rref, t22._fld2284rref, t22._fld2285rref, t22._fld2286rref, t22._fld2287rref, t22._fld2288rref, t22._fld2289, t22._fld2290, t22._fld2291, t22._fld2292, t22._fld2293, t22._fld2294rref, t22._fld2295rref, t22._fld2296, t22._fld2297, t22._fld2298rref, t22._fld2299rref, t22._fld2300rref, t22._fld2301, t22._fld2302, t22._fld2303rref, t22._fld2304, t22._fld2305, t22._fld2306rref, t22._fld2307rref, t22._fld2308rref, t22._fld2309rref, t22._fld2310rref, t22._fld2311, t22._fld2312, t22._fld2313, t22._fld2314, t22._fld2315rref, t22._fld2316rref, t22._fld2317rref, t22._fld2318, t22._fld2319rref, t22._fld28948, t22._fld1177
  • Index Cond: ((t22._fld1177 = '0'::numeric) AND (t2._fld17999_rrref = t22._idrref))
  • Buffers: shared hit=171
74. 1.197 1.197 ↓ 0.0 0 171

Index Scan using _document483_s_hpkng on public._document483 t23 (cost=0.11..0.19 rows=1 width=69) (actual time=0.007..0.007 rows=0 loops=171)

  • Output: t23._idrref, t23._version, t23._marked, t23._date_time, t23._numberprefix, t23._number, t23._posted, t23._fld6265rref, t23._fld6266, t23._fld6267rref, t23._fld6268rref, t23._fld6269rref, t23._fld6270, t23._fld6271rref, t23._fld6272rref, t23._fld6273rref, t23._fld6274, t23._fld6275, t23._fld6276, t23._fld6277, t23._fld6278, t23._fld6279rref, t23._fld6280rref, t23._fld6281, t23._fld6282rref, t23._fld6283rref, t23._fld6284rref, t23._fld6285rref, t23._fld6286rref, t23._fld6287rref, t23._fld6288rref, t23._fld6289, t23._fld6290, t23._fld6291, t23._fld6292rref, t23._fld6293, t23._fld6294rref, t23._fld6295, t23._fld6296rref, t23._fld6297, t23._fld6298, t23._fld6299, t23._fld6300rref, t23._fld6301rref, t23._fld6302, t23._fld6303rref, t23._fld6304rref, t23._fld6305rref, t23._fld6306rref, t23._fld6307, t23._fld6308rref, t23._fld6309, t23._fld6310, t23._fld6311, t23._fld6312rref, t23._fld6313, t23._fld6314rref, t23._fld6315rref, t23._fld6316, t23._fld6317rref, t23._fld6318rref, t23._fld6319, t23._fld6320, t23._fld6321rref, t23._fld6322, t23._fld6323rref, t23._fld1177
  • Index Cond: ((t23._fld1177 = '0'::numeric) AND (t2._fld17999_rrref = t23._idrref))
  • Buffers: shared hit=342
75. 0.342 0.342 ↓ 0.0 0 171

Index Scan using _document410_s_hpkng on public._document410 t24 (cost=0.06..0.08 rows=1 width=136) (actual time=0.002..0.002 rows=0 loops=171)

  • Output: t24._idrref, t24._version, t24._marked, t24._date_time, t24._numberprefix, t24._number, t24._posted, t24._fld2873rref, t24._fld2874rref, t24._fld2875rref, t24._fld2876rref, t24._fld2877rref, t24._fld2878, t24._fld2879rref, t24._fld2880, t24._fld2881, t24._fld2882rref, t24._fld2883, t24._fld2884, t24._fld2885rref, t24._fld2886, t24._fld2887rref, t24._fld2888, t24._fld2889, t24._fld2890rref, t24._fld2891rref, t24._fld2892rref, t24._fld2893rref, t24._fld2894rref, t24._fld2895, t24._fld2896, t24._fld2897rref, t24._fld1177
  • Index Cond: ((t24._fld1177 = '0'::numeric) AND (t2._fld17999_rrref = t24._idrref))
  • Buffers: shared hit=171
76. 2.565 2.565 ↓ 0.0 0 171

Index Scan using _document496_s_hpkng on public._document496 t25 (cost=0.17..1.15 rows=1 width=93) (actual time=0.015..0.015 rows=0 loops=171)

  • Output: t25._idrref, t25._version, t25._marked, t25._date_time, t25._numberprefix, t25._number, t25._posted, t25._fld7047rref, t25._fld7048rref, t25._fld7049rref, t25._fld7050rref, t25._fld7051, t25._fld7052rref, t25._fld7053rref, t25._fld7054rref, t25._fld7055rref, t25._fld7056, t25._fld7057, t25._fld7058, t25._fld7059rref, t25._fld7060, t25._fld7061rref, t25._fld7062_type, t25._fld7062_rtref, t25._fld7062_rrref, t25._fld7063rref, t25._fld7064, t25._fld7065rref, t25._fld7066rref, t25._fld7067rref, t25._fld7068_type, t25._fld7068_rtref, t25._fld7068_rrref, t25._fld7069, t25._fld7070, t25._fld7071_type, t25._fld7071_rtref, t25._fld7071_rrref, t25._fld7072, t25._fld7073, t25._fld7074, t25._fld7075, t25._fld7076, t25._fld7077, t25._fld7078, t25._fld7079, t25._fld7080, t25._fld7081, t25._fld7082rref, t25._fld7083rref, t25._fld7084_type, t25._fld7084_rtref, t25._fld7084_rrref, t25._fld7085rref, t25._fld7086rref, t25._fld7087rref, t25._fld7088, t25._fld7089, t25._fld1177
  • Index Cond: ((t25._fld1177 = '0'::numeric) AND (t2._fld17999_rrref = t25._idrref))
  • Buffers: shared hit=513
77. 2.223 2.223 ↑ 1.0 10 171

Seq Scan on public._reference109 t26 (cost=0.00..1.11 rows=10 width=18) (actual time=0.005..0.013 rows=10 loops=171)

  • Output: t26._idrref, t26._version, t26._marked, t26._predefinedid, t26._description, t26._fld20584rref, t26._fld20585rref, t26._fld20586rref, t26._fld20587, t26._fld20588, t26._fld20589, t26._fld20590rref, t26._fld20591rref, t26._fld20592, t26._fld20593, t26._fld20594, t26._fld20595rref, t26._fld20596rref, t26._fld20597rref, t26._fld20598rref, t26._fld20599, t26._fld20600rref, t26._fld20601rref, t26._fld20602rref, t26._fld20603rref, t26._fld20604, t26._fld20605rref, t26._fld20606rref, t26._fld20607, t26._fld20608, t26._fld20609rref, t26._fld20610, t26._fld20611, t26._fld20612, t26._fld20613, t26._fld20614, t26._fld20615, t26._fld20616, t26._fld20617, t26._fld20618, t26._fld20619, t26._fld20620rref, t26._fld20621, t26._fld20622, t26._fld20623rref, t26._fld20624rref, t26._fld20625, t26._fld20626, t26._fld20627, t26._fld1177
  • Filter: (t26._fld1177 = '0'::numeric)
  • Buffers: shared hit=171
78. 1.026 1.026 ↓ 0.0 0 171

Index Scan using _reference105_s_hpkng on public._reference105 t27 (cost=0.11..2.33 rows=1 width=18) (actual time=0.006..0.006 rows=0 loops=171)

  • Output: t27._idrref, t27._version, t27._marked, t27._predefinedid, t27._description, t27._fld20354rref, t27._fld20355rref, t27._fld20356rref, t27._fld20357, t27._fld20358, t27._fld20359, t27._fld20360rref, t27._fld20361rref, t27._fld20362rref, t27._fld20363, t27._fld20364, t27._fld20365rref, t27._fld20366, t27._fld20367, t27._fld20368rref, t27._fld20369rref, t27._fld20370rref, t27._fld20371rref, t27._fld20372, t27._fld20373rref, t27._fld20374rref, t27._fld20375rref, t27._fld20376, t27._fld20377, t27._fld20378rref, t27._fld20379, t27._fld20380rref, t27._fld20381rref, t27._fld20382, t27._fld20383, t27._fld20384, t27._fld20385, t27._fld20386, t27._fld20387, t27._fld20388, t27._fld20389, t27._fld20390, t27._fld20391, t27._fld20392rref, t27._fld20393, t27._fld20394, t27._fld20395rref, t27._fld20396rref, t27._fld20397rref, t27._fld20398, t27._fld20399, t27._fld20400rref, t27._fld20401rref, t27._fld20402, t27._fld28126, t27._fld20403, t27._fld20404, t27._fld20405, t27._fld20406rref, t27._fld20407, t27._fld20408rref, t27._fld20409, t27._fld20410rref, t27._fld20411rref, t27._fld20412rref, t27._fld20413, t27._fld20414, t27._fld20415, t27._fld20416, t27._fld20417, t27._fld20418, t27._fld20419, t27._fld20420, t27._fld1177
  • Index Cond: ((t27._fld1177 = '0'::numeric) AND (t4._q_001_f_004_rrref = t27._idrref))
  • Buffers: shared hit=342
79. 0.855 0.855 ↓ 0.0 0 171

Index Scan using _reference303_s_hpkng on public._reference303 t28 (cost=0.13..2.34 rows=1 width=34) (actual time=0.005..0.005 rows=0 loops=171)

  • Output: t28._idrref, t28._version, t28._marked, t28._predefinedid, t28._description, t28._fld24811, t28._fld24812, t28._fld24813rref, t28._fld24814rref, t28._fld24815rref, t28._fld24816rref, t28._fld24817, t28._fld24818, t28._fld24819rref, t28._fld24820, t28._fld24821, t28._fld24822, t28._fld24823rref, t28._fld24824, t28._fld24825rref, t28._fld24826rref, t28._fld24827rref, t28._fld24828, t28._fld24829, t28._fld24830rref, t28._fld24831, t28._fld24832, t28._fld24833, t28._fld24834rref, t28._fld24835rref, t28._fld24836rref, t28._fld24837rref, t28._fld24838, t28._fld24839, t28._fld24840rref, t28._fld24841, t28._fld24842, t28._fld24843, t28._fld24844rref, t28._fld24845, t28._fld24846rref, t28._fld24847rref, t28._fld24848, t28._fld24849rref, t28._fld24850, t28._fld24851, t28._fld24852, t28._fld24853rref, t28._fld24854rref, t28._fld24855rref, t28._fld24856rref, t28._fld24857rref, t28._fld24858, t28._fld24859, t28._fld24860, t28._fld24861, t28._fld24862, t28._fld24863, t28._fld24864, t28._fld24865, t28._fld1177
  • Index Cond: ((t28._fld1177 = '0'::numeric) AND (CASE WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f2'::bytea)) THEN t8._fld7262rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000021d'::bytea)) THEN t9._fld9105rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001d8'::bytea)) THEN t10._fld5604rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001a4'::bytea)) THEN t12._fld3465rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x00000195'::bytea)) THEN t13._fld2515rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001da'::bytea)) THEN t18._fld5773rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001db'::bytea)) THEN t20._fld5864rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f3'::bytea)) THEN t21._fld7367rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000019a'::bytea)) THEN t24._fld2875rref ELSE NULL::bytea END = t28._idrref))
  • Buffers: shared hit=342
80. 0.684 0.684 ↓ 0.0 0 171

Index Scan using _reference105_s_hpkng on public._reference105 t29 (cost=0.15..2.36 rows=1 width=34) (actual time=0.004..0.004 rows=0 loops=171)

  • Output: t29._idrref, t29._version, t29._marked, t29._predefinedid, t29._description, t29._fld20354rref, t29._fld20355rref, t29._fld20356rref, t29._fld20357, t29._fld20358, t29._fld20359, t29._fld20360rref, t29._fld20361rref, t29._fld20362rref, t29._fld20363, t29._fld20364, t29._fld20365rref, t29._fld20366, t29._fld20367, t29._fld20368rref, t29._fld20369rref, t29._fld20370rref, t29._fld20371rref, t29._fld20372, t29._fld20373rref, t29._fld20374rref, t29._fld20375rref, t29._fld20376, t29._fld20377, t29._fld20378rref, t29._fld20379, t29._fld20380rref, t29._fld20381rref, t29._fld20382, t29._fld20383, t29._fld20384, t29._fld20385, t29._fld20386, t29._fld20387, t29._fld20388, t29._fld20389, t29._fld20390, t29._fld20391, t29._fld20392rref, t29._fld20393, t29._fld20394, t29._fld20395rref, t29._fld20396rref, t29._fld20397rref, t29._fld20398, t29._fld20399, t29._fld20400rref, t29._fld20401rref, t29._fld20402, t29._fld28126, t29._fld20403, t29._fld20404, t29._fld20405, t29._fld20406rref, t29._fld20407, t29._fld20408rref, t29._fld20409, t29._fld20410rref, t29._fld20411rref, t29._fld20412rref, t29._fld20413, t29._fld20414, t29._fld20415, t29._fld20416, t29._fld20417, t29._fld20418, t29._fld20419, t29._fld20420, t29._fld1177
  • Index Cond: ((t29._fld1177 = '0'::numeric) AND (CASE WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001fe'::bytea)) THEN t6._fld7912_rrref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f4'::bytea)) THEN t7._fld7464_rrref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f2'::bytea)) THEN t8._fld7233rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000021d'::bytea)) THEN t9._fld9106rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001d8'::bytea)) THEN t10._fld5630rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001e1'::bytea)) THEN t11._fld6230_rrref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001a4'::bytea)) THEN t12._fld3492rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x00000195'::bytea)) THEN t13._fld2533rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000020d'::bytea)) THEN t14._fld8588_rrref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001dd'::bytea)) THEN t17._fld6043rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001da'::bytea)) THEN t18._fld5795rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001de'::bytea)) THEN t19._fld6136rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001db'::bytea)) THEN t20._fld5877rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f3'::bytea)) THEN t21._fld7386rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x00000193'::bytea)) THEN t22._fld2307rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001e3'::bytea)) THEN t23._fld6304rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x0000019a'::bytea)) THEN t24._fld2885rref WHEN ((t2._fld17999_type = '\\x08'::bytea) AND (t2._fld17999_rtref = '\\x000001f0'::bytea)) THEN t25._fld7084_rrref ELSE NULL::bytea END = t29._idrref))
  • Buffers: shared hit=342
81. 0.000 0.000 ↓ 0.0 0 171

Index Scan using _reference109_s_hpkng on public._reference109 t30 (cost=0.05..0.07 rows=1 width=34) (actual time=0.000..0.000 rows=0 loops=171)

  • Output: t30._idrref, t30._version, t30._marked, t30._predefinedid, t30._description, t30._fld20584rref, t30._fld20585rref, t30._fld20586rref, t30._fld20587, t30._fld20588, t30._fld20589, t30._fld20590rref, t30._fld20591rref, t30._fld20592, t30._fld20593, t30._fld20594, t30._fld20595rref, t30._fld20596rref, t30._fld20597rref, t30._fld20598rref, t30._fld20599, t30._fld20600rref, t30._fld20601rref, t30._fld20602rref, t30._fld20603rref, t30._fld20604, t30._fld20605rref, t30._fld20606rref, t30._fld20607, t30._fld20608, t30._fld20609rref, t30._fld20610, t30._fld20611, t30._fld20612, t30._fld20613, t30._fld20614, t30._fld20615, t30._fld20616, t30._fld20617, t30._fld20618, t30._fld20619, t30._fld20620rref, t30._fld20621, t30._fld20622, t30._fld20623rref, t30._fld20624rref, t30._fld20625, t30._fld20626, t30._fld20627, t30._fld1177
  • Index Cond: ((t30._fld1177 = '0'::numeric) AND (t6._fld7912_rrref = t30._idrref))
82. 0.000 0.000 ↓ 0.0 0 171

Index Scan using _reference105_s_hpkng on public._reference105 t31 (cost=0.11..0.22 rows=1 width=34) (actual time=0.000..0.000 rows=0 loops=171)

  • Output: t31._idrref, t31._version, t31._marked, t31._predefinedid, t31._description, t31._fld20354rref, t31._fld20355rref, t31._fld20356rref, t31._fld20357, t31._fld20358, t31._fld20359, t31._fld20360rref, t31._fld20361rref, t31._fld20362rref, t31._fld20363, t31._fld20364, t31._fld20365rref, t31._fld20366, t31._fld20367, t31._fld20368rref, t31._fld20369rref, t31._fld20370rref, t31._fld20371rref, t31._fld20372, t31._fld20373rref, t31._fld20374rref, t31._fld20375rref, t31._fld20376, t31._fld20377, t31._fld20378rref, t31._fld20379, t31._fld20380rref, t31._fld20381rref, t31._fld20382, t31._fld20383, t31._fld20384, t31._fld20385, t31._fld20386, t31._fld20387, t31._fld20388, t31._fld20389, t31._fld20390, t31._fld20391, t31._fld20392rref, t31._fld20393, t31._fld20394, t31._fld20395rref, t31._fld20396rref, t31._fld20397rref, t31._fld20398, t31._fld20399, t31._fld20400rref, t31._fld20401rref, t31._fld20402, t31._fld28126, t31._fld20403, t31._fld20404, t31._fld20405, t31._fld20406rref, t31._fld20407, t31._fld20408rref, t31._fld20409, t31._fld20410rref, t31._fld20411rref, t31._fld20412rref, t31._fld20413, t31._fld20414, t31._fld20415, t31._fld20416, t31._fld20417, t31._fld20418, t31._fld20419, t31._fld20420, t31._fld1177
  • Index Cond: ((t31._fld1177 = '0'::numeric) AND (t6._fld7912_rrref = t31._idrref))
83. 0.000 0.000 ↓ 0.0 0 171

Index Scan using _reference109_s_hpkng on public._reference109 t32 (cost=0.05..0.07 rows=1 width=34) (actual time=0.000..0.000 rows=0 loops=171)

  • Output: t32._idrref, t32._version, t32._marked, t32._predefinedid, t32._description, t32._fld20584rref, t32._fld20585rref, t32._fld20586rref, t32._fld20587, t32._fld20588, t32._fld20589, t32._fld20590rref, t32._fld20591rref, t32._fld20592, t32._fld20593, t32._fld20594, t32._fld20595rref, t32._fld20596rref, t32._fld20597rref, t32._fld20598rref, t32._fld20599, t32._fld20600rref, t32._fld20601rref, t32._fld20602rref, t32._fld20603rref, t32._fld20604, t32._fld20605rref, t32._fld20606rref, t32._fld20607, t32._fld20608, t32._fld20609rref, t32._fld20610, t32._fld20611, t32._fld20612, t32._fld20613, t32._fld20614, t32._fld20615, t32._fld20616, t32._fld20617, t32._fld20618, t32._fld20619, t32._fld20620rref, t32._fld20621, t32._fld20622, t32._fld20623rref, t32._fld20624rref, t32._fld20625, t32._fld20626, t32._fld20627, t32._fld1177
  • Index Cond: ((t32._fld1177 = '0'::numeric) AND (t7._fld7464_rrref = t32._idrref))
84. 0.000 0.000 ↓ 0.0 0 171

Index Scan using _reference105_s_hpkng on public._reference105 t33 (cost=0.11..0.14 rows=1 width=34) (actual time=0.000..0.000 rows=0 loops=171)

  • Output: t33._idrref, t33._version, t33._marked, t33._predefinedid, t33._description, t33._fld20354rref, t33._fld20355rref, t33._fld20356rref, t33._fld20357, t33._fld20358, t33._fld20359, t33._fld20360rref, t33._fld20361rref, t33._fld20362rref, t33._fld20363, t33._fld20364, t33._fld20365rref, t33._fld20366, t33._fld20367, t33._fld20368rref, t33._fld20369rref, t33._fld20370rref, t33._fld20371rref, t33._fld20372, t33._fld20373rref, t33._fld20374rref, t33._fld20375rref, t33._fld20376, t33._fld20377, t33._fld20378rref, t33._fld20379, t33._fld20380rref, t33._fld20381rref, t33._fld20382, t33._fld20383, t33._fld20384, t33._fld20385, t33._fld20386, t33._fld20387, t33._fld20388, t33._fld20389, t33._fld20390, t33._fld20391, t33._fld20392rref, t33._fld20393, t33._fld20394, t33._fld20395rref, t33._fld20396rref, t33._fld20397rref, t33._fld20398, t33._fld20399, t33._fld20400rref, t33._fld20401rref, t33._fld20402, t33._fld28126, t33._fld20403, t33._fld20404, t33._fld20405, t33._fld20406rref, t33._fld20407, t33._fld20408rref, t33._fld20409, t33._fld20410rref, t33._fld20411rref, t33._fld20412rref, t33._fld20413, t33._fld20414, t33._fld20415, t33._fld20416, t33._fld20417, t33._fld20418, t33._fld20419, t33._fld20420, t33._fld1177
  • Index Cond: ((t33._fld1177 = '0'::numeric) AND (t7._fld7464_rrref = t33._idrref))
85. 0.000 0.000 ↓ 0.0 0 171

Index Scan using _reference105_s_hpkng on public._reference105 t34 (cost=0.11..0.15 rows=1 width=34) (actual time=0.000..0.000 rows=0 loops=171)

  • Output: t34._idrref, t34._version, t34._marked, t34._predefinedid, t34._description, t34._fld20354rref, t34._fld20355rref, t34._fld20356rref, t34._fld20357, t34._fld20358, t34._fld20359, t34._fld20360rref, t34._fld20361rref, t34._fld20362rref, t34._fld20363, t34._fld20364, t34._fld20365rref, t34._fld20366, t34._fld20367, t34._fld20368rref, t34._fld20369rref, t34._fld20370rref, t34._fld20371rref, t34._fld20372, t34._fld20373rref, t34._fld20374rref, t34._fld20375rref, t34._fld20376, t34._fld20377, t34._fld20378rref, t34._fld20379, t34._fld20380rref, t34._fld20381rref, t34._fld20382, t34._fld20383, t34._fld20384, t34._fld20385, t34._fld20386, t34._fld20387, t34._fld20388, t34._fld20389, t34._fld20390, t34._fld20391, t34._fld20392rref, t34._fld20393, t34._fld20394, t34._fld20395rref, t34._fld20396rref, t34._fld20397rref, t34._fld20398, t34._fld20399, t34._fld20400rref, t34._fld20401rref, t34._fld20402, t34._fld28126, t34._fld20403, t34._fld20404, t34._fld20405, t34._fld20406rref, t34._fld20407, t34._fld20408rref, t34._fld20409, t34._fld20410rref, t34._fld20411rref, t34._fld20412rref, t34._fld20413, t34._fld20414, t34._fld20415, t34._fld20416, t34._fld20417, t34._fld20418, t34._fld20419, t34._fld20420, t34._fld1177
  • Index Cond: ((t34._fld1177 = '0'::numeric) AND (t8._fld7233rref = t34._idrref))
86. 0.684 0.684 ↓ 0.0 0 171

Index Scan using _reference105_s_hpkng on public._reference105 t35 (cost=0.11..0.70 rows=1 width=34) (actual time=0.004..0.004 rows=0 loops=171)

  • Output: t35._idrref, t35._version, t35._marked, t35._predefinedid, t35._description, t35._fld20354rref, t35._fld20355rref, t35._fld20356rref, t35._fld20357, t35._fld20358, t35._fld20359, t35._fld20360rref, t35._fld20361rref, t35._fld20362rref, t35._fld20363, t35._fld20364, t35._fld20365rref, t35._fld20366, t35._fld20367, t35._fld20368rref, t35._fld20369rref, t35._fld20370rref, t35._fld20371rref, t35._fld20372, t35._fld20373rref, t35._fld20374rref, t35._fld20375rref, t35._fld20376, t35._fld20377, t35._fld20378rref, t35._fld20379, t35._fld20380rref, t35._fld20381rref, t35._fld20382, t35._fld20383, t35._fld20384, t35._fld20385, t35._fld20386, t35._fld20387, t35._fld20388, t35._fld20389, t35._fld20390, t35._fld20391, t35._fld20392rref, t35._fld20393, t35._fld20394, t35._fld20395rref, t35._fld20396rref, t35._fld20397rref, t35._fld20398, t35._fld20399, t35._fld20400rref, t35._fld20401rref, t35._fld20402, t35._fld28126, t35._fld20403, t35._fld20404, t35._fld20405, t35._fld20406rref, t35._fld20407, t35._fld20408rref, t35._fld20409, t35._fld20410rref, t35._fld20411rref, t35._fld20412rref, t35._fld20413, t35._fld20414, t35._fld20415, t35._fld20416, t35._fld20417, t35._fld20418, t35._fld20419, t35._fld20420, t35._fld1177
  • Index Cond: ((t35._fld1177 = '0'::numeric) AND (t9._fld9106rref = t35._idrref))
  • Buffers: shared hit=342
87. 0.000 0.000 ↓ 0.0 0 171

Index Scan using _reference105_s_hpkng on public._reference105 t36 (cost=0.11..2.33 rows=1 width=34) (actual time=0.000..0.000 rows=0 loops=171)

  • Output: t36._idrref, t36._version, t36._marked, t36._predefinedid, t36._description, t36._fld20354rref, t36._fld20355rref, t36._fld20356rref, t36._fld20357, t36._fld20358, t36._fld20359, t36._fld20360rref, t36._fld20361rref, t36._fld20362rref, t36._fld20363, t36._fld20364, t36._fld20365rref, t36._fld20366, t36._fld20367, t36._fld20368rref, t36._fld20369rref, t36._fld20370rref, t36._fld20371rref, t36._fld20372, t36._fld20373rref, t36._fld20374rref, t36._fld20375rref, t36._fld20376, t36._fld20377, t36._fld20378rref, t36._fld20379, t36._fld20380rref, t36._fld20381rref, t36._fld20382, t36._fld20383, t36._fld20384, t36._fld20385, t36._fld20386, t36._fld20387, t36._fld20388, t36._fld20389, t36._fld20390, t36._fld20391, t36._fld20392rref, t36._fld20393, t36._fld20394, t36._fld20395rref, t36._fld20396rref, t36._fld20397rref, t36._fld20398, t36._fld20399, t36._fld20400rref, t36._fld20401rref, t36._fld20402, t36._fld28126, t36._fld20403, t36._fld20404, t36._fld20405, t36._fld20406rref, t36._fld20407, t36._fld20408rref, t36._fld20409, t36._fld20410rref, t36._fld20411rref, t36._fld20412rref, t36._fld20413, t36._fld20414, t36._fld20415, t36._fld20416, t36._fld20417, t36._fld20418, t36._fld20419, t36._fld20420, t36._fld1177
  • Index Cond: ((t36._fld1177 = '0'::numeric) AND (t10._fld5630rref = t36._idrref))
88. 0.000 0.000 ↓ 0.0 0 171

Index Scan using _reference109_s_hpkng on public._reference109 t37 (cost=0.05..0.07 rows=1 width=34) (actual time=0.000..0.000 rows=0 loops=171)

  • Output: t37._idrref, t37._version, t37._marked, t37._predefinedid, t37._description, t37._fld20584rref, t37._fld20585rref, t37._fld20586rref, t37._fld20587, t37._fld20588, t37._fld20589, t37._fld20590rref, t37._fld20591rref, t37._fld20592, t37._fld20593, t37._fld20594, t37._fld20595rref, t37._fld20596rref, t37._fld20597rref, t37._fld20598rref, t37._fld20599, t37._fld20600rref, t37._fld20601rref, t37._fld20602rref, t37._fld20603rref, t37._fld20604, t37._fld20605rref, t37._fld20606rref, t37._fld20607, t37._fld20608, t37._fld20609rref, t37._fld20610, t37._fld20611, t37._fld20612, t37._fld20613, t37._fld20614, t37._fld20615, t37._fld20616, t37._fld20617, t37._fld20618, t37._fld20619, t37._fld20620rref, t37._fld20621, t37._fld20622, t37._fld20623rref, t37._fld20624rref, t37._fld20625, t37._fld20626, t37._fld20627, t37._fld1177
  • Index Cond: ((t37._fld1177 = '0'::numeric) AND (t11._fld6230_rrref = t37._idrref))
89. 0.000 0.000 ↓ 0.0 0 171

Index Scan using _reference105_s_hpkng on public._reference105 t38 (cost=0.11..0.22 rows=1 width=34) (actual time=0.000..0.000 rows=0 loops=171)

  • Output: t38._idrref, t38._version, t38._marked, t38._predefinedid, t38._description, t38._fld20354rref, t38._fld20355rref, t38._fld20356rref, t38._fld20357, t38._fld20358, t38._fld20359, t38._fld20360rref, t38._fld20361rref, t38._fld20362rref, t38._fld20363, t38._fld20364, t38._fld20365rref, t38._fld20366, t38._fld20367, t38._fld20368rref, t38._fld20369rref, t38._fld20370rref, t38._fld20371rref, t38._fld20372, t38._fld20373rref, t38._fld20374rref, t38._fld20375rref, t38._fld20376, t38._fld20377, t38._fld20378rref, t38._fld20379, t38._fld20380rref, t38._fld20381rref, t38._fld20382, t38._fld20383, t38._fld20384, t38._fld20385, t38._fld20386, t38._fld20387, t38._fld20388, t38._fld20389, t38._fld20390, t38._fld20391, t38._fld20392rref, t38._fld20393, t38._fld20394, t38._fld20395rref, t38._fld20396rref, t38._fld20397rref, t38._fld20398, t38._fld20399, t38._fld20400rref, t38._fld20401rref, t38._fld20402, t38._fld28126, t38._fld20403, t38._fld20404, t38._fld20405, t38._fld20406rref, t38._fld20407, t38._fld20408rref, t38._fld20409, t38._fld20410rref, t38._fld20411rref, t38._fld20412rref, t38._fld20413, t38._fld20414, t38._fld20415, t38._fld20416, t38._fld20417, t38._fld20418, t38._fld20419, t38._fld20420, t38._fld1177
  • Index Cond: ((t38._fld1177 = '0'::numeric) AND (t11._fld6230_rrref = t38._idrref))
90. 0.000 0.000 ↓ 0.0 0 171

Index Scan using _reference105_s_hpkng on public._reference105 t39 (cost=0.11..0.15 rows=1 width=34) (actual time=0.000..0.000 rows=0 loops=171)

  • Output: t39._idrref, t39._version, t39._marked, t39._predefinedid, t39._description, t39._fld20354rref, t39._fld20355rref, t39._fld20356rref, t39._fld20357, t39._fld20358, t39._fld20359, t39._fld20360rref, t39._fld20361rref, t39._fld20362rref, t39._fld20363, t39._fld20364, t39._fld20365rref, t39._fld20366, t39._fld20367, t39._fld20368rref, t39._fld20369rref, t39._fld20370rref, t39._fld20371rref, t39._fld20372, t39._fld20373rref, t39._fld20374rref, t39._fld20375rref, t39._fld20376, t39._fld20377, t39._fld20378rref, t39._fld20379, t39._fld20380rref, t39._fld20381rref, t39._fld20382, t39._fld20383, t39._fld20384, t39._fld20385, t39._fld20386, t39._fld20387, t39._fld20388, t39._fld20389, t39._fld20390, t39._fld20391, t39._fld20392rref, t39._fld20393, t39._fld20394, t39._fld20395rref, t39._fld20396rref, t39._fld20397rref, t39._fld20398, t39._fld20399, t39._fld20400rref, t39._fld20401rref, t39._fld20402, t39._fld28126, t39._fld20403, t39._fld20404, t39._fld20405, t39._fld20406rref, t39._fld20407, t39._fld20408rref, t39._fld20409, t39._fld20410rref, t39._fld20411rref, t39._fld20412rref, t39._fld20413, t39._fld20414, t39._fld20415, t39._fld20416, t39._fld20417, t39._fld20418, t39._fld20419, t39._fld20420, t39._fld1177
  • Index Cond: ((t39._fld1177 = '0'::numeric) AND (t12._fld3492rref = t39._idrref))
91. 0.000 0.000 ↓ 0.0 0 171

Index Scan using _reference105_s_hpkng on public._reference105 t40 (cost=0.11..1.34 rows=1 width=34) (actual time=0.000..0.000 rows=0 loops=171)

  • Output: t40._idrref, t40._version, t40._marked, t40._predefinedid, t40._description, t40._fld20354rref, t40._fld20355rref, t40._fld20356rref, t40._fld20357, t40._fld20358, t40._fld20359, t40._fld20360rref, t40._fld20361rref, t40._fld20362rref, t40._fld20363, t40._fld20364, t40._fld20365rref, t40._fld20366, t40._fld20367, t40._fld20368rref, t40._fld20369rref, t40._fld20370rref, t40._fld20371rref, t40._fld20372, t40._fld20373rref, t40._fld20374rref, t40._fld20375rref, t40._fld20376, t40._fld20377, t40._fld20378rref, t40._fld20379, t40._fld20380rref, t40._fld20381rref, t40._fld20382, t40._fld20383, t40._fld20384, t40._fld20385, t40._fld20386, t40._fld20387, t40._fld20388, t40._fld20389, t40._fld20390, t40._fld20391, t40._fld20392rref, t40._fld20393, t40._fld20394, t40._fld20395rref, t40._fld20396rref, t40._fld20397rref, t40._fld20398, t40._fld20399, t40._fld20400rref, t40._fld20401rref, t40._fld20402, t40._fld28126, t40._fld20403, t40._fld20404, t40._fld20405, t40._fld20406rref, t40._fld20407, t40._fld20408rref, t40._fld20409, t40._fld20410rref, t40._fld20411rref, t40._fld20412rref, t40._fld20413, t40._fld20414, t40._fld20415, t40._fld20416, t40._fld20417, t40._fld20418, t40._fld20419, t40._fld20420, t40._fld1177
  • Index Cond: ((t40._fld1177 = '0'::numeric) AND (t13._fld2533rref = t40._idrref))
92. 0.000 0.000 ↓ 0.0 0 171

Index Scan using _reference109_s_hpkng on public._reference109 t41 (cost=0.05..0.07 rows=1 width=34) (actual time=0.000..0.000 rows=0 loops=171)

  • Output: t41._idrref, t41._version, t41._marked, t41._predefinedid, t41._description, t41._fld20584rref, t41._fld20585rref, t41._fld20586rref, t41._fld20587, t41._fld20588, t41._fld20589, t41._fld20590rref, t41._fld20591rref, t41._fld20592, t41._fld20593, t41._fld20594, t41._fld20595rref, t41._fld20596rref, t41._fld20597rref, t41._fld20598rref, t41._fld20599, t41._fld20600rref, t41._fld20601rref, t41._fld20602rref, t41._fld20603rref, t41._fld20604, t41._fld20605rref, t41._fld20606rref, t41._fld20607, t41._fld20608, t41._fld20609rref, t41._fld20610, t41._fld20611, t41._fld20612, t41._fld20613, t41._fld20614, t41._fld20615, t41._fld20616, t41._fld20617, t41._fld20618, t41._fld20619, t41._fld20620rref, t41._fld20621, t41._fld20622, t41._fld20623rref, t41._fld20624rref, t41._fld20625, t41._fld20626, t41._fld20627, t41._fld1177
  • Index Cond: ((t41._fld1177 = '0'::numeric) AND (t14._fld8588_rrref = t41._idrref))
93. 0.000 0.000 ↓ 0.0 0 171

Index Scan using _reference105_s_hpkng on public._reference105 t42 (cost=0.11..0.14 rows=1 width=34) (actual time=0.000..0.000 rows=0 loops=171)

  • Output: t42._idrref, t42._version, t42._marked, t42._predefinedid, t42._description, t42._fld20354rref, t42._fld20355rref, t42._fld20356rref, t42._fld20357, t42._fld20358, t42._fld20359, t42._fld20360rref, t42._fld20361rref, t42._fld20362rref, t42._fld20363, t42._fld20364, t42._fld20365rref, t42._fld20366, t42._fld20367, t42._fld20368rref, t42._fld20369rref, t42._fld20370rref, t42._fld20371rref, t42._fld20372, t42._fld20373rref, t42._fld20374rref, t42._fld20375rref, t42._fld20376, t42._fld20377, t42._fld20378rref, t42._fld20379, t42._fld20380rref, t42._fld20381rref, t42._fld20382, t42._fld20383, t42._fld20384, t42._fld20385, t42._fld20386, t42._fld20387, t42._fld20388, t42._fld20389, t42._fld20390, t42._fld20391, t42._fld20392rref, t42._fld20393, t42._fld20394, t42._fld20395rref, t42._fld20396rref, t42._fld20397rref, t42._fld20398, t42._fld20399, t42._fld20400rref, t42._fld20401rref, t42._fld20402, t42._fld28126, t42._fld20403, t42._fld20404, t42._fld20405, t42._fld20406rref, t42._fld20407, t42._fld20408rref, t42._fld20409, t42._fld20410rref, t42._fld20411rref, t42._fld20412rref, t42._fld20413, t42._fld20414, t42._fld20415, t42._fld20416, t42._fld20417, t42._fld20418, t42._fld20419, t42._fld20420, t42._fld1177
  • Index Cond: ((t42._fld1177 = '0'::numeric) AND (t14._fld8588_rrref = t42._idrref))
94. 2.223 2.223 ↑ 1.0 10 171

Seq Scan on public._reference109 t43 (cost=0.00..1.11 rows=10 width=34) (actual time=0.005..0.013 rows=10 loops=171)

  • Output: t43._idrref, t43._version, t43._marked, t43._predefinedid, t43._description, t43._fld20584rref, t43._fld20585rref, t43._fld20586rref, t43._fld20587, t43._fld20588, t43._fld20589, t43._fld20590rref, t43._fld20591rref, t43._fld20592, t43._fld20593, t43._fld20594, t43._fld20595rref, t43._fld20596rref, t43._fld20597rref, t43._fld20598rref, t43._fld20599, t43._fld20600rref, t43._fld20601rref, t43._fld20602rref, t43._fld20603rref, t43._fld20604, t43._fld20605rref, t43._fld20606rref, t43._fld20607, t43._fld20608, t43._fld20609rref, t43._fld20610, t43._fld20611, t43._fld20612, t43._fld20613, t43._fld20614, t43._fld20615, t43._fld20616, t43._fld20617, t43._fld20618, t43._fld20619, t43._fld20620rref, t43._fld20621, t43._fld20622, t43._fld20623rref, t43._fld20624rref, t43._fld20625, t43._fld20626, t43._fld20627, t43._fld1177
  • Filter: (t43._fld1177 = '0'::numeric)
  • Buffers: shared hit=171
95. 0.000 0.000 ↓ 0.0 0 171

Index Scan using _reference105_s_hpkng on public._reference105 t44 (cost=0.11..2.33 rows=1 width=34) (actual time=0.000..0.000 rows=0 loops=171)

  • Output: t44._idrref, t44._version, t44._marked, t44._predefinedid, t44._description, t44._fld20354rref, t44._fld20355rref, t44._fld20356rref, t44._fld20357, t44._fld20358, t44._fld20359, t44._fld20360rref, t44._fld20361rref, t44._fld20362rref, t44._fld20363, t44._fld20364, t44._fld20365rref, t44._fld20366, t44._fld20367, t44._fld20368rref, t44._fld20369rref, t44._fld20370rref, t44._fld20371rref, t44._fld20372, t44._fld20373rref, t44._fld20374rref, t44._fld20375rref, t44._fld20376, t44._fld20377, t44._fld20378rref, t44._fld20379, t44._fld20380rref, t44._fld20381rref, t44._fld20382, t44._fld20383, t44._fld20384, t44._fld20385, t44._fld20386, t44._fld20387, t44._fld20388, t44._fld20389, t44._fld20390, t44._fld20391, t44._fld20392rref, t44._fld20393, t44._fld20394, t44._fld20395rref, t44._fld20396rref, t44._fld20397rref, t44._fld20398, t44._fld20399, t44._fld20400rref, t44._fld20401rref, t44._fld20402, t44._fld28126, t44._fld20403, t44._fld20404, t44._fld20405, t44._fld20406rref, t44._fld20407, t44._fld20408rref, t44._fld20409, t44._fld20410rref, t44._fld20411rref, t44._fld20412rref, t44._fld20413, t44._fld20414, t44._fld20415, t44._fld20416, t44._fld20417, t44._fld20418, t44._fld20419, t44._fld20420, t44._fld1177
  • Index Cond: ((t44._fld1177 = '0'::numeric) AND (t18._fld5795rref = t44._idrref))
96. 1.881 1.881 ↑ 1.0 10 171

Seq Scan on public._reference109 t45 (cost=0.00..1.11 rows=10 width=34) (actual time=0.003..0.011 rows=10 loops=171)

  • Output: t45._idrref, t45._version, t45._marked, t45._predefinedid, t45._description, t45._fld20584rref, t45._fld20585rref, t45._fld20586rref, t45._fld20587, t45._fld20588, t45._fld20589, t45._fld20590rref, t45._fld20591rref, t45._fld20592, t45._fld20593, t45._fld20594, t45._fld20595rref, t45._fld20596rref, t45._fld20597rref, t45._fld20598rref, t45._fld20599, t45._fld20600rref, t45._fld20601rref, t45._fld20602rref, t45._fld20603rref, t45._fld20604, t45._fld20605rref, t45._fld20606rref, t45._fld20607, t45._fld20608, t45._fld20609rref, t45._fld20610, t45._fld20611, t45._fld20612, t45._fld20613, t45._fld20614, t45._fld20615, t45._fld20616, t45._fld20617, t45._fld20618, t45._fld20619, t45._fld20620rref, t45._fld20621, t45._fld20622, t45._fld20623rref, t45._fld20624rref, t45._fld20625, t45._fld20626, t45._fld20627, t45._fld1177
  • Filter: (t45._fld1177 = '0'::numeric)
  • Buffers: shared hit=171
97. 0.000 0.000 ↓ 0.0 0 171

Index Scan using _reference105_s_hpkng on public._reference105 t46 (cost=0.11..2.33 rows=1 width=34) (actual time=0.000..0.000 rows=0 loops=171)

  • Output: t46._idrref, t46._version, t46._marked, t46._predefinedid, t46._description, t46._fld20354rref, t46._fld20355rref, t46._fld20356rref, t46._fld20357, t46._fld20358, t46._fld20359, t46._fld20360rref, t46._fld20361rref, t46._fld20362rref, t46._fld20363, t46._fld20364, t46._fld20365rref, t46._fld20366, t46._fld20367, t46._fld20368rref, t46._fld20369rref, t46._fld20370rref, t46._fld20371rref, t46._fld20372, t46._fld20373rref, t46._fld20374rref, t46._fld20375rref, t46._fld20376, t46._fld20377, t46._fld20378rref, t46._fld20379, t46._fld20380rref, t46._fld20381rref, t46._fld20382, t46._fld20383, t46._fld20384, t46._fld20385, t46._fld20386, t46._fld20387, t46._fld20388, t46._fld20389, t46._fld20390, t46._fld20391, t46._fld20392rref, t46._fld20393, t46._fld20394, t46._fld20395rref, t46._fld20396rref, t46._fld20397rref, t46._fld20398, t46._fld20399, t46._fld20400rref, t46._fld20401rref, t46._fld20402, t46._fld28126, t46._fld20403, t46._fld20404, t46._fld20405, t46._fld20406rref, t46._fld20407, t46._fld20408rref, t46._fld20409, t46._fld20410rref, t46._fld20411rref, t46._fld20412rref, t46._fld20413, t46._fld20414, t46._fld20415, t46._fld20416, t46._fld20417, t46._fld20418, t46._fld20419, t46._fld20420, t46._fld1177
  • Index Cond: ((t46._fld1177 = '0'::numeric) AND (t20._fld5877rref = t46._idrref))
98. 0.000 0.000 ↓ 0.0 0 171

Index Scan using _reference105_s_hpkng on public._reference105 t47 (cost=0.11..0.23 rows=1 width=34) (actual time=0.000..0.000 rows=0 loops=171)

  • Output: t47._idrref, t47._version, t47._marked, t47._predefinedid, t47._description, t47._fld20354rref, t47._fld20355rref, t47._fld20356rref, t47._fld20357, t47._fld20358, t47._fld20359, t47._fld20360rref, t47._fld20361rref, t47._fld20362rref, t47._fld20363, t47._fld20364, t47._fld20365rref, t47._fld20366, t47._fld20367, t47._fld20368rref, t47._fld20369rref, t47._fld20370rref, t47._fld20371rref, t47._fld20372, t47._fld20373rref, t47._fld20374rref, t47._fld20375rref, t47._fld20376, t47._fld20377, t47._fld20378rref, t47._fld20379, t47._fld20380rref, t47._fld20381rref, t47._fld20382, t47._fld20383, t47._fld20384, t47._fld20385, t47._fld20386, t47._fld20387, t47._fld20388, t47._fld20389, t47._fld20390, t47._fld20391, t47._fld20392rref, t47._fld20393, t47._fld20394, t47._fld20395rref, t47._fld20396rref, t47._fld20397rref, t47._fld20398, t47._fld20399, t47._fld20400rref, t47._fld20401rref, t47._fld20402, t47._fld28126, t47._fld20403, t47._fld20404, t47._fld20405, t47._fld20406rref, t47._fld20407, t47._fld20408rref, t47._fld20409, t47._fld20410rref, t47._fld20411rref, t47._fld20412rref, t47._fld20413, t47._fld20414, t47._fld20415, t47._fld20416, t47._fld20417, t47._fld20418, t47._fld20419, t47._fld20420, t47._fld1177
  • Index Cond: ((t47._fld1177 = '0'::numeric) AND (t21._fld7386rref = t47._idrref))
99. 1.881 1.881 ↑ 1.0 10 171

Seq Scan on public._reference109 t48 (cost=0.00..1.11 rows=10 width=34) (actual time=0.003..0.011 rows=10 loops=171)

  • Output: t48._idrref, t48._version, t48._marked, t48._predefinedid, t48._description, t48._fld20584rref, t48._fld20585rref, t48._fld20586rref, t48._fld20587, t48._fld20588, t48._fld20589, t48._fld20590rref, t48._fld20591rref, t48._fld20592, t48._fld20593, t48._fld20594, t48._fld20595rref, t48._fld20596rref, t48._fld20597rref, t48._fld20598rref, t48._fld20599, t48._fld20600rref, t48._fld20601rref, t48._fld20602rref, t48._fld20603rref, t48._fld20604, t48._fld20605rref, t48._fld20606rref, t48._fld20607, t48._fld20608, t48._fld20609rref, t48._fld20610, t48._fld20611, t48._fld20612, t48._fld20613, t48._fld20614, t48._fld20615, t48._fld20616, t48._fld20617, t48._fld20618, t48._fld20619, t48._fld20620rref, t48._fld20621, t48._fld20622, t48._fld20623rref, t48._fld20624rref, t48._fld20625, t48._fld20626, t48._fld20627, t48._fld1177
  • Filter: (t48._fld1177 = '0'::numeric)
  • Buffers: shared hit=171
100. 0.171 0.171 ↓ 0.0 0 171

Index Scan using _reference109_s_hpkng on public._reference109 t49 (cost=0.05..0.07 rows=1 width=34) (actual time=0.001..0.001 rows=0 loops=171)

  • Output: t49._idrref, t49._version, t49._marked, t49._predefinedid, t49._description, t49._fld20584rref, t49._fld20585rref, t49._fld20586rref, t49._fld20587, t49._fld20588, t49._fld20589, t49._fld20590rref, t49._fld20591rref, t49._fld20592, t49._fld20593, t49._fld20594, t49._fld20595rref, t49._fld20596rref, t49._fld20597rref, t49._fld20598rref, t49._fld20599, t49._fld20600rref, t49._fld20601rref, t49._fld20602rref, t49._fld20603rref, t49._fld20604, t49._fld20605rref, t49._fld20606rref, t49._fld20607, t49._fld20608, t49._fld20609rref, t49._fld20610, t49._fld20611, t49._fld20612, t49._fld20613, t49._fld20614, t49._fld20615, t49._fld20616, t49._fld20617, t49._fld20618, t49._fld20619, t49._fld20620rref, t49._fld20621, t49._fld20622, t49._fld20623rref, t49._fld20624rref, t49._fld20625, t49._fld20626, t49._fld20627, t49._fld1177
  • Index Cond: ((t49._fld1177 = '0'::numeric) AND (t23._fld6304rref = t49._idrref))
101. 0.000 0.000 ↓ 0.0 0 171

Index Scan using _reference105_s_hpkng on public._reference105 t50 (cost=0.11..2.33 rows=1 width=34) (actual time=0.000..0.000 rows=0 loops=171)

  • Output: t50._idrref, t50._version, t50._marked, t50._predefinedid, t50._description, t50._fld20354rref, t50._fld20355rref, t50._fld20356rref, t50._fld20357, t50._fld20358, t50._fld20359, t50._fld20360rref, t50._fld20361rref, t50._fld20362rref, t50._fld20363, t50._fld20364, t50._fld20365rref, t50._fld20366, t50._fld20367, t50._fld20368rref, t50._fld20369rref, t50._fld20370rref, t50._fld20371rref, t50._fld20372, t50._fld20373rref, t50._fld20374rref, t50._fld20375rref, t50._fld20376, t50._fld20377, t50._fld20378rref, t50._fld20379, t50._fld20380rref, t50._fld20381rref, t50._fld20382, t50._fld20383, t50._fld20384, t50._fld20385, t50._fld20386, t50._fld20387, t50._fld20388, t50._fld20389, t50._fld20390, t50._fld20391, t50._fld20392rref, t50._fld20393, t50._fld20394, t50._fld20395rref, t50._fld20396rref, t50._fld20397rref, t50._fld20398, t50._fld20399, t50._fld20400rref, t50._fld20401rref, t50._fld20402, t50._fld28126, t50._fld20403, t50._fld20404, t50._fld20405, t50._fld20406rref, t50._fld20407, t50._fld20408rref, t50._fld20409, t50._fld20410rref, t50._fld20411rref, t50._fld20412rref, t50._fld20413, t50._fld20414, t50._fld20415, t50._fld20416, t50._fld20417, t50._fld20418, t50._fld20419, t50._fld20420, t50._fld1177
  • Index Cond: ((t50._fld1177 = '0'::numeric) AND (t24._fld2885rref = t50._idrref))
102. 0.000 0.000 ↓ 0.0 0 171

Index Scan using _reference109_s_hpkng on public._reference109 t51 (cost=0.05..0.07 rows=1 width=34) (actual time=0.000..0.000 rows=0 loops=171)

  • Output: t51._idrref, t51._version, t51._marked, t51._predefinedid, t51._description, t51._fld20584rref, t51._fld20585rref, t51._fld20586rref, t51._fld20587, t51._fld20588, t51._fld20589, t51._fld20590rref, t51._fld20591rref, t51._fld20592, t51._fld20593, t51._fld20594, t51._fld20595rref, t51._fld20596rref, t51._fld20597rref, t51._fld20598rref, t51._fld20599, t51._fld20600rref, t51._fld20601rref, t51._fld20602rref, t51._fld20603rref, t51._fld20604, t51._fld20605rref, t51._fld20606rref, t51._fld20607, t51._fld20608, t51._fld20609rref, t51._fld20610, t51._fld20611, t51._fld20612, t51._fld20613, t51._fld20614, t51._fld20615, t51._fld20616, t51._fld20617, t51._fld20618, t51._fld20619, t51._fld20620rref, t51._fld20621, t51._fld20622, t51._fld20623rref, t51._fld20624rref, t51._fld20625, t51._fld20626, t51._fld20627, t51._fld1177
  • Index Cond: ((t51._fld1177 = '0'::numeric) AND (t25._fld7084_rrref = t51._idrref))
103. 0.000 0.000 ↓ 0.0 0 171

Index Scan using _reference105_s_hpkng on public._reference105 t52 (cost=0.11..0.13 rows=1 width=34) (actual time=0.000..0.000 rows=0 loops=171)

  • Output: t52._idrref, t52._version, t52._marked, t52._predefinedid, t52._description, t52._fld20354rref, t52._fld20355rref, t52._fld20356rref, t52._fld20357, t52._fld20358, t52._fld20359, t52._fld20360rref, t52._fld20361rref, t52._fld20362rref, t52._fld20363, t52._fld20364, t52._fld20365rref, t52._fld20366, t52._fld20367, t52._fld20368rref, t52._fld20369rref, t52._fld20370rref, t52._fld20371rref, t52._fld20372, t52._fld20373rref, t52._fld20374rref, t52._fld20375rref, t52._fld20376, t52._fld20377, t52._fld20378rref, t52._fld20379, t52._fld20380rref, t52._fld20381rref, t52._fld20382, t52._fld20383, t52._fld20384, t52._fld20385, t52._fld20386, t52._fld20387, t52._fld20388, t52._fld20389, t52._fld20390, t52._fld20391, t52._fld20392rref, t52._fld20393, t52._fld20394, t52._fld20395rref, t52._fld20396rref, t52._fld20397rref, t52._fld20398, t52._fld20399, t52._fld20400rref, t52._fld20401rref, t52._fld20402, t52._fld28126, t52._fld20403, t52._fld20404, t52._fld20405, t52._fld20406rref, t52._fld20407, t52._fld20408rref, t52._fld20409, t52._fld20410rref, t52._fld20411rref, t52._fld20412rref, t52._fld20413, t52._fld20414, t52._fld20415, t52._fld20416, t52._fld20417, t52._fld20418, t52._fld20419, t52._fld20420, t52._fld1177
  • Index Cond: ((t52._fld1177 = '0'::numeric) AND (t25._fld7084_rrref = t52._idrref))
104. 0.009 0.035 ↑ 1.0 10 1

Hash (cost=1.11..1.11 rows=10 width=34) (actual time=0.035..0.035 rows=10 loops=1)

  • Output: t53._fld20605rref, t53._idrref
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
105. 0.026 0.026 ↑ 1.0 10 1

Seq Scan on public._reference109 t53 (cost=0.00..1.11 rows=10 width=34) (actual time=0.015..0.026 rows=10 loops=1)

  • Output: t53._fld20605rref, t53._idrref
  • Filter: (t53._fld1177 = '0'::numeric)
  • Buffers: shared hit=1