Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Limit (cost=37182813.03..37182813.14 rows=45 width=554) (actual time=1746949.717..1746949.883 rows=45 loops=1)
- Output: t1._documenttref, t1._documentrref, t1._date_time, t1._marked, t1._number, t1._posted, t1._fld19396rref, t1._fld19397rref, (CASE WHEN (('\\x08'::bytea || t1._documenttref) = ANY ('{"\\\\x0800000112","
- \\\\x080000011c"}'::bytea[])) THEN '\\x06'::bytea ELSE CASE WHEN (t1._fld19398rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END END), (CASE WHEN (('\\x08'::bytea || t1._documenttref) = ANY ('{"\\\\x0800
- 000112","\\\\x080000011c"}'::bytea[])) THEN ('\\x08'::bytea || t1._documenttref) ELSE CASE WHEN (t1._fld19398rref IS NOT NULL) THEN '\\x'::bytea ELSE NULL::bytea END END), (CASE WHEN (('\\x08'::bytea || t1._docu
- menttref) = ANY ('{"\\\\x0800000112","\\\\x080000011c"}'::bytea[])) THEN '\\x00000000000000000000000000000000'::bytea ELSE t1._fld19398rref END), (CASE WHEN (('\\x08'::bytea || t1._documenttref) = ANY ('{"\\\\x0
- 800000112","\\\\x080000011c"}'::bytea[])) THEN 2 ELSE 1 END), t1._fld19399rref, (CASE WHEN (('\\x08'::bytea || t1._documenttref) = '\\x080000010f'::bytea) THEN CASE WHEN (t1._fld19399rref = ANY ('{"\\\\x8f261be8
- 72c32c8c4982cbbe6e69e44b","\\\\xb1403b1c2a8a3a424f5531808adc8fdb","\\\\x82202eb29fa05ef541950d5ca07305c5"}'::bytea[])) THEN CASE WHEN (t13._owneridrref IS NOT NULL) THEN '\\x00000075'::bytea ELSE NULL::bytea END
- WHEN (t1._fld19399rref = '\\x9010be00be4d72154f32aa25d23d95eb'::bytea) THEN CASE WHEN (t4._fld7675rref IS NOT NULL) THEN '\\x000000c4'::bytea ELSE NULL::bytea END ELSE CASE WHEN (t1._fld19400rref IS NOT NULL) T
- HEN '\\x00000061'::bytea ELSE NULL::bytea END END WHEN (('\\x08'::bytea || t1._documenttref) = '\\x0800000125'::bytea) THEN CASE WHEN (t1._fld19399rref = ANY ('{"\\\\xb24f430cd2009fae4e22f484692215c8","\\\\x823e
- 32dfa2be22324a170d1f51ad2381","\\\\x82202eb29fa05ef541950d5ca07305c5"}'::bytea[])) THEN CASE WHEN (t24._owneridrref IS NOT NULL) THEN '\\x00000075'::bytea ELSE NULL::bytea END WHEN (t1._fld19399rref = ANY ('{"\\
- \\x87736b644d757e224405854295818758","\\\\x9ff8d6cbe795713f487db4056d079ef6"}'::bytea[])) THEN CASE WHEN (t15._fld8558rref IS NOT NULL) THEN '\\x000000c4'::bytea ELSE NULL::bytea END ELSE CASE WHEN (t1._fld19400
- rref IS NOT NULL) THEN '\\x00000061'::bytea ELSE NULL::bytea END END ELSE NULL::bytea END), (CASE WHEN (('\\x08'::bytea || t1._documenttref) = '\\x080000010f'::bytea) THEN CASE WHEN (t1._fld19399rref = ANY ('{"\
- \\\x8f261be872c32c8c4982cbbe6e69e44b","\\\\xb1403b1c2a8a3a424f5531808adc8fdb","\\\\x82202eb29fa05ef541950d5ca07305c5"}'::bytea[])) THEN t13._owneridrref WHEN (t1._fld19399rref = '\\x9010be00be4d72154f32aa25d23d9
- 5eb'::bytea) THEN t4._fld7675rref ELSE t1._fld19400rref END WHEN (('\\x08'::bytea || t1._documenttref) = '\\x0800000125'::bytea) THEN CASE WHEN (t1._fld19399rref = ANY ('{"\\\\xb24f430cd2009fae4e22f484692215c8",
- "\\\\x823e32dfa2be22324a170d1f51ad2381","\\\\x82202eb29fa05ef541950d5ca07305c5"}'::bytea[])) THEN t24._owneridrref WHEN (t1._fld19399rref = ANY ('{"\\\\x87736b644d757e224405854295818758","\\\\x9ff8d6cbe795713f48
- 7db4056d079ef6"}'::bytea[])) THEN t15._fld8558rref ELSE t1._fld19400rref END ELSE NULL::bytea END), (CASE WHEN (('\\x08'::bytea || t1._documenttref) = '\\x080000010f'::bytea) THEN CASE WHEN (t1._fld19399rref = A
- NY ('{"\\\\x8f261be872c32c8c4982cbbe6e69e44b","\\\\xb1403b1c2a8a3a424f5531808adc8fdb","\\\\x82202eb29fa05ef541950d5ca07305c5"}'::bytea[])) THEN t25._description WHEN (t1._fld19399rref = '\\x9010be00be4d72154f32a
- a25d23d95eb'::bytea) THEN t26._description ELSE t27._description END WHEN (('\\x08'::bytea || t1._documenttref) = '\\x0800000125'::bytea) THEN CASE WHEN (t1._fld19399rref = ANY ('{"\\\\xb24f430cd2009fae4e22f4846
- 92215c8","\\\\x823e32dfa2be22324a170d1f51ad2381","\\\\x82202eb29fa05ef541950d5ca07305c5"}'::bytea[])) THEN t28._description WHEN (t1._fld19399rref = ANY ('{"\\\\x87736b644d757e224405854295818758","\\\\x9ff8d6cbe
- 795713f487db4056d079ef6"}'::bytea[])) THEN t29._description ELSE t27._description END ELSE NULL::mvarchar END), t1._fld19401, t1._fld19402, t1._fld19403, t1._fld19404, t1._fld19405rref, (CASE WHEN (('\\x08'::byt
- ea || t1._documenttref) = ANY ('{"\\\\x0800000112","\\\\x080000011c"}'::bytea[])) THEN true ELSE t1._fld19406 END), (CASE WHEN (('\\x08'::bytea || t1._documenttref) = ANY ('{"\\\\x0800000112","\\\\x080000011c"}'
- ::bytea[])) THEN t1._date_time ELSE t1._fld19407 END), t1._fld19408, t1._fld19409, (CASE WHEN (('\\x08'::bytea || t1._documenttref) = '\\x080000010f'::bytea) THEN CASE WHEN (t1._documenttref = '\\x0000010f'::byt
- ea) THEN t1._documentrref ELSE NULL::bytea END ELSE NULL::bytea END), (CASE WHEN (('\\x08'::bytea || t1._documenttref) = '\\x0800000125'::bytea) THEN CASE WHEN (t1._documenttref = '\\x00000125'::bytea) THEN t1._
- documentrref ELSE NULL::bytea END ELSE NULL::bytea END), (CASE WHEN ((t2._fld19510_type IS NULL) AND (t2._fld19510_rtref IS NULL) AND (t2._fld19510_rrref IS NULL)) THEN false ELSE true END), (CASE WHEN (CASE WHE
- N (('\\x08'::bytea || t1._documenttref) = ANY ('{"\\\\x0800000112","\\\\x080000011c"}'::bytea[])) THEN t1._date_time ELSE t1._fld19407 END IS NULL) THEN '0001-01-01 00:00:00'::timestamp without time zone ELSE CA
- SE WHEN (('\\x08'::bytea || t1._documenttref) = ANY ('{"\\\\x0800000112","\\\\x080000011c"}'::bytea[])) THEN t1._date_time ELSE t1._fld19407 END END)
- Buffers: shared hit=15702852
- -> Sort (cost=37182813.03..37182840.15 rows=10850 width=554) (actual time=1746949.706..1746949.777 rows=45 loops=1)
- Output: t1._documenttref, t1._documentrref, t1._date_time, t1._marked, t1._number, t1._posted, t1._fld19396rref, t1._fld19397rref, (CASE WHEN (('\\x08'::bytea || t1._documenttref) = ANY ('{"\\\\x0800000
- 112","\\\\x080000011c"}'::bytea[])) THEN '\\x06'::bytea ELSE CASE WHEN (t1._fld19398rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END END), (CASE WHEN (('\\x08'::bytea || t1._documenttref) = ANY ('{"\\\
- \x0800000112","\\\\x080000011c"}'::bytea[])) THEN ('\\x08'::bytea || t1._documenttref) ELSE CASE WHEN (t1._fld19398rref IS NOT NULL) THEN '\\x'::bytea ELSE NULL::bytea END END), (CASE WHEN (('\\x08'::bytea || t1
- ._documenttref) = ANY ('{"\\\\x0800000112","\\\\x080000011c"}'::bytea[])) THEN '\\x00000000000000000000000000000000'::bytea ELSE t1._fld19398rref END), (CASE WHEN (('\\x08'::bytea || t1._documenttref) = ANY ('{"
- \\\\x0800000112","\\\\x080000011c"}'::bytea[])) THEN 2 ELSE 1 END), t1._fld19399rref, (CASE WHEN (('\\x08'::bytea || t1._documenttref) = '\\x080000010f'::bytea) THEN CASE WHEN (t1._fld19399rref = ANY ('{"\\\\x8f
- 261be872c32c8c4982cbbe6e69e44b","\\\\xb1403b1c2a8a3a424f5531808adc8fdb","\\\\x82202eb29fa05ef541950d5ca07305c5"}'::bytea[])) THEN CASE WHEN (t13._owneridrref IS NOT NULL) THEN '\\x00000075'::bytea ELSE NULL::byt
- ea END WHEN (t1._fld19399rref = '\\x9010be00be4d72154f32aa25d23d95eb'::bytea) THEN CASE WHEN (t4._fld7675rref IS NOT NULL) THEN '\\x000000c4'::bytea ELSE NULL::bytea END ELSE CASE WHEN (t1._fld19400rref IS NOT N
- ULL) THEN '\\x00000061'::bytea ELSE NULL::bytea END END WHEN (('\\x08'::bytea || t1._documenttref) = '\\x0800000125'::bytea) THEN CASE WHEN (t1._fld19399rref = ANY ('{"\\\\xb24f430cd2009fae4e22f484692215c8","\\\
- \x823e32dfa2be22324a170d1f51ad2381","\\\\x82202eb29fa05ef541950d5ca07305c5"}'::bytea[])) THEN CASE WHEN (t24._owneridrref IS NOT NULL) THEN '\\x00000075'::bytea ELSE NULL::bytea END WHEN (t1._fld19399rref = ANY
- ('{"\\\\x87736b644d757e224405854295818758","\\\\x9ff8d6cbe795713f487db4056d079ef6"}'::bytea[])) THEN CASE WHEN (t15._fld8558rref IS NOT NULL) THEN '\\x000000c4'::bytea ELSE NULL::bytea END ELSE CASE WHEN (t1._fl
- d19400rref IS NOT NULL) THEN '\\x00000061'::bytea ELSE NULL::bytea END END ELSE NULL::bytea END), (CASE WHEN (('\\x08'::bytea || t1._documenttref) = '\\x080000010f'::bytea) THEN CASE WHEN (t1._fld19399rref = ANY
- ('{"\\\\x8f261be872c32c8c4982cbbe6e69e44b","\\\\xb1403b1c2a8a3a424f5531808adc8fdb","\\\\x82202eb29fa05ef541950d5ca07305c5"}'::bytea[])) THEN t13._owneridrref WHEN (t1._fld19399rref = '\\x9010be00be4d72154f32aa2
- 5d23d95eb'::bytea) THEN t4._fld7675rref ELSE t1._fld19400rref END WHEN (('\\x08'::bytea || t1._documenttref) = '\\x0800000125'::bytea) THEN CASE WHEN (t1._fld19399rref = ANY ('{"\\\\xb24f430cd2009fae4e22f4846922
- 15c8","\\\\x823e32dfa2be22324a170d1f51ad2381","\\\\x82202eb29fa05ef541950d5ca07305c5"}'::bytea[])) THEN t24._owneridrref WHEN (t1._fld19399rref = ANY ('{"\\\\x87736b644d757e224405854295818758","\\\\x9ff8d6cbe795
- 713f487db4056d079ef6"}'::bytea[])) THEN t15._fld8558rref ELSE t1._fld19400rref END ELSE NULL::bytea END), (CASE WHEN (('\\x08'::bytea || t1._documenttref) = '\\x080000010f'::bytea) THEN CASE WHEN (t1._fld19399rr
- ef = ANY ('{"\\\\x8f261be872c32c8c4982cbbe6e69e44b","\\\\xb1403b1c2a8a3a424f5531808adc8fdb","\\\\x82202eb29fa05ef541950d5ca07305c5"}'::bytea[])) THEN t25._description WHEN (t1._fld19399rref = '\\x9010be00be4d721
- 54f32aa25d23d95eb'::bytea) THEN t26._description ELSE t27._description END WHEN (('\\x08'::bytea || t1._documenttref) = '\\x0800000125'::bytea) THEN CASE WHEN (t1._fld19399rref = ANY ('{"\\\\xb24f430cd2009fae4e2
- 2f484692215c8","\\\\x823e32dfa2be22324a170d1f51ad2381","\\\\x82202eb29fa05ef541950d5ca07305c5"}'::bytea[])) THEN t28._description WHEN (t1._fld19399rref = ANY ('{"\\\\x87736b644d757e224405854295818758","\\\\x9ff
- 8d6cbe795713f487db4056d079ef6"}'::bytea[])) THEN t29._description ELSE t27._description END ELSE NULL::mvarchar END), t1._fld19401, t1._fld19402, t1._fld19403, t1._fld19404, t1._fld19405rref, (CASE WHEN (('\\x08
- '::bytea || t1._documenttref) = ANY ('{"\\\\x0800000112","\\\\x080000011c"}'::bytea[])) THEN true ELSE t1._fld19406 END), (CASE WHEN (('\\x08'::bytea || t1._documenttref) = ANY ('{"\\\\x0800000112","\\\\x0800000
- 11c"}'::bytea[])) THEN t1._date_time ELSE t1._fld19407 END), t1._fld19408, t1._fld19409, (CASE WHEN (('\\x08'::bytea || t1._documenttref) = '\\x080000010f'::bytea) THEN CASE WHEN (t1._documenttref = '\\x0000010f
- '::bytea) THEN t1._documentrref ELSE NULL::bytea END ELSE NULL::bytea END), (CASE WHEN (('\\x08'::bytea || t1._documenttref) = '\\x0800000125'::bytea) THEN CASE WHEN (t1._documenttref = '\\x00000125'::bytea) THE
- N t1._documentrref ELSE NULL::bytea END ELSE NULL::bytea END), (CASE WHEN ((t2._fld19510_type IS NULL) AND (t2._fld19510_rtref IS NULL) AND (t2._fld19510_rrref IS NULL)) THEN false ELSE true END), (CASE WHEN (CA
- SE WHEN (('\\x08'::bytea || t1._documenttref) = ANY ('{"\\\\x0800000112","\\\\x080000011c"}'::bytea[])) THEN t1._date_time ELSE t1._fld19407 END IS NULL) THEN '0001-01-01 00:00:00'::timestamp without time zone E
- LSE CASE WHEN (('\\x08'::bytea || t1._documenttref) = ANY ('{"\\\\x0800000112","\\\\x080000011c"}'::bytea[])) THEN t1._date_time ELSE t1._fld19407 END END)
- Sort Key: (CASE WHEN (CASE WHEN (('\\x08'::bytea || t1._documenttref) = ANY ('{"\\\\x0800000112","\\\\x080000011c"}'::bytea[])) THEN t1._date_time ELSE t1._fld19407 END IS NULL) THEN '0001-01-01 00:00:0
- 0'::timestamp without time zone ELSE CASE WHEN (('\\x08'::bytea || t1._documenttref) = ANY ('{"\\\\x0800000112","\\\\x080000011c"}'::bytea[])) THEN t1._date_time ELSE t1._fld19407 END END) DESC, t1._documenttref
- DESC, t1._documentrref DESC
- Sort Method: top-N heapsort Memory: 60kB
- Buffers: shared hit=15702852
- -> Nested Loop Left Join (cost=0.86..37182460.84 rows=10850 width=554) (actual time=103.960..1746809.558 rows=16709 loops=1)
- Output: t1._documenttref, t1._documentrref, t1._date_time, t1._marked, t1._number, t1._posted, t1._fld19396rref, t1._fld19397rref, CASE WHEN (('\\x08'::bytea || t1._documenttref) = ANY ('{"\\\\x08
- 00000112","\\\\x080000011c"}'::bytea[])) THEN '\\x06'::bytea ELSE CASE WHEN (t1._fld19398rref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END END, CASE WHEN (('\\x08'::bytea || t1._documenttref) = ANY ('{"
- \\\\x0800000112","\\\\x080000011c"}'::bytea[])) THEN ('\\x08'::bytea || t1._documenttref) ELSE CASE WHEN (t1._fld19398rref IS NOT NULL) THEN '\\x'::bytea ELSE NULL::bytea END END, CASE WHEN (('\\x08'::bytea || t
- 1._documenttref) = ANY ('{"\\\\x0800000112","\\\\x080000011c"}'::bytea[])) THEN '\\x00000000000000000000000000000000'::bytea ELSE t1._fld19398rref END, CASE WHEN (('\\x08'::bytea || t1._documenttref) = ANY ('{"\
- \\\x0800000112","\\\\x080000011c"}'::bytea[])) THEN 2 ELSE 1 END, t1._fld19399rref, CASE WHEN (('\\x08'::bytea || t1._documenttref) = '\\x080000010f'::bytea) THEN CASE WHEN (t1._fld19399rref = ANY ('{"\\\\x8f261
- be872c32c8c4982cbbe6e69e44b","\\\\xb1403b1c2a8a3a424f5531808adc8fdb","\\\\x82202eb29fa05ef541950d5ca07305c5"}'::bytea[])) THEN CASE WHEN (t13._owneridrref IS NOT NULL) THEN '\\x00000075'::bytea ELSE NULL::bytea
- END WHEN (t1._fld19399rref = '\\x9010be00be4d72154f32aa25d23d95eb'::bytea) THEN CASE WHEN (t4._fld7675rref IS NOT NULL) THEN '\\x000000c4'::bytea ELSE NULL::bytea END ELSE CASE WHEN (t1._fld19400rref IS NOT NULL
- ) THEN '\\x00000061'::bytea ELSE NULL::bytea END END WHEN (('\\x08'::bytea || t1._documenttref) = '\\x0800000125'::bytea) THEN CASE WHEN (t1._fld19399rref = ANY ('{"\\\\xb24f430cd2009fae4e22f484692215c8","\\\\x8
- 23e32dfa2be22324a170d1f51ad2381","\\\\x82202eb29fa05ef541950d5ca07305c5"}'::bytea[])) THEN CASE WHEN (t24._owneridrref IS NOT NULL) THEN '\\x00000075'::bytea ELSE NULL::bytea END WHEN (t1._fld19399rref = ANY ('{
- "\\\\x87736b644d757e224405854295818758","\\\\x9ff8d6cbe795713f487db4056d079ef6"}'::bytea[])) THEN CASE WHEN (t15._fld8558rref IS NOT NULL) THEN '\\x000000c4'::bytea ELSE NULL::bytea END ELSE CASE WHEN (t1._fld19
- 400rref IS NOT NULL) THEN '\\x00000061'::bytea ELSE NULL::bytea END END ELSE NULL::bytea END, CASE WHEN (('\\x08'::bytea || t1._documenttref) = '\\x080000010f'::bytea) THEN CASE WHEN (t1._fld19399rref = ANY ('{"
- \\\\x8f261be872c32c8c4982cbbe6e69e44b","\\\\xb1403b1c2a8a3a424f5531808adc8fdb","\\\\x82202eb29fa05ef541950d5ca07305c5"}'::bytea[])) THEN t13._owneridrref WHEN (t1._fld19399rref = '\\x9010be00be4d72154f32aa25d23d
- 95eb'::bytea) THEN t4._fld7675rref ELSE t1._fld19400rref END WHEN (('\\x08'::bytea || t1._documenttref) = '\\x0800000125'::bytea) THEN CASE WHEN (t1._fld19399rref = ANY ('{"\\\\xb24f430cd2009fae4e22f484692215c8"
- ,"\\\\x823e32dfa2be22324a170d1f51ad2381","\\\\x82202eb29fa05ef541950d5ca07305c5"}'::bytea[])) THEN t24._owneridrref WHEN (t1._fld19399rref = ANY ('{"\\\\x87736b644d757e224405854295818758","\\\\x9ff8d6cbe795713f4
- 87db4056d079ef6"}'::bytea[])) THEN t15._fld8558rref ELSE t1._fld19400rref END ELSE NULL::bytea END, CASE WHEN (('\\x08'::bytea || t1._documenttref) = '\\x080000010f'::bytea) THEN CASE WHEN (t1._fld19399rref = AN
- Y ('{"\\\\x8f261be872c32c8c4982cbbe6e69e44b","\\\\xb1403b1c2a8a3a424f5531808adc8fdb","\\\\x82202eb29fa05ef541950d5ca07305c5"}'::bytea[])) THEN t25._description WHEN (t1._fld19399rref = '\\x9010be00be4d72154f32aa
- 25d23d95eb'::bytea) THEN t26._description ELSE t27._description END WHEN (('\\x08'::bytea || t1._documenttref) = '\\x0800000125'::bytea) THEN CASE WHEN (t1._fld19399rref = ANY ('{"\\\\xb24f430cd2009fae4e22f48469
- 2215c8","\\\\x823e32dfa2be22324a170d1f51ad2381","\\\\x82202eb29fa05ef541950d5ca07305c5"}'::bytea[])) THEN t28._description WHEN (t1._fld19399rref = ANY ('{"\\\\x87736b644d757e224405854295818758","\\\\x9ff8d6cbe7
- 95713f487db4056d079ef6"}'::bytea[])) THEN t29._description ELSE t27._description END ELSE NULL::mvarchar END, t1._fld19401, t1._fld19402, t1._fld19403, t1._fld19404, t1._fld19405rref, CASE WHEN (('\\x08'::bytea
- || t1._documenttref) = ANY ('{"\\\\x0800000112","\\\\x080000011c"}'::bytea[])) THEN true ELSE t1._fld19406 END, CASE WHEN (('\\x08'::bytea || t1._documenttref) = ANY ('{"\\\\x0800000112","\\\\x080000011c"}'::byt
- ea[])) THEN t1._date_time ELSE t1._fld19407 END, t1._fld19408, t1._fld19409, CASE WHEN (('\\x08'::bytea || t1._documenttref) = '\\x080000010f'::bytea) THEN CASE WHEN (t1._documenttref = '\\x0000010f'::bytea) THE
- N t1._documentrref ELSE NULL::bytea END ELSE NULL::bytea END, CASE WHEN (('\\x08'::bytea || t1._documenttref) = '\\x0800000125'::bytea) THEN CASE WHEN (t1._documenttref = '\\x00000125'::bytea) THEN t1._documentr
- ref ELSE NULL::bytea END ELSE NULL::bytea END, CASE WHEN ((t2._fld19510_type IS NULL) AND (t2._fld19510_rtref IS NULL) AND (t2._fld19510_rrref IS NULL)) THEN false ELSE true END, CASE WHEN (CASE WHEN (('\\x08'::
- bytea || t1._documenttref) = ANY ('{"\\\\x0800000112","\\\\x080000011c"}'::bytea[])) THEN t1._date_time ELSE t1._fld19407 END IS NULL) THEN '0001-01-01 00:00:00'::timestamp without time zone ELSE CASE WHEN (('\\
- x08'::bytea || t1._documenttref) = ANY ('{"\\\\x0800000112","\\\\x080000011c"}'::bytea[])) THEN t1._date_time ELSE t1._fld19407 END END
- Join Filter: (t15._fld8558rref = t29._idrref)
- Rows Removed by Join Filter: 4527975
- Buffers: shared hit=15702849
- -> Nested Loop Left Join (cost=0.86..37136987.28 rows=10850 width=613) (actual time=102.587..1735224.509 rows=16709 loops=1)
- Output: t1._documenttref, t1._documentrref, t1._date_time, t1._marked, t1._number, t1._posted, t1._fld19396rref, t1._fld19397rref, t1._fld19398rref, t1._fld19399rref, t1._fld19400rref, t1._f
- ld19401, t1._fld19402, t1._fld19403, t1._fld19404, t1._fld19405rref, t1._fld19406, t1._fld19407, t1._fld19408, t1._fld19409, t2._fld19510_type, t2._fld19510_rtref, t2._fld19510_rrref, t4._fld7675rref, t13._owner
- idrref, t15._fld8558rref, t24._owneridrref, t25._description, t26._description, t27._description, t28._description
- Join Filter: (t24._owneridrref = t28._idrref)
- Rows Removed by Join Filter: 166723
- Buffers: shared hit=15702841
- -> Nested Loop Left Join (cost=0.86..37135358.63 rows=10850 width=573) (actual time=102.494..1734703.090 rows=16709 loops=1)
- Output: t1._documenttref, t1._documentrref, t1._date_time, t1._marked, t1._number, t1._posted, t1._fld19396rref, t1._fld19397rref, t1._fld19398rref, t1._fld19399rref, t1._fld19400rref,
- t1._fld19401, t1._fld19402, t1._fld19403, t1._fld19404, t1._fld19405rref, t1._fld19406, t1._fld19407, t1._fld19408, t1._fld19409, t2._fld19510_type, t2._fld19510_rtref, t2._fld19510_rrref, t4._fld7675rref, t13.
- _owneridrref, t15._fld8558rref, t24._owneridrref, t25._description, t26._description, t27._description
- Buffers: shared hit=15702840
- -> Nested Loop Left Join (cost=0.57..37130723.55 rows=10850 width=529) (actual time=102.470..1734317.986 rows=16709 loops=1)
- Output: t1._documenttref, t1._documentrref, t1._date_time, t1._marked, t1._number, t1._posted, t1._fld19396rref, t1._fld19397rref, t1._fld19398rref, t1._fld19399rref, t1._fld1940
- 0rref, t1._fld19401, t1._fld19402, t1._fld19403, t1._fld19404, t1._fld19405rref, t1._fld19406, t1._fld19407, t1._fld19408, t1._fld19409, t2._fld19510_type, t2._fld19510_rtref, t2._fld19510_rrref, t4._fld7675rref
- , t13._owneridrref, t15._fld8558rref, t24._owneridrref, t25._description, t26._description
- Join Filter: (t4._fld7675rref = t26._idrref)
- Rows Removed by Join Filter: 4528138
- Buffers: shared hit=15655040
- -> Nested Loop Left Join (cost=0.57..37086606.24 rows=10850 width=478) (actual time=101.097..1723083.329 rows=16709 loops=1)
- Output: t1._documenttref, t1._documentrref, t1._date_time, t1._marked, t1._number, t1._posted, t1._fld19396rref, t1._fld19397rref, t1._fld19398rref, t1._fld19399rref, t1._f
- ld19400rref, t1._fld19401, t1._fld19402, t1._fld19403, t1._fld19404, t1._fld19405rref, t1._fld19406, t1._fld19407, t1._fld19408, t1._fld19409, t2._fld19510_type, t2._fld19510_rtref, t2._fld19510_rrref, t4._fld76
- 75rref, t13._owneridrref, t15._fld8558rref, t24._owneridrref, t25._description
- Join Filter: (t13._owneridrref = t25._idrref)
- Rows Removed by Join Filter: 166734
- Buffers: shared hit=15655032
- -> Nested Loop Left Join (cost=0.57..37084977.59 rows=10850 width=438) (actual time=101.015..1722561.005 rows=16709 loops=1)
- Output: t1._documenttref, t1._documentrref, t1._date_time, t1._marked, t1._number, t1._posted, t1._fld19396rref, t1._fld19397rref, t1._fld19398rref, t1._fld19399rref,
- t1._fld19400rref, t1._fld19401, t1._fld19402, t1._fld19403, t1._fld19404, t1._fld19405rref, t1._fld19406, t1._fld19407, t1._fld19408, t1._fld19409, t2._fld19510_type, t2._fld19510_rtref, t2._fld19510_rrref, t4.
- _fld7675rref, t13._owneridrref, t15._fld8558rref, t24._owneridrref
- Join Filter: (t15._fld8557rref = t24._idrref)
- Rows Removed by Join Filter: 283686
- Buffers: shared hit=15655031
- -> Nested Loop Left Join (cost=0.57..37082208.58 rows=10850 width=438) (actual time=100.893..1721736.180 rows=16709 loops=1)
- Output: t1._documenttref, t1._documentrref, t1._date_time, t1._marked, t1._number, t1._posted, t1._fld19396rref, t1._fld19397rref, t1._fld19398rref, t1._fld1939
- 9rref, t1._fld19400rref, t1._fld19401, t1._fld19402, t1._fld19403, t1._fld19404, t1._fld19405rref, t1._fld19406, t1._fld19407, t1._fld19408, t1._fld19409, t2._fld19510_type, t2._fld19510_rtref, t2._fld19510_rrre
- f, t4._fld7675rref, t13._owneridrref, t15._fld8558rref, t15._fld8557rref
- Join Filter: (t1._documenttref = '\\x00000125'::bytea)
- Buffers: shared hit=15655029
- -> Nested Loop Left Join (cost=0.29..18573159.52 rows=10850 width=398) (actual time=100.872..865717.496 rows=16709 loops=1)
- Output: t1._documenttref, t1._documentrref, t1._date_time, t1._marked, t1._number, t1._posted, t1._fld19396rref, t1._fld19397rref, t1._fld19398rref, t1._f
- ld19399rref, t1._fld19400rref, t1._fld19401, t1._fld19402, t1._fld19403, t1._fld19404, t1._fld19405rref, t1._fld19406, t1._fld19407, t1._fld19408, t1._fld19409, t2._fld19510_type, t2._fld19510_rtref, t2._fld1951
- 0_rrref, t4._fld7675rref, t13._owneridrref
- Join Filter: (t4._fld20006rref = t13._idrref)
- Rows Removed by Join Filter: 283697
- Buffers: shared hit=7934064
- -> Nested Loop Left Join (cost=0.29..18570390.51 rows=10850 width=398) (actual time=100.750..864884.422 rows=16709 loops=1)
- Output: t1._documenttref, t1._documentrref, t1._date_time, t1._marked, t1._number, t1._posted, t1._fld19396rref, t1._fld19397rref, t1._fld19398rref,
- t1._fld19399rref, t1._fld19400rref, t1._fld19401, t1._fld19402, t1._fld19403, t1._fld19404, t1._fld19405rref, t1._fld19406, t1._fld19407, t1._fld19408, t1._fld19409, t2._fld19510_type, t2._fld19510_rtref, t2._f
- ld19510_rrref, t4._fld7675rref, t4._fld20006rref
- Join Filter: (t1._documenttref = '\\x0000010f'::bytea)
- Buffers: shared hit=7934062
- -> Nested Loop Left Join (cost=0.00..61943.87 rows=10850 width=358) (actual time=1.410..11726.491 rows=16709 loops=1)
- Output: t1._documenttref, t1._documentrref, t1._date_time, t1._marked, t1._number, t1._posted, t1._fld19396rref, t1._fld19397rref, t1._fld1939
- 8rref, t1._fld19399rref, t1._fld19400rref, t1._fld19401, t1._fld19402, t1._fld19403, t1._fld19404, t1._fld19405rref, t1._fld19406, t1._fld19407, t1._fld19408, t1._fld19409, t2._fld19510_type, t2._fld19510_rtref,
- t2._fld19510_rrref
- Join Filter: ((t1._documenttref = t2._fld19510_rtref) AND (t1._documentrref = t2._fld19510_rrref))
- Rows Removed by Join Filter: 4411096
- Buffers: shared hit=5550
- -> Seq Scan on public._documentjournal19395 t1 (cost=0.00..11809.25 rows=10850 width=325) (actual time=0.024..364.714 rows=16709 loops=1)
- Output: t1._documenttref, t1._documentrref, t1._date_time, t1._marked, t1._posted, t1._number, t1._fld19396rref, t1._fld19397rref, t1._f
- ld19398rref, t1._fld19399rref, t1._fld19400rref, t1._fld19401, t1._fld19402, t1._fld19403, t1._fld19404, t1._fld19405rref, t1._fld19406, t1._fld19407, t1._fld19408, t1._fld19409, t1._fld22098, t1._fld594
- Filter: ((t1._fld594 = '0'::numeric) AND (t1._fld19396rref = ANY ('{"\\\\x00000000000000000000000000000000","\\\\x80c800155d015e0c11e362
- 3b661edf66","\\\\x80c800155d015e0c11e3623ba6d4caa8","\\\\x80c800155d015e0c11e3623bd0fa48f6","\\\\x80c800155d015e0c11e363b69e76f7aa","\\\\x940700155d015e0211e330d57c23aa7c","\\\\x940700155d015e0211e33a18832501ea"
- ,"\\\\xa2a600155d01020011e30a98bb9efd34","\\\\xade23ddf89b5fc144d4950ebc25a7969","\\\\xbfe800155d01020011e2da35dff21aa6","\\\\xbfe800155d01020011e2de0abf3b3e4a"}'::bytea[])) AND (((t1._fld19407 >= '2015-01-01 00
- :00:00'::timestamp without time zone) AND (t1._fld19407 <= '2016-12-31 23:59:59'::timestamp without time zone)) OR (t1._fld19407 = '0001-01-01 00:00:00'::timestamp without time zone) OR ((('\\x08'::bytea || t1._
- documenttref) = ANY ('{"\\\\x0800000112","\\\\x080000011c"}'::bytea[])) AND (t1._fld19399rref = ANY ('{"\\\\x8d5c68908eab219641a5b74f39b63e72","\\\\x99dae30f78c67d3c4853e5208ed431c8"}'::bytea[])) AND (t1._date_t
- ime >= '2015-01-01 00:00:00'::timestamp without time zone) AND (t1._date_time <= '2016-12-31 23:59:59'::timestamp without time zone))))
- Rows Removed by Filter: 118691
- Buffers: shared hit=5547
- -> Materialize (cost=0.00..8.28 rows=264 width=33) (actual time=0.002..0.315 rows=264 loops=16709)
- Output: t2._fld19510_type, t2._fld19510_rtref, t2._fld19510_rrref
- Buffers: shared hit=3
- -> Seq Scan on public._inforg19509 t2 (cost=0.00..6.96 rows=264 width=33) (actual time=0.014..0.421 rows=264 loops=1)
- Output: t2._fld19510_type, t2._fld19510_rtref, t2._fld19510_rrref
- Filter: (('\\x08'::bytea = t2._fld19510_type) AND (t2._fld594 = '0'::numeric))
- Buffers: shared hit=3
- -> Index Scan using _document271hpk on public._document271 t4 (cost=0.29..1705.84 rows=1 width=60) (actual time=51.051..51.052 rows=0 loops=16709)
- Output: t4._idrref, t4._version, t4._marked, t4._date_time, t4._numberprefix, t4._number, t4._posted, t4._fld7659rref, t4._fld7660rref, t4._fl
- d7661rref, t4._fld7662rref, t4._fld7663, t4._fld7664rref, t4._fld7665rref, t4._fld20006rref, t4._fld20007rref, t4._fld7666, t4._fld7667, t4._fld7668, t4._fld7669rref, t4._fld7670, t4._fld7671rref, t4._fld7672_ty
- pe, t4._fld7672_rtref, t4._fld7672_rrref, t4._fld7673rref, t4._fld7674, t4._fld7675rref, t4._fld7676rref, t4._fld14397rref, t4._fld14398_type, t4._fld14398_rtref, t4._fld14398_rrref, t4._fld20008, t4._fld20009,
- t4._fld20010_type, t4._fld20010_rtref, t4._fld20010_rrref, t4._fld20011, t4._fld20012, t4._fld21929, t4._fld21930, t4._fld21931, t4._fld21932, t4._fld21933, t4._fld21934, t4._fld21935, t4._fld21936, t4._fld594,
- t4._fld18552, t4._fld18553, t4._fld18565
- Index Cond: ((t4._fld594 = '0'::numeric) AND (t1._documentrref = t4._idrref))
- Filter: (SubPlan 6)
- Buffers: shared hit=7928512
- SubPlan 6
- -> Result (cost=1704.16..1705.31 rows=1 width=0) (actual time=103.086..103.086 rows=1 loops=8272)
- One-Time Filter: $11
- Buffers: shared hit=7886714
- InitPlan 5 (returns $11)
- -> Nested Loop Semi Join (cost=1.64..1703.87 rows=1 width=0) (actual time=103.062..103.062 rows=1 loops=8272)
- Buffers: shared hit=7870126
- -> Nested Loop (cost=1.09..1700.95 rows=1 width=40) (actual time=99.455..101.667 rows=59 loops=8272)
- Output: t8._fld11330rref, t7._idrref
- Buffers: shared hit=5684176
- -> Merge Join (cost=0.82..1697.83 rows=1 width=20) (actual time=99.401..99.811 rows=62 loops=8272)
- Output: t8._fld11330rref
- Merge Cond: (t8._fld11329rref = t6._idrref)
- Buffers: shared hit=2589141
- -> Index Only Scan using _inforg11328_bydims_rr on public._inforg11328 t8 (cost=0.41..1550.82 rows=58109 width=4
- 0) (actual time=0.022..52.882 rows=37542 loops=8272)
- Output: t8._fld594, t8._fld11329rref, t8._fld11330rref
- Index Cond: (t8._fld594 = '0'::numeric)
- Heap Fetches: 0
- Buffers: shared hit=2564321
- -> Index Only Scan using _reference83_byfield1973_sr on public._reference83 t6 (cost=0.41..1.52 rows=1 width=20)
- (actual time=0.020..0.099 rows=1 loops=8272)
- Output: t6._fld1964, t6._idrref
- Index Cond: (t6._fld1964 = 'Документ.ПоступлениеБезналичныхДенежныхСредств'::mvarchar)
- Heap Fetches: 0
- Buffers: shared hit=24820
- -> Index Only Scan using _reference60hpk on public._reference60 t7 (cost=0.27..3.11 rows=1 width=20) (actual time=0.02
- 3..0.025 rows=1 loops=514460)
- Output: t7._fld594, t7._idrref
- Index Cond: ((t7._fld594 = '0'::numeric) AND (t7._idrref = t8._fld11330rref))
- Filter: (CASE WHEN (alternatives: SubPlan 1 or hashed SubPlan 2) THEN true ELSE false END = CASE WHEN (alternative
- s: SubPlan 3 or hashed SubPlan 4) THEN true ELSE false END)
- Rows Removed by Filter: 0
- Heap Fetches: 0
- Buffers: shared hit=3095035
- SubPlan 1
- -> Index Only Scan using _inforg17071_bydims_rr on public._inforg17071 t11 (cost=0.28..1.40 rows=1 width=0) (a
- ctual time=0.006..0.006 rows=0 loops=514460)
- Index Cond: ((t11._fld594 = '0'::numeric) AND (t11._fld17072rref = t7._idrref) AND (t11._fld17073_type = '
- \\x08'::bytea) AND (t11._fld17073_rtref = '\\x00000243'::bytea) AND (t11._fld17073_rrref = t4._fld7662rref))
- Heap Fetches: 0
- Buffers: shared hit=1028921
- SubPlan 2
- -> Index Only Scan using _inforg17071_bydims17075_rr on public._inforg17071 t11_1 (cost=0.28..1.40 rows=1 widt
- h=20) (never executed)
- Output: t11_1._fld17072rref
- Index Cond: ((t11_1._fld594 = '0'::numeric) AND (t11_1._fld17073_type = '\\x08'::bytea) AND (t11_1._fld170
- 73_rtref = '\\x00000243'::bytea) AND (t11_1._fld17073_rrref = t4._fld7662rref))
- Heap Fetches: 0
- SubPlan 3
- -> Index Only Scan using _inforg17078_byresource17085_lrr on public._inforg17078 t12 (cost=0.28..1.41 rows=1 w
- idth=0) (actual time=0.007..0.007 rows=0 loops=514460)
- Index Cond: ((t12._fld594 = '0'::numeric) AND (t12._fld17081 = false) AND (t12._fld17079rref = t7._idrref)
- AND (t12._fld17080_type = '\\x08'::bytea) AND (t12._fld17080_rtref = '\\x00000243'::bytea))
- Filter: (NOT t12._fld17081)
- Heap Fetches: 0
- Buffers: shared hit=1037193
- SubPlan 4
- -> Index Only Scan using _inforg17078_byresource17085_lrr on public._inforg17078 t12_1 (cost=0.28..24.93 rows=
- 33 width=20) (never executed)
- Output: t12_1._fld17079rref
- Index Cond: ((t12_1._fld594 = '0'::numeric) AND (t12_1._fld17081 = false) AND (t12_1._fld17080_type = '\\x
- 08'::bytea) AND (t12_1._fld17080_rtref = '\\x00000243'::bytea))
- Filter: (NOT t12_1._fld17081)
- Heap Fetches: 0
- -> Nested Loop (cost=0.55..1.73 rows=1 width=20) (actual time=0.021..0.021 rows=0 loops=491785)
- Output: t9._reference60_idrref
- Buffers: shared hit=2185950
- -> Index Scan using _reference60_vt1565_intkeyind on public._reference60_vt1565 t9 (cost=0.28..0.36 rows=4 width=53) (
- actual time=0.006..0.007 rows=1 loops=491785)
- Output: t9._reference60_idrref, t9._fld594, t9._keyfield, t9._lineno1566, t9._fld1567_type, t9._fld1567_rtref, t9.
- _fld1567_rrref
- Index Cond: ((t9._fld594 = '0'::numeric) AND (t9._reference60_idrref = t8._fld11330rref))
- Buffers: shared hit=1334731
- -> Index Only Scan using _inforg11255_bydims_rr on public._inforg11255 t10 (cost=0.28..0.33 rows=1 width=33) (actual t
- ime=0.009..0.009 rows=0 loops=425609)
- Output: t10._fld594, t10._fld11256_type, t10._fld11256_rtref, t10._fld11256_rrref, t10._fld11257_type, t10._fld112
- 57_rtref, t10._fld11257_rrref
- Index Cond: ((t10._fld594 = '0'::numeric) AND (t10._fld11256_type = t9._fld1567_type) AND (t10._fld11256_rtref = t
- 9._fld1567_rtref) AND (t10._fld11256_rrref = t9._fld1567_rrref) AND (t10._fld11257_type = '\\x08'::bytea) AND (t10._fld11257_rtref = '\\x0000007f'::bytea) AND (t10._fld11257_rrref = '\\xbfe800155d01020011e2da570
- e57e56c'::bytea))
- Heap Fetches: 0
- Buffers: shared hit=851219
- -> Nested Loop Left Join (cost=1704.16..1705.31 rows=1 width=0) (actual time=0.018..0.018 rows=1 loops=8272)
- Buffers: shared hit=16588
- -> Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=8272)
- Output: NULL::integer
- -> Index Only Scan using _document271_vt7677_intkeyind on public._document271_vt7677 t5 (cost=0.29..1.40 rows=1 width=0) (actu
- al time=0.010..0.010 rows=1 loops=8272)
- Output: t5._fld594, t5._document271_idrref, t5._keyfield
- Index Cond: ((t5._fld594 = t4._fld594) AND (t5._document271_idrref = t4._idrref))
- Heap Fetches: 0
- Buffers: shared hit=16588
- -> Materialize (cost=0.00..2.30 rows=17 width=40) (actual time=0.002..0.022 rows=17 loops=16709)
- Output: t13._owneridrref, t13._idrref
- Buffers: shared hit=2
- -> Seq Scan on public._reference35 t13 (cost=0.00..2.21 rows=17 width=40) (actual time=0.014..0.051 rows=17 loops=1)
- Output: t13._owneridrref, t13._idrref
- Filter: (t13._fld594 = '0'::numeric)
- Buffers: shared hit=2
- -> Index Scan using _document293hpk on public._document293 t15 (cost=0.29..1705.89 rows=1 width=60) (actual time=51.222..51.223 rows=0 loops=16709)
- Output: t15._idrref, t15._version, t15._marked, t15._date_time, t15._numberprefix, t15._number, t15._posted, t15._fld8578, t15._fld8555rref, t15._fld8561,
- t15._fld8553rref, t15._fld8579, t15._fld8550rref, t15._fld8565, t15._fld8557rref, t15._fld20052rref, t15._fld8558rref, t15._fld8559rref, t15._fld8560rref, t15._fld8554, t15._fld8562rref, t15._fld8563rref, t15._
- fld8556rref, t15._fld8551rref, t15._fld8566, t15._fld8567rref, t15._fld8568, t15._fld8575, t15._fld8569, t15._fld8570, t15._fld8571, t15._fld8572, t15._fld8573, t15._fld8574, t15._fld8576, t15._fld8577, t15._fld
- 8564, t15._fld8552rref, t15._fld8580rref, t15._fld8581rref, t15._fld8582, t15._fld8583, t15._fld8584rref, t15._fld8585, t15._fld8586, t15._fld14407rref, t15._fld14408_type, t15._fld14408_rtref, t15._fld14408_rrr
- ef, t15._fld17890, t15._fld17283, t15._fld19070, t15._fld19071_type, t15._fld19071_rtref, t15._fld19071_rrref, t15._fld20053, t15._fld20054, t15._fld20055rref, t15._fld22045, t15._fld22046, t15._fld22047, t15._f
- ld22048, t15._fld22049, t15._fld22050, t15._fld22051, t15._fld22052, t15._fld22053, t15._fld22054, t15._fld22055, t15._fld23356, t15._fld23357, t15._fld23358, t15._fld23359rref, t15._fld23360, t15._fld594
- Index Cond: ((t15._fld594 = '0'::numeric) AND (t1._documentrref = t15._idrref))
- Filter: (SubPlan 12)
- Buffers: shared hit=7720965
- SubPlan 12
- -> Result (cost=1704.16..1705.31 rows=1 width=0) (actual time=107.477..107.477 rows=1 loops=7961)
- One-Time Filter: $23
- Buffers: shared hit=7679432
- InitPlan 11 (returns $23)
- -> Nested Loop Semi Join (cost=1.64..1703.87 rows=1 width=0) (actual time=107.452..107.452 rows=1 loops=7961)
- Buffers: shared hit=7663468
- -> Nested Loop (cost=1.09..1700.95 rows=1 width=40) (actual time=103.892..106.076 rows=59 loops=7961)
- Output: t19._fld11330rref, t18._idrref
- Buffers: shared hit=5558055
- -> Merge Join (cost=0.82..1697.83 rows=1 width=20) (actual time=103.836..104.240 rows=62 loops=7961)
- Output: t19._fld11330rref
- Merge Cond: (t19._fld11329rref = t17._idrref)
- Buffers: shared hit=2587327
- -> Index Only Scan using _inforg11328_bydims_rr on public._inforg11328 t19 (cost=0.41..1550.82 rows=58109 width=40) (actual
- time=0.023..54.982 rows=38998 loops=7961)
- Output: t19._fld594, t19._fld11329rref, t19._fld11330rref
- Index Cond: (t19._fld594 = '0'::numeric)
- Heap Fetches: 0
- Buffers: shared hit=2563443
- -> Index Only Scan using _reference83_byfield1973_sr on public._reference83 t17 (cost=0.41..1.52 rows=1 width=20) (actual ti
- me=0.020..0.099 rows=1 loops=7961)
- Output: t17._fld1964, t17._idrref
- Index Cond: (t17._fld1964 = 'Документ.СписаниеБезналичныхДенежныхСредств'::mvarchar)
- Heap Fetches: 0
- Buffers: shared hit=23884
- -> Index Only Scan using _reference60hpk on public._reference60 t18 (cost=0.27..3.11 rows=1 width=20) (actual time=0.023..0.024 ro
- ws=1 loops=493794)
- Output: t18._fld594, t18._idrref
- Index Cond: ((t18._fld594 = '0'::numeric) AND (t18._idrref = t19._fld11330rref))
- Filter: (CASE WHEN (alternatives: SubPlan 7 or hashed SubPlan 8) THEN true ELSE false END = CASE WHEN (alternatives: SubPlan 9
- or hashed SubPlan 10) THEN true ELSE false END)
- Rows Removed by Filter: 0
- Heap Fetches: 0
- Buffers: shared hit=2970728
- SubPlan 7
- -> Index Only Scan using _inforg17071_bydims_rr on public._inforg17071 t22 (cost=0.28..1.40 rows=1 width=0) (actual time=0
- .006..0.006 rows=0 loops=493794)
- Index Cond: ((t22._fld594 = '0'::numeric) AND (t22._fld17072rref = t18._idrref) AND (t22._fld17073_type = '\\x08'::byt
- ea) AND (t22._fld17073_rtref = '\\x00000243'::bytea) AND (t22._fld17073_rrref = t15._fld8553rref))
- Heap Fetches: 0
- Buffers: shared hit=987589
- SubPlan 8
- -> Index Only Scan using _inforg17071_bydims17075_rr on public._inforg17071 t22_1 (cost=0.28..1.40 rows=1 width=20) (never
- executed)
- Output: t22_1._fld17072rref
- Index Cond: ((t22_1._fld594 = '0'::numeric) AND (t22_1._fld17073_type = '\\x08'::bytea) AND (t22_1._fld17073_rtref = '
- \\x00000243'::bytea) AND (t22_1._fld17073_rrref = t15._fld8553rref))
- Heap Fetches: 0
- SubPlan 9
- -> Index Only Scan using _inforg17078_byresource17085_lrr on public._inforg17078 t23 (cost=0.28..1.41 rows=1 width=0) (act
- ual time=0.007..0.007 rows=0 loops=493794)
- Index Cond: ((t23._fld594 = '0'::numeric) AND (t23._fld17081 = false) AND (t23._fld17079rref = t18._idrref) AND (t23._
- fld17080_type = '\\x08'::bytea) AND (t23._fld17080_rtref = '\\x00000243'::bytea))
- Filter: (NOT t23._fld17081)
- Heap Fetches: 0
- Buffers: shared hit=995550
- SubPlan 10
- -> Index Only Scan using _inforg17078_byresource17085_lrr on public._inforg17078 t23_1 (cost=0.28..24.93 rows=33 width=20)
- (never executed)
- Output: t23_1._fld17079rref
- Index Cond: ((t23_1._fld594 = '0'::numeric) AND (t23_1._fld17081 = false) AND (t23_1._fld17080_type = '\\x08'::bytea)
- AND (t23_1._fld17080_rtref = '\\x00000243'::bytea))
- Filter: (NOT t23_1._fld17081)
- Heap Fetches: 0
- -> Nested Loop (cost=0.55..1.73 rows=1 width=20) (actual time=0.020..0.020 rows=0 loops=473625)
- Output: t20._reference60_idrref
- Buffers: shared hit=2105413
- -> Index Scan using _reference60_vt1565_intkeyind on public._reference60_vt1565 t20 (cost=0.28..0.36 rows=4 width=53) (actual time
- =0.006..0.007 rows=1 loops=473625)
- Output: t20._reference60_idrref, t20._fld594, t20._keyfield, t20._lineno1566, t20._fld1567_type, t20._fld1567_rtref, t20._fld1
- 567_rrref
- Index Cond: ((t20._fld594 = '0'::numeric) AND (t20._reference60_idrref = t19._fld11330rref))
- Buffers: shared hit=1285538
- -> Index Only Scan using _inforg11255_bydims_rr on public._inforg11255 t21 (cost=0.28..0.33 rows=1 width=33) (actual time=0.009..0
- .009 rows=0 loops=409937)
- Output: t21._fld594, t21._fld11256_type, t21._fld11256_rtref, t21._fld11256_rrref, t21._fld11257_type, t21._fld11257_rtref, t2
- 1._fld11257_rrref
- Index Cond: ((t21._fld594 = '0'::numeric) AND (t21._fld11256_type = t20._fld1567_type) AND (t21._fld11256_rtref = t20._fld1567
- _rtref) AND (t21._fld11256_rrref = t20._fld1567_rrref) AND (t21._fld11257_type = '\\x08'::bytea) AND (t21._fld11257_rtref = '\\x0000007f'::bytea) AND (t21._fld11257_rrref = '\\xbfe800155d01020011e2da570e57e56c':
- :bytea))
- Heap Fetches: 0
- Buffers: shared hit=819875
- -> Nested Loop Left Join (cost=1704.16..1705.31 rows=1 width=0) (actual time=0.018..0.018 rows=1 loops=7961)
- Buffers: shared hit=15964
- -> Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=7961)
- Output: NULL::integer
- -> Index Only Scan using _document293_vt8590_intkeyind on public._document293_vt8590 t16 (cost=0.29..1.41 rows=1 width=0) (actual time=0.0
- 10..0.010 rows=1 loops=7961)
- Output: t16._fld594, t16._document293_idrref, t16._keyfield
- Index Cond: ((t16._fld594 = t15._fld594) AND (t16._document293_idrref = t15._idrref))
- Heap Fetches: 0
- Buffers: shared hit=15964
- -> Materialize (cost=0.00..2.30 rows=17 width=40) (actual time=0.002..0.021 rows=17 loops=16709)
- Output: t24._owneridrref, t24._idrref
- Buffers: shared hit=2
- -> Seq Scan on public._reference35 t24 (cost=0.00..2.21 rows=17 width=40) (actual time=0.009..0.041 rows=17 loops=1)
- Output: t24._owneridrref, t24._idrref
- Filter: (t24._fld594 = '0'::numeric)
- Buffers: shared hit=2
- -> Materialize (cost=0.00..1.18 rows=10 width=60) (actual time=0.001..0.013 rows=10 loops=16709)
- Output: t25._description, t25._idrref
- Buffers: shared hit=1
- -> Seq Scan on public._reference117 t25 (cost=0.00..1.12 rows=10 width=60) (actual time=0.011..0.034 rows=10 loops=1)
- Output: t25._description, t25._idrref
- Filter: (t25._fld594 = '0'::numeric)
- Buffers: shared hit=1
- -> Materialize (cost=0.00..12.74 rows=271 width=71) (actual time=0.001..0.319 rows=271 loops=16709)
- Output: t26._description, t26._idrref
- Buffers: shared hit=8
- -> Seq Scan on public._reference196 t26 (cost=0.00..11.39 rows=271 width=71) (actual time=0.011..0.438 rows=271 loops=1)
- Output: t26._description, t26._idrref
- Filter: (t26._fld594 = '0'::numeric)
- Buffers: shared hit=8
- -> Index Scan using _reference97hpk on public._reference97 t27 (cost=0.29..0.42 rows=1 width=64) (actual time=0.013..0.015 rows=1 loops=16709)
- Output: t27._idrref, t27._version, t27._marked, t27._predefinedid, t27._description, t27._fld2153, t27._fld14291, t27._fld2155rref, t27._fld20157rref, t27._fld14292rref, t27._fld
- 2156, t27._fld2157, t27._fld2161, t27._fld2158rref, t27._fld2154rref, t27._fld18204, t27._fld2160, t27._fld20158, t27._fld594, t27._fld18552, t27._fld18553
- Index Cond: ((t27._fld594 = '0'::numeric) AND (t1._fld19400rref = t27._idrref))
- Buffers: shared hit=47800
- -> Materialize (cost=0.00..1.18 rows=10 width=60) (actual time=0.002..0.013 rows=10 loops=16709)
- Output: t28._description, t28._idrref
- Buffers: shared hit=1
- -> Seq Scan on public._reference117 t28 (cost=0.00..1.12 rows=10 width=60) (actual time=0.010..0.045 rows=10 loops=1)
- Output: t28._description, t28._idrref
- Filter: (t28._fld594 = '0'::numeric)
- Buffers: shared hit=1
- -> Materialize (cost=0.00..12.74 rows=271 width=71) (actual time=0.002..0.315 rows=271 loops=16709)
- Output: t29._description, t29._idrref
- Buffers: shared hit=8
- -> Seq Scan on public._reference196 t29 (cost=0.00..11.39 rows=271 width=71) (actual time=0.008..0.393 rows=271 loops=1)
- Output: t29._description, t29._idrref
- Filter: (t29._fld594 = '0'::numeric)
- Buffers: shared hit=8
- Planning time: 30.975 ms
- Execution time: 1746959.333 ms
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
