explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8uJN

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Insert on tmp_tbl_kst_tbl_6c46eb330504410b9faa616f730906b5 (cost=4,295,583.17..4,295,583.22 rows=3 width=326) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* (cost=4,295,583.17..4,295,583.22 rows=3 width=326) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Sort (cost=4,295,583.17..4,295,583.18 rows=3 width=322) (actual rows= loops=)

  • Sort Key: "tDate"."CreationDateTime" DESC NULLS LAST
4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=6.11..4,295,583.07 rows=3 width=322) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=5.68..4,295,579.94 rows=3 width=334) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=5.41..4,295,579.07 rows=3 width=334) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=5.26..4,295,575.63 rows=2 width=318) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=5.11..4,295,573.91 rows=1 width=318) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=4.83..4,295,573.62 rows=1 width=318) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=4.40..4,295,573.09 rows=1 width=302) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=3.97..4,295,572.60 rows=1 width=282) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=3.54..4,295,572.06 rows=1 width=266) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=3.11..4,295,571.57 rows=1 width=250) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.83..4,295,571.27 rows=1 width=250) (actual rows= loops=)

  • Join Filter: ("Inst"."InstanceID" = "tDate"."InstanceID")
15. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=2.27..4,295,570.43 rows=1 width=242) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.99..4,295,570.14 rows=1 width=242) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.71..4,295,569.84 rows=1 width=242) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.15..4,295,562.33 rows=1 width=226) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.99..4,093,059.72 rows=16,151 width=208) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Index Scan using dvsys_instances_pk_instanceid on dvsys_instances "Inst" (cost=0.56..3,653,615.97 rows=75,235 width=48) (actual rows= loops=)

  • Filter: ((NOT COALESCE("Deleted", false)) AND (COALESCE(("ArchiveState")::integer, 0) = 0))
21. 0.000 0.000 ↓ 0.0

Index Scan using dvsys_cardtask_taskdata_uc_struct on "dvtable_{794e3a56-36f4-4a48-ac56-4ce21c794e26}" "Main" (cost=0.43..5.84 rows=1 width=160) (actual rows= loops=)

  • Index Cond: ("InstanceID" = "Inst"."InstanceID")
22. 0.000 0.000 ↓ 0.0

Index Scan using dvsys_search_results_data_idx_resultid_cardid on dvsys_search_results_data (cost=0.15..12.46 rows=8 width=18) (actual rows= loops=)

  • Index Cond: ("CardID" = "Inst"."InstanceID")
23. 0.000 0.000 ↓ 0.0

Index Only Scan using dvsys_instances_read_pk_instanceid_userid on dvsys_instances_read "tInstRead" (cost=0.56..7.51 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (("InstanceID" = "Inst"."InstanceID") AND ("UserID" = '439525f2-6e1e-469c-ab73-12f46180246c'::uuid))
24. 0.000 0.000 ↓ 0.0

Index Only Scan using dvsys_refstaff_employees_pk_rowid on "dvtable_{dbc8ae9d-c1d2-4d5e-978b-339d22b32482}" "_RefStaff_Employees" (cost=0.28..0.30 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ("RowID" = "Main"."Author")
25. 0.000 0.000 ↓ 0.0

Index Only Scan using dvsys_refkinds_cardkinds_pk_rowid on "dvtable_{c7ba000c-6203-4d7f-8c6b-5cb6f1e6f851}" "_RefKinds_CardKinds" (cost=0.27..0.29 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ("RowID" = "Main"."Kind")
26. 0.000 0.000 ↓ 0.0

Index Scan using dvsys_instances_date_pk_instanceid on dvsys_instances_date "tDate" (cost=0.56..0.83 rows=1 width=24) (actual rows= loops=)

  • Index Cond: ("InstanceID" = "Main"."InstanceID")
27. 0.000 0.000 ↓ 0.0

Index Only Scan using dvsys_refstaff_employees_pk_rowid on "dvtable_{dbc8ae9d-c1d2-4d5e-978b-339d22b32482}" "_RefStaff_Employees1" (cost=0.28..0.30 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ("RowID" = "Main"."Appointed")
28. 0.000 0.000 ↓ 0.0

Index Scan using dvsys_cardresolutio_system_uc_struct on "dvtable_{5c94dfaa-3431-4775-9093-8d7fe53a3042}" "System_2" (cost=0.43..0.49 rows=1 width=48) (actual rows= loops=)

  • Index Cond: ("InstanceID" = "Main"."Resolution")
29. 0.000 0.000 ↓ 0.0

Index Scan using dvsys_cardtask_system_uc_struct on "dvtable_{45b77db4-f692-46ee-86e4-1e3dac177d7c}" "System_1" (cost=0.43..0.54 rows=1 width=48) (actual rows= loops=)

  • Index Cond: ("InstanceID" = "Main"."InstanceID")
30. 0.000 0.000 ↓ 0.0

Index Scan using dvsys_cardregistration_ddmsystem_uc_struct on "dvtable_{88e884fd-5fd2-4f8f-a8cf-53cb50a8c085}" "DDMSystem_1" (cost=0.43..0.49 rows=1 width=36) (actual rows= loops=)

  • Index Cond: ("InstanceID" = "Main"."RegCard")
31. 0.000 0.000 ↓ 0.0

Index Scan using dvsys_cardregistration_registrationdata_uc_struct on "dvtable_{f9d3ef11-a060-415a-be69-da9efd3ca436}" "_CardRegistration_RegistrationData" (cost=0.43..0.53 rows=1 width=48) (actual rows= loops=)

  • Index Cond: ("InstanceID" = "Main"."RegCard")
32. 0.000 0.000 ↓ 0.0

Index Only Scan using dvsys_refkinds_cardkinds_pk_rowid on "dvtable_{c7ba000c-6203-4d7f-8c6b-5cb6f1e6f851}" "CardKinds_1" (cost=0.27..0.29 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ("RowID" = "_CardRegistration_RegistrationData"."Kind")
33. 0.000 0.000 ↓ 0.0

Index Scan using dvsys_refrolemodel_statenames_section on "dvtable_{da37ca71-a977-48e9-a4fd-a2b30479e824}" "StateNames_2" (cost=0.15..1.70 rows=2 width=32) (actual rows= loops=)

  • Index Cond: ("ParentRowID" = "System_2"."State")
  • Filter: (("LocaleID")::sql_variant = '(7,,,,,,,1049,)'::sql_variant)
34. 0.000 0.000 ↓ 0.0

Index Scan using dvsys_refrolemodel_statenames_section on "dvtable_{da37ca71-a977-48e9-a4fd-a2b30479e824}" "StateNames_1" (cost=0.15..1.70 rows=2 width=32) (actual rows= loops=)

  • Index Cond: ("ParentRowID" = "System_1"."State")
  • Filter: (("LocaleID")::sql_variant = '(7,,,,,,,1049,)'::sql_variant)
35. 0.000 0.000 ↓ 0.0

Index Only Scan using dvsys_refuniversal_item_pk_rowid on "dvtable_{dd20bf9b-90f8-4d9a-9553-5b5f17ad724e}" "_RefUniversal_Item" (cost=0.27..0.29 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ("RowID" = "Main"."Urgency")
36. 0.000 0.000 ↓ 0.0

Index Only Scan using dvsys_cardresolutio_parts_pk_rowid on "dvtable_{1f6ef15c-c274-4029-8959-877479f7a29a}" "Parts_1" (cost=0.43..0.52 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ("RowID" = "Main"."ParentPart")