Guest User

Untitled

a guest
Feb 21st, 2020
38
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. explain analyze select
  2.     eventrisks0_.id as col_0_0_
  3. from
  4.     EVENTRISKS eventrisks0_
  5. inner join PROJECTRISKS eventrisks0_1_ on
  6.     eventrisks0_.id = eventrisks0_1_.id
  7. inner join RESULTINDICATOREVENTEXECUTION resultindi1_ on
  8.     eventrisks0_.RESULTINDICATOREVENTEXECUTION = resultindi1_.version_meta_id
  9.     and ((/*'versioning_where_condition_begin'*/
  10.     tsrange(resultindi1_.version_actual_period_start,
  11.     resultindi1_.version_actual_period_end,
  12.     '[]') @> clock_timestamp() at time zone 'utc'
  13.     and not resultindi1_.version_is_deleted
  14.     and true /*'versioning_where_condition_end'*/
  15.     ))
  16. inner join FPRESULTEXECUTION resultindi1_1_ on
  17.     resultindi1_.id = resultindi1_1_.id
  18. where
  19.     (eventrisks0_.RESULTINDICATOREVENTEXECUTION is not null)
  20.     and (resultindi1_.FPRESULTSEXECUTION is not null)
  21.     and (exists (
  22.     select
  23.         fpresultse2_.version_meta_id
  24.     from
  25.         FPRESULTSEXECUTION fpresultse2_
  26.     inner join FPRESULTEXECUTION fpresultse2_1_ on
  27.         fpresultse2_.id = fpresultse2_1_.id
  28.     inner join RESULTS results3_ on
  29.         fpresultse2_.RESULT = results3_.version_meta_id
  30.         and ((/*'versioning_where_condition_begin'*/
  31.         tsrange(results3_.version_actual_period_start,
  32.         results3_.version_actual_period_end,
  33.         '[]') @> clock_timestamp() at time zone 'utc'
  34.         and not results3_.version_is_deleted
  35.         and true /*'versioning_where_condition_end'*/
  36.         ))
  37.     inner join TASKS tasks4_ on
  38.         results3_.TASK = tasks4_.version_meta_id
  39.         and ((/*'versioning_where_condition_begin'*/
  40.         tsrange(tasks4_.version_actual_period_start,
  41.         tasks4_.version_actual_period_end,
  42.         '[]') @> clock_timestamp() at time zone 'utc'
  43.         and not tasks4_.version_is_deleted
  44.         and true /*'versioning_where_condition_end'*/
  45.         ))
  46.         where ( (/*'versioning_where_condition_begin'*/
  47.         tsrange(fpresultse2_1_.version_actual_period_start,
  48.         fpresultse2_1_.version_actual_period_end,
  49.         '[]') @> clock_timestamp() at time zone 'utc'
  50.         and not fpresultse2_1_.version_is_deleted
  51.         and true /*'versioning_where_condition_end'*/
  52.         ))
  53.         and tasks4_.PROJECTVERSION =2135
  54.         and (fpresultse2_.version_meta_id = resultindi1_.FPRESULTSEXECUTION
  55.         or (fpresultse2_.version_meta_id is null)
  56.         and (resultindi1_.FPRESULTSEXECUTION is null))))
Advertisement
Add Comment
Please, Sign In to add comment