explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xhiB

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 1,597.557 ↑ 5.0 1 1

Nested Loop (cost=3,454.77..3,575.50 rows=5 width=720) (actual time=1,597.556..1,597.557 rows=1 loops=1)

2. 0.003 1,597.537 ↑ 1.2 4 1

Nested Loop (cost=3,454.62..3,574.67 rows=5 width=124) (actual time=1,597.389..1,597.537 rows=4 loops=1)

3. 0.140 1,597.504 ↑ 2.8 5 1

GroupAggregate (cost=3,454.20..3,454.73 rows=14 width=24) (actual time=1,597.366..1,597.504 rows=5 loops=1)

  • Group Key: t_1.name_id
4. 0.384 1,597.364 ↓ 31.9 1,244 1

Sort (cost=3,454.20..3,454.30 rows=39 width=16) (actual time=1,597.294..1,597.364 rows=1,244 loops=1)

  • Sort Key: t_1.name_id
  • Sort Method: quicksort Memory: 107kB
5. 0.700 1,596.980 ↓ 31.9 1,244 1

Nested Loop (cost=9.86..3,453.17 rows=39 width=16) (actual time=0.225..1,596.980 rows=1,244 loops=1)

  • Join Filter: ((m.dossier_ref)::text = (application.dossier_ref)::text)
6. 0.747 1,590.060 ↓ 31.9 1,244 1

Nested Loop (cost=9.45..3,435.45 rows=39 width=127) (actual time=0.208..1,590.060 rows=1,244 loops=1)

  • Join Filter: ((m.dossier_ref)::text = (dossier.uid)::text)
7. 52.680 1,583.093 ↓ 31.9 1,244 1

Hash Join (cost=9.03..3,417.85 rows=39 width=90) (actual time=0.195..1,583.093 rows=1,244 loops=1)

  • Hash Cond: (t_1.work_status_id = st.id)
8. 114.296 1,530.403 ↓ 140.0 770,396 1

Nested Loop (cost=0.86..3,394.80 rows=5,502 width=98) (actual time=0.065..1,530.403 rows=770,396 loops=1)

9. 5.777 14.564 ↓ 138.8 35,937 1

Nested Loop (cost=0.43..1,083.45 rows=259 width=37) (actual time=0.047..14.564 rows=35,937 loops=1)

10. 0.012 0.012 ↑ 1.0 1 1

Index Scan using ix_dossier_handling_type_value on dossier_handling_type ht (cost=0.14..8.16 rows=1 width=8) (actual time=0.011..0.012 rows=1 loops=1)

  • Index Cond: ((value)::text = 'Manual'::text)
11. 8.775 8.775 ↓ 2.0 35,937 1

Index Scan using ix_metadata_handling_id on metadata m (cost=0.29..893.86 rows=18,142 width=45) (actual time=0.034..8.775 rows=35,937 loops=1)

  • Index Cond: (handling_id = ht.id)
12. 1,401.543 1,401.543 ↑ 1.7 21 35,937

Index Scan using ix_manual_task_dossier_ref on manual_task t_1 (cost=0.42..8.57 rows=35 width=61) (actual time=0.009..0.039 rows=21 loops=35,937)

  • Index Cond: ((dossier_ref)::text = (m.dossier_ref)::text)
  • Filter: ((work_required_app_permission)::text = ANY ('{260_displayExternalSystemErrors,264_checkDocumentError,244_edit_expenses,042_readIncomeInformatio,252_editStatedLoans,020_addApplicant,047_readExpenseInformatio,141_editFraudIndicators,097_addRequiredStipulatio,223_editBankAccount,051_readBKRLoans,154_regenerateSignedDigitalContract,208_moveDocuments,189_viewEditingOverview,216_executeSampleCheck,253_decideBkrCheckNeeded,215_highImpactChangesEdit,095_consultStipulationDetails,053_readExistingLoans,222_withdrawApplicationWaitingForExternalSystem,022_updatePersonApplicant,108_consultExternalSourcesResults,043_updateIncomeInformatio,103_readStipulationVerifications,246_read_parties,158_rejectDocument,181_uploadInformatio,007_openApplicatio,089_assessDisbursements,214_mediumImpactChangesEdit,088_editDisbursements,239_handle_manual_tasks,110_consultNotes,100_updateVerifications,098_readStipulationDetails,117_makeManualFlatDecisio,233_remove_stipulatio,249_edit_incomes,002_consultOverview,018_consultInvolvedParties,118_overruleRejectio,017_consultProcessInformatio,240_claim_dossier,003_search,122_withdrawApplicatio,129_manageManualIdentityConfirmatio,045_manageExpenseInformatio,083_updateLoanDetails,169_confirmCrosscheckRejectio,056_connectExistingLoanToBkrLoa,104_uploadDocumentSca,224_manageRiskProfile,157_taskToCheckDocumentRejectedPolicy,209_consultCommunicationDetails,258_bkrStarManualScreenHomeTile,243_recalculate_max_loa,036_updateContactInformatio,213_lowImpactChangesEdit,155_consultTaskToCompleteDocumentExtraction,262_grossNetOnVkm,173_performManualBKRCheck,198_sendRejectionLetter,105_editDocumentValues,080_consultFinanceDetails,192_viewStatusBar,133_consultTaskScree,201_consultProposalConfirmatio,031_updateApplicantAddress,232_manageInterestDiscount,204_consultMessages,111_createNote,159_consultDossierAssessment,202_consultPurchaseDetails}'::text[]))
  • Rows Removed by Filter: 1
13. 0.004 0.010 ↑ 1.0 1 1

Hash (cost=8.16..8.16 rows=1 width=8) (actual time=0.010..0.010 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
14. 0.006 0.006 ↑ 1.0 1 1

Index Scan using ix_task_status_type_value on task_status_type st (cost=0.14..8.16 rows=1 width=8) (actual time=0.005..0.006 rows=1 loops=1)

  • Index Cond: ((value)::text = 'To do'::text)
15. 6.220 6.220 ↑ 1.0 1 1,244

Index Scan using ix_dossier_uid on dossier (cost=0.41..0.44 rows=1 width=37) (actual time=0.005..0.005 rows=1 loops=1,244)

  • Index Cond: ((uid)::text = (t_1.dossier_ref)::text)
  • Filter: (lock_token IS NULL)
16. 6.220 6.220 ↑ 1.0 1 1,244

Index Only Scan using ix_application_dossier_ref on application (cost=0.41..0.44 rows=1 width=37) (actual time=0.005..0.005 rows=1 loops=1,244)

  • Index Cond: (dossier_ref = (t_1.dossier_ref)::text)
  • Heap Fetches: 1244
17. 0.030 0.030 ↑ 1.0 1 5

Index Scan using ix_manual_task_updated_date on manual_task t (cost=0.42..8.55 rows=1 width=108) (actual time=0.006..0.006 rows=1 loops=5)

  • Index Cond: (updated_date = (min(t_1.updated_date)))
  • Filter: (t_1.name_id = name_id)
18. 0.016 0.016 ↓ 0.0 0 4

Index Scan using pk_task_name on task_name tn (cost=0.14..0.17 rows=1 width=524) (actual time=0.004..0.004 rows=0 loops=4)

  • Index Cond: (id = t.name_id)
  • Filter: ((value)::text <> ALL ('{"Repair document","Assess referred document","Assess document rejection","Check document error"}'::text[]))
  • Rows Removed by Filter: 1
Planning time : 2.647 ms
Execution time : 1,597.682 ms