explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rJ1

Settings
# exclusive inclusive rows x rows loops node
1. 0.034 872.421 ↓ 1.2 12 1

Limit (cost=0.56..210.19 rows=10 width=5,457) (actual time=129.373..872.421 rows=12 loops=1)

  • Output: t_0.name, t_0.id, t_0.object_type_id, 'cmis:item'::text, t_0.created_by, t_0.creation_date, t_0.last_modified_by, t_0.last_modification_date, t_0.change_token, t_0.description, t_0.secondary_object_type_ids, ((t_0.properties -> 'nvlt:status'::text)), ((t_0.properties -> 'nvlt:processInstanceId'::text)), (numenvault.to_timestamp(((t_0.properties -> 'nvlt:startDate'::text))::character varying)), (numenvault.to_timestamp(((t_0.properties -> 'nvlt:endDate'::text))::character varying)), (((t_0.properties -> 'nvlt:duration'::text))::numeric), (numenvault.to_timestamp(((t_0.properties -> 'nvlt:dueDate'::text))::character varying)), (((t_0.properties -> 'nvlt:priority'::text))::bigint), (((t_0.properties -> 'nvlt:processedQuantity'::text))::numeric), (((t_0.properties -> 'nvlt:totalQuantity'::text))::numeric), ((t_0.properties -> 'nvlt:unitOfWork'::text)), ((t_0.properties -> 'nvlt:objectId'::text)), ((t_0.properties -> 'nvlt:comment'::text)), ((t_0.properties -> 'nvlt:temporaryData'::text)), ((t_0.properties -> 'nvlt:wfEngineId'::text)), ((t_0.properties -> 'nvlt:wfEngineTaskDefId'::text)), ((t_0.properties -> 'nvlt:wfEngineTaskInstId'::text)), ((t_0.properties -> 'nvlt:wfEngineData'::text)), ((t_0.properties -> 'nvlt:switchCode'::text)), (((t_0.properties -> 'nvlt:idleDuration'::text))::numeric), (((t_0.properties -> 'nvlt:workingDuration'::text))::numeric), (numenvault.to_array_of_text((t_0.properties -> 'nvlt:candidatePrincipals'::text))), ((t_0.properties -> 'nvlt:assignee'::text)), (((t_0.properties -> 'nvlt:toolStartDuration'::text))::numeric), (((t_0.properties -> 'nvlt:toolEndDuration'::text))::numeric), (((t_0.properties -> 'nvlt:isInWorkBatch'::text))::boolean), ((t_0.properties -> 'nvlt:jobFunctionName'::text)), ((t_0.properties -> 'nvlt:jobFunctionParameters'::text)), (((t_0.properties -> 'nvlt:workerProcessId'::text))::bigint), (((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean), ((t_0.properties -> 'rncs:masterWorkItemId'::text)), ((t_0.properties -> 'rncs:masterObjectId'::text)), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), ((t_0.properties -> 'mada:masterBatch'::text)), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), ((t_0.properties -> 'mada:gpaoId'::text)), (((t_0.properties -> 'wi:linkedToWb'::text))::boolean), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), ((t_0.properties -> 'mada:masterBatch'::text)), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), ((t_0.properties -> 'wi:typeTraitement'::text)), (((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean), ((t_0.properties -> 'wi:idLotCQ'::text)), (((t_0.properties -> 'wi:resultatCQ'::text))::boolean), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), ((t_0.properties -> 'mada:masterBatch'::text)), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), ((t_0.properties -> 'mada:gpaoId'::text)), (((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), ((t_0.properties -> 'mada:masterBatch'::text)), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), ((t_0.properties -> 'mada:gpaoId'::text)), (((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), ((t_0.properties -> 'mada:masterBatch'::text)), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), ((t_0.properties -> 'mada:gpaoId'::text)), (numenvault.to_array_of_text((t_0.properties -> 'nvlt:workItemIds'::text))), ((t_0.properties -> 'nvlt:workItemObjectTypeId'::text)), ((t_0.properties -> 'nvlt:gpaoId'::text)), (((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), ((t_0.properties -> 'mada:masterBatch'::text)), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), ((t_0.properties -> 'mada:gpaoId'::text)), ((t_0.properties -> 'rncs:masterObjectId'::text)), ((t_0.properties -> 'rncs:masterWorkItemId'::text)), (((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), ((t_0.properties -> 'mada:masterBatch'::text)), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), ((t_0.properties -> 'mada:gpaoId'::text)), (((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), ((t_0.properties -> 'mada:masterBatch'::text)), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), ((t_0.properties -> 'mada:gpaoId'::text)), (((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), ((t_0.properties -> 'mada:masterBatch'::text)), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), ((t_0.properties -> 'mada:gpaoId'::text)), (((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), ((t_0.properties -> 'mada:masterBatch'::text)), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), ((t_0.properties -> 'mada:gpaoId'::text)), (((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), ((t_0.properties -> 'mada:masterBatch'::text)), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), ((t_0.properties -> 'mada:gpaoId'::text)), (((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), ((t_0.properties -> 'mada:masterBatch'::text)), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), ((t_0.properties -> 'mada:gpaoId'::text)), (((t_0.properties -> 'wi:linkedToWb'::text))::boolean), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), ((t_0.properties -> 'mada:masterBatch'::text)), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), ((t_0.properties -> 'wi:typeTraitement'::text)), ((t_0.properties -> 'wi:idLotCQ'::text)), (((t_0.properties -> 'wi:resultatCQ'::text))::boolean), (((t_0.properties -> 'wi:liasseOK'::text))::boolean), (((t_0.properties -> 'wi:linkedToWb'::text))::boolean), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), ((t_0.properties -> 'mada:masterBatch'::text)), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), ((t_0.properties -> 'wi:typeTraitement'::text)), (((t_0.properties -> 'wi:linkedToWb'::text))::boolean), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), ((t_0.properties -> 'mada:masterBatch'::text)), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), ((t_0.properties -> 'wi:typeTraitement'::text)), (((t_0.properties -> 'wi:linkedToWb'::text))::boolean), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), ((t_0.properties -> 'mada:masterBatch'::text)), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), ((t_0.properties -> 'wi:typeTraitement'::text)), (((t_0.properties -> 'wi:linkedToWb'::text))::boolean), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), ((t_0.properties -> 'mada:masterBatch'::text)), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), ((t_0.properties -> 'wi:typeTraitement'::text)), (((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), ((t_0.properties -> 'mada:masterBatch'::text)), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), ((t_0.properties -> 'mada:gpaoId'::text)), (((t_0.properties -> 'wi:linkedToWb'::text))::boolean), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), ((t_0.properties -> 'mada:masterBatch'::text)), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), ((t_0.properties -> 'wi:typeTraitement'::text)), ((t_0.properties -> 'rncs:siren'::text)), ((t_0.properties -> 'rncs:masterWorkItemId'::text)), (((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean), ((t_0.properties -> 'rncs:masterObjectId'::text)), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), ((t_0.properties -> 'mada:gpaoId'::text)), ((t_0.properties -> 'mada:masterBatch'::text)), (((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), ((t_0.properties -> 'mada:masterBatch'::text)), ((t_0.properties -> 'mada:gpaoId'::text)), (((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), ((t_0.properties -> 'mada:gpaoId'::text)), ((t_0.properties -> 'mada:masterBatch'::text)), ((t_0.properties -> 'rncs:masterObjectId'::text)), ((t_0.properties -> 'rncs:masterWorkItemId'::text)), (((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), ((t_0.properties -> 'mada:masterBatch'::text)), ((t_0.properties -> 'mada:gpaoId'::text)), ((t_0.properties -> 'mada:masterBatch'::text)), ((t_0.properties -> 'wi:typeTraitement'::text)), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), (((t_0.properties -> 'wi:linkedToWb'::text))::boolean), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), ((t_0.properties -> 'mada:masterBatch'::text)), (((t_0.properties -> 'wi:linkedToWb'::text))::boolean), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), ((t_0.properties -> 'wi:typeTraitement'::text)), (((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), ((t_0.properties -> 'mada:masterBatch'::text)), ((t_0.properties -> 'mada:gpaoId'::text)), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), (((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), ((t_0.properties -> 'mada:gpaoId'::text)), ((t_0.properties -> 'mada:masterBatch'::text)), ((t_0.properties -> 'mada:gpaoId'::text)), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), (((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), ((t_0.properties -> 'mada:masterBatch'::text)), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), (((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), ((t_0.properties -> 'mada:masterBatch'::text)), ((t_0.properties -> 'mada:gpaoId'::text)), ((t_0.properties -> 'wi:lotEnvoi'::text)), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), (((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), ((t_0.properties -> 'mada:masterBatch'::text)), ((t_0.properties -> 'mada:gpaoId'::text)), ((t_0.properties -> 'wi:lotEnvoi'::text)), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), ((t_0.properties -> 'rncs:masterObjectId'::text)), ((t_0.properties -> 'mada:masterBatch'::text)), (((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean), ((t_0.properties -> 'rncs:masterWorkItemId'::text)), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), ((t_0.properties -> 'mada:gpaoId'::text)), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), (((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean), ((t_0.properties -> 'mada:masterBatch'::text)), ((t_0.properties -> 'mada:gpaoId'::text)), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), ((t_0.properties -> 'mada:gpaoId'::text)), (((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean), ((t_0.properties -> 'mada:masterBatch'::text)), ((t_0.properties -> 'rncs:masterWorkItemId'::text)), ((t_0.properties -> 'rncs:masterObjectId'::text)), ((t_0.properties -> 'mada:masterBatch'::text)), (((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean), ((t_0.properties -> 'mada:gpaoId'::text)), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), ((t_0.properties -> 'wi:typeTraitement'::text)), (((t_0.properties -> 'wi:linkedToWb'::text))::boolean), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), ((t_0.properties -> 'mada:masterBatch'::text)), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), ((t_0.properties -> 'wi:typeTraitement'::text)), (((t_0.properties -> 'wi:linkedToWb'::text))::boolean), ((t_0.properties -> 'mada:masterBatch'::text)), (((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), ((t_0.properties -> 'mada:masterBatch'::text)), ((t_0.properties -> 'mada:gpaoId'::text)), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), (((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), ((t_0.properties -> 'mada:masterBatch'::text)), ((t_0.properties -> 'mada:gpaoId'::text)), (((t_0.properties -> 'wf:eventFlag'::text))::boolean), (((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean), (numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text))), ((t_0.properties -> 'mada:masterBatch'::text)), ((t_0.properties -> 'mada:gpaoId'::text)), (((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean), ((t_0.properties -> 'mada:masterBatch'::text))
  • Buffers: shared hit=19,822
2. 872.387 872.387 ↓ 1.2 12 1

Index Scan using idx_composite_object_item_1 on numenvault.object_item__work_patterns t_0 (cost=0.56..210.19 rows=10 width=5,457) (actual time=129.371..872.387 rows=12 loops=1)

  • Output: t_0.name, t_0.id, t_0.object_type_id, 'cmis:item'::text, t_0.created_by, t_0.creation_date, t_0.last_modified_by, t_0.last_modification_date, t_0.change_token, t_0.description, t_0.secondary_object_type_ids, (t_0.properties -> 'nvlt:status'::text), (t_0.properties -> 'nvlt:processInstanceId'::text), numenvault.to_timestamp(((t_0.properties -> 'nvlt:startDate'::text))::character varying), numenvault.to_timestamp(((t_0.properties -> 'nvlt:endDate'::text))::character varying), ((t_0.properties -> 'nvlt:duration'::text))::numeric, numenvault.to_timestamp(((t_0.properties -> 'nvlt:dueDate'::text))::character varying), ((t_0.properties -> 'nvlt:priority'::text))::bigint, ((t_0.properties -> 'nvlt:processedQuantity'::text))::numeric, ((t_0.properties -> 'nvlt:totalQuantity'::text))::numeric, (t_0.properties -> 'nvlt:unitOfWork'::text), (t_0.properties -> 'nvlt:objectId'::text), (t_0.properties -> 'nvlt:comment'::text), (t_0.properties -> 'nvlt:temporaryData'::text), (t_0.properties -> 'nvlt:wfEngineId'::text), (t_0.properties -> 'nvlt:wfEngineTaskDefId'::text), (t_0.properties -> 'nvlt:wfEngineTaskInstId'::text), (t_0.properties -> 'nvlt:wfEngineData'::text), (t_0.properties -> 'nvlt:switchCode'::text), ((t_0.properties -> 'nvlt:idleDuration'::text))::numeric, ((t_0.properties -> 'nvlt:workingDuration'::text))::numeric, numenvault.to_array_of_text((t_0.properties -> 'nvlt:candidatePrincipals'::text)), (t_0.properties -> 'nvlt:assignee'::text), ((t_0.properties -> 'nvlt:toolStartDuration'::text))::numeric, ((t_0.properties -> 'nvlt:toolEndDuration'::text))::numeric, ((t_0.properties -> 'nvlt:isInWorkBatch'::text))::boolean, (t_0.properties -> 'nvlt:jobFunctionName'::text), (t_0.properties -> 'nvlt:jobFunctionParameters'::text), ((t_0.properties -> 'nvlt:workerProcessId'::text))::bigint, ((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean, (t_0.properties -> 'rncs:masterWorkItemId'::text), (t_0.properties -> 'rncs:masterObjectId'::text), ((t_0.properties -> 'wf:eventFlag'::text))::boolean, (t_0.properties -> 'mada:masterBatch'::text), numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), (t_0.properties -> 'mada:gpaoId'::text), ((t_0.properties -> 'wi:linkedToWb'::text))::boolean, ((t_0.properties -> 'wf:eventFlag'::text))::boolean, (t_0.properties -> 'mada:masterBatch'::text), numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), (t_0.properties -> 'wi:typeTraitement'::text), ((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean, (t_0.properties -> 'wi:idLotCQ'::text), ((t_0.properties -> 'wi:resultatCQ'::text))::boolean, ((t_0.properties -> 'wf:eventFlag'::text))::boolean, (t_0.properties -> 'mada:masterBatch'::text), numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), (t_0.properties -> 'mada:gpaoId'::text), ((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean, ((t_0.properties -> 'wf:eventFlag'::text))::boolean, (t_0.properties -> 'mada:masterBatch'::text), numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), (t_0.properties -> 'mada:gpaoId'::text), ((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean, ((t_0.properties -> 'wf:eventFlag'::text))::boolean, (t_0.properties -> 'mada:masterBatch'::text), numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), (t_0.properties -> 'mada:gpaoId'::text), numenvault.to_array_of_text((t_0.properties -> 'nvlt:workItemIds'::text)), (t_0.properties -> 'nvlt:workItemObjectTypeId'::text), (t_0.properties -> 'nvlt:gpaoId'::text), ((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean, ((t_0.properties -> 'wf:eventFlag'::text))::boolean, (t_0.properties -> 'mada:masterBatch'::text), numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), (t_0.properties -> 'mada:gpaoId'::text), (t_0.properties -> 'rncs:masterObjectId'::text), (t_0.properties -> 'rncs:masterWorkItemId'::text), ((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean, ((t_0.properties -> 'wf:eventFlag'::text))::boolean, (t_0.properties -> 'mada:masterBatch'::text), numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), (t_0.properties -> 'mada:gpaoId'::text), ((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean, ((t_0.properties -> 'wf:eventFlag'::text))::boolean, (t_0.properties -> 'mada:masterBatch'::text), numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), (t_0.properties -> 'mada:gpaoId'::text), ((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean, ((t_0.properties -> 'wf:eventFlag'::text))::boolean, (t_0.properties -> 'mada:masterBatch'::text), numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), (t_0.properties -> 'mada:gpaoId'::text), ((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean, ((t_0.properties -> 'wf:eventFlag'::text))::boolean, (t_0.properties -> 'mada:masterBatch'::text), numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), (t_0.properties -> 'mada:gpaoId'::text), ((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean, ((t_0.properties -> 'wf:eventFlag'::text))::boolean, (t_0.properties -> 'mada:masterBatch'::text), numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), (t_0.properties -> 'mada:gpaoId'::text), ((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean, ((t_0.properties -> 'wf:eventFlag'::text))::boolean, (t_0.properties -> 'mada:masterBatch'::text), numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), (t_0.properties -> 'mada:gpaoId'::text), ((t_0.properties -> 'wi:linkedToWb'::text))::boolean, ((t_0.properties -> 'wf:eventFlag'::text))::boolean, (t_0.properties -> 'mada:masterBatch'::text), numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), (t_0.properties -> 'wi:typeTraitement'::text), (t_0.properties -> 'wi:idLotCQ'::text), ((t_0.properties -> 'wi:resultatCQ'::text))::boolean, ((t_0.properties -> 'wi:liasseOK'::text))::boolean, ((t_0.properties -> 'wi:linkedToWb'::text))::boolean, ((t_0.properties -> 'wf:eventFlag'::text))::boolean, (t_0.properties -> 'mada:masterBatch'::text), numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), (t_0.properties -> 'wi:typeTraitement'::text), ((t_0.properties -> 'wi:linkedToWb'::text))::boolean, ((t_0.properties -> 'wf:eventFlag'::text))::boolean, (t_0.properties -> 'mada:masterBatch'::text), numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), (t_0.properties -> 'wi:typeTraitement'::text), ((t_0.properties -> 'wi:linkedToWb'::text))::boolean, ((t_0.properties -> 'wf:eventFlag'::text))::boolean, (t_0.properties -> 'mada:masterBatch'::text), numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), (t_0.properties -> 'wi:typeTraitement'::text), ((t_0.properties -> 'wi:linkedToWb'::text))::boolean, ((t_0.properties -> 'wf:eventFlag'::text))::boolean, (t_0.properties -> 'mada:masterBatch'::text), numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), (t_0.properties -> 'wi:typeTraitement'::text), ((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean, ((t_0.properties -> 'wf:eventFlag'::text))::boolean, (t_0.properties -> 'mada:masterBatch'::text), numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), (t_0.properties -> 'mada:gpaoId'::text), ((t_0.properties -> 'wi:linkedToWb'::text))::boolean, ((t_0.properties -> 'wf:eventFlag'::text))::boolean, (t_0.properties -> 'mada:masterBatch'::text), numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), (t_0.properties -> 'wi:typeTraitement'::text), (t_0.properties -> 'rncs:siren'::text), (t_0.properties -> 'rncs:masterWorkItemId'::text), ((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean, (t_0.properties -> 'rncs:masterObjectId'::text), ((t_0.properties -> 'wf:eventFlag'::text))::boolean, numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), (t_0.properties -> 'mada:gpaoId'::text), (t_0.properties -> 'mada:masterBatch'::text), ((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean, ((t_0.properties -> 'wf:eventFlag'::text))::boolean, numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), (t_0.properties -> 'mada:masterBatch'::text), (t_0.properties -> 'mada:gpaoId'::text), ((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean, ((t_0.properties -> 'wf:eventFlag'::text))::boolean, numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), (t_0.properties -> 'mada:gpaoId'::text), (t_0.properties -> 'mada:masterBatch'::text), (t_0.properties -> 'rncs:masterObjectId'::text), (t_0.properties -> 'rncs:masterWorkItemId'::text), ((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean, ((t_0.properties -> 'wf:eventFlag'::text))::boolean, numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), (t_0.properties -> 'mada:masterBatch'::text), (t_0.properties -> 'mada:gpaoId'::text), (t_0.properties -> 'mada:masterBatch'::text), (t_0.properties -> 'wi:typeTraitement'::text), numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), ((t_0.properties -> 'wi:linkedToWb'::text))::boolean, ((t_0.properties -> 'wf:eventFlag'::text))::boolean, numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), (t_0.properties -> 'mada:masterBatch'::text), ((t_0.properties -> 'wi:linkedToWb'::text))::boolean, ((t_0.properties -> 'wf:eventFlag'::text))::boolean, (t_0.properties -> 'wi:typeTraitement'::text), ((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean, ((t_0.properties -> 'wf:eventFlag'::text))::boolean, numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), (t_0.properties -> 'mada:masterBatch'::text), (t_0.properties -> 'mada:gpaoId'::text), numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), ((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean, ((t_0.properties -> 'wf:eventFlag'::text))::boolean, (t_0.properties -> 'mada:gpaoId'::text), (t_0.properties -> 'mada:masterBatch'::text), (t_0.properties -> 'mada:gpaoId'::text), ((t_0.properties -> 'wf:eventFlag'::text))::boolean, ((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean, numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), (t_0.properties -> 'mada:masterBatch'::text), ((t_0.properties -> 'wf:eventFlag'::text))::boolean, ((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean, numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), (t_0.properties -> 'mada:masterBatch'::text), (t_0.properties -> 'mada:gpaoId'::text), (t_0.properties -> 'wi:lotEnvoi'::text), ((t_0.properties -> 'wf:eventFlag'::text))::boolean, ((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean, numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), (t_0.properties -> 'mada:masterBatch'::text), (t_0.properties -> 'mada:gpaoId'::text), (t_0.properties -> 'wi:lotEnvoi'::text), ((t_0.properties -> 'wf:eventFlag'::text))::boolean, (t_0.properties -> 'rncs:masterObjectId'::text), (t_0.properties -> 'mada:masterBatch'::text), ((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean, (t_0.properties -> 'rncs:masterWorkItemId'::text), numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), (t_0.properties -> 'mada:gpaoId'::text), ((t_0.properties -> 'wf:eventFlag'::text))::boolean, numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), ((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean, (t_0.properties -> 'mada:masterBatch'::text), (t_0.properties -> 'mada:gpaoId'::text), numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), ((t_0.properties -> 'wf:eventFlag'::text))::boolean, (t_0.properties -> 'mada:gpaoId'::text), ((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean, (t_0.properties -> 'mada:masterBatch'::text), (t_0.properties -> 'rncs:masterWorkItemId'::text), (t_0.properties -> 'rncs:masterObjectId'::text), (t_0.properties -> 'mada:masterBatch'::text), ((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean, (t_0.properties -> 'mada:gpaoId'::text), ((t_0.properties -> 'wf:eventFlag'::text))::boolean, numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), ((t_0.properties -> 'wf:eventFlag'::text))::boolean, (t_0.properties -> 'wi:typeTraitement'::text), ((t_0.properties -> 'wi:linkedToWb'::text))::boolean, numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), (t_0.properties -> 'mada:masterBatch'::text), ((t_0.properties -> 'wf:eventFlag'::text))::boolean, numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), (t_0.properties -> 'wi:typeTraitement'::text), ((t_0.properties -> 'wi:linkedToWb'::text))::boolean, (t_0.properties -> 'mada:masterBatch'::text), ((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean, numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), (t_0.properties -> 'mada:masterBatch'::text), (t_0.properties -> 'mada:gpaoId'::text), ((t_0.properties -> 'wf:eventFlag'::text))::boolean, ((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean, numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), (t_0.properties -> 'mada:masterBatch'::text), (t_0.properties -> 'mada:gpaoId'::text), ((t_0.properties -> 'wf:eventFlag'::text))::boolean, ((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean, numenvault.to_array_of_text((t_0.properties -> 'mada:lstObjectId'::text)), (t_0.properties -> 'mada:masterBatch'::text), (t_0.properties -> 'mada:gpaoId'::text), ((t_0.properties -> 'mada:isInjectedGPAO'::text))::boolean, (t_0.properties -> 'mada:masterBatch'::text)
  • Index Cond: (((t_0.object_type_id)::text = ANY ('{nvlt:baseWorkItem,nvlt:baseAutomaticWorkItem,nvlt:baseManualWorkItem,nvlt:job,wi:autoInjection,wi:manualPageClassification,wi:autoLiasseEchantillonnage,wi:autoLiasseCtrlIndexation,wi:autoPageClassification,wi:autoTelechargementBodacc,nvlt:workBatch,wi:autoImportBigSiren,wi:autoStructuration,wi:autoExport,wi:autoDocReperage,wi:autoDocIndexation,wi:autoLiasseConsolidation,wi:autoLiasseControlValidite,wi:autoGenerationLivrable,wi:manualLiasseControlValidite,wi:manualLiasseControlQualite,wi:manualLiasseCorrection,wi:manualDocReperage,wi:manualDocIndexation,wi:autoLiasseIndexation,wi:manualLiasseIndexation,wi:autoImportSiren,wi:autoImportBodacc,wi:autoInjectionRetraitement,wi:autoLiasseIndexationRetraitement,wi:autoGenerationLivrableRetraitement,wi:autoExportRetraitement,wi:manualLiasseCtrlRetraitement,wi:manualLiasseRetraitement,wi:autoLiasseCtrlIndexationRetraitement,wi:autoLiasseControlValiditeRetraitement,wi:autoLiasseAttenteStt,wi:autoLiasseTraitementStt,wi:autoLiasseRetraitementStt,wi:autoInjectionRetraitementCerfa2016,wi:autoDocCreationRetraitementCerfa2016,wi:autoConsolidationRetraitementCerfa2016,wi:autoExportRetraitementCerfa2016,wi:manualDocReperageRetraitementCerfa2016,wi:manualDocCtrlRetraitementCerfa2016,wi:autoDocReperageUpdate,wi:autoDocIndexationUpdate,wi:archive,wi:autoRefDeviseInjection,wi:autoTelechargementBigSiren,mada:workBatch}'::text[])) AND ((t_0.object_type_id)::text = 'wi:autoExport'::text) AND ((t_0.properties -> 'nvlt:status'::text) = 'FAILED'::text))
  • Filter: ((t_0.object_type_partition)::text = 'work_patterns'::text)
  • Buffers: shared hit=19,822
Planning time : 15.883 ms