Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- explain analyze select
- eventrisks0_.id as col_0_0_
- from
- EVENTRISKS eventrisks0_
- inner join PROJECTRISKS eventrisks0_1_ on
- eventrisks0_.id = eventrisks0_1_.id
- inner join RESULTINDICATOREVENTEXECUTION resultindi1_ on
- eventrisks0_.RESULTINDICATOREVENTEXECUTION = resultindi1_.version_meta_id
- and ((/*'versioning_where_condition_begin'*/
- tsrange(resultindi1_.version_actual_period_start,
- resultindi1_.version_actual_period_end,
- '[]') @> clock_timestamp() at time zone 'utc'
- and not resultindi1_.version_is_deleted
- and true /*'versioning_where_condition_end'*/
- ))
- inner join FPRESULTEXECUTION resultindi1_1_ on
- resultindi1_.id = resultindi1_1_.id
- where
- (eventrisks0_.RESULTINDICATOREVENTEXECUTION is not null)
- and (resultindi1_.FPRESULTSEXECUTION is not null)
- and (exists (
- select
- fpresultse2_.version_meta_id
- from
- FPRESULTSEXECUTION fpresultse2_
- inner join FPRESULTEXECUTION fpresultse2_1_ on
- fpresultse2_.id = fpresultse2_1_.id
- inner join RESULTS results3_ on
- fpresultse2_.RESULT = results3_.version_meta_id
- and ((/*'versioning_where_condition_begin'*/
- tsrange(results3_.version_actual_period_start,
- results3_.version_actual_period_end,
- '[]') @> clock_timestamp() at time zone 'utc'
- and not results3_.version_is_deleted
- and true /*'versioning_where_condition_end'*/
- ))
- inner join TASKS tasks4_ on
- results3_.TASK = tasks4_.version_meta_id
- and ((/*'versioning_where_condition_begin'*/
- tsrange(tasks4_.version_actual_period_start,
- tasks4_.version_actual_period_end,
- '[]') @> clock_timestamp() at time zone 'utc'
- and not tasks4_.version_is_deleted
- and true /*'versioning_where_condition_end'*/
- ))
- where ( (/*'versioning_where_condition_begin'*/
- tsrange(fpresultse2_1_.version_actual_period_start,
- fpresultse2_1_.version_actual_period_end,
- '[]') @> clock_timestamp() at time zone 'utc'
- and not fpresultse2_1_.version_is_deleted
- and true /*'versioning_where_condition_end'*/
- ))
- and tasks4_.PROJECTVERSION =2135
- and (fpresultse2_.version_meta_id = resultindi1_.FPRESULTSEXECUTION
- or (fpresultse2_.version_meta_id is null)
- and (resultindi1_.FPRESULTSEXECUTION is null))))
Advertisement
Add Comment
Please, Sign In to add comment