explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8YnF

Settings
# exclusive inclusive rows x rows loops node
1. 12.586 21,976.768 ↓ 0.0 0 1

Insert on tmp_tbl_kst_tbl_def789207dfc4d908aada03103e31fd2 (cost=27,441.84..27,441.91 rows=4 width=326) (actual time=21,976.768..21,976.768 rows=0 loops=1)

2. 11.879 21,964.182 ↓ 686.5 2,746 1

Subquery Scan on *SELECT* (cost=27,441.84..27,441.91 rows=4 width=326) (actual time=21,959.751..21,964.182 rows=2,746 loops=1)

3. 10.238 21,952.303 ↓ 686.5 2,746 1

Sort (cost=27,441.84..27,441.85 rows=4 width=322) (actual time=21,951.710..21,952.303 rows=2,746 loops=1)

  • Sort Key: "tDate"."CreationDateTime" DESC NULLS LAST
  • Sort Method: quicksort Memory: 1507kB
4. 9.222 21,942.065 ↓ 686.5 2,746 1

Nested Loop Left Join (cost=6.23..27,441.70 rows=4 width=322) (actual time=13.523..21,942.065 rows=2,746 loops=1)

5. 8.472 16,287.067 ↓ 686.5 2,746 1

Nested Loop Left Join (cost=5.80..27,439.54 rows=4 width=330) (actual time=0.564..16,287.067 rows=2,746 loops=1)

6. 6.167 16,262.119 ↓ 686.5 2,746 1

Nested Loop Left Join (cost=5.53..27,438.38 rows=4 width=330) (actual time=0.552..16,262.119 rows=2,746 loops=1)

7. 4.679 15,929.178 ↓ 915.3 2,746 1

Nested Loop Left Join (cost=5.38..27,433.21 rows=3 width=314) (actual time=0.458..15,929.178 rows=2,746 loops=1)

8. 6.143 15,680.105 ↓ 1,373.0 2,746 1

Nested Loop Left Join (cost=5.23..27,429.77 rows=2 width=314) (actual time=0.231..15,680.105 rows=2,746 loops=1)

9. 6.307 15,660.232 ↓ 1,373.0 2,746 1

Nested Loop Left Join (cost=4.96..27,429.19 rows=2 width=314) (actual time=0.223..15,660.232 rows=2,746 loops=1)

10. 6.506 15,626.465 ↓ 1,373.0 2,746 1

Nested Loop Left Join (cost=4.53..27,428.13 rows=2 width=298) (actual time=0.210..15,626.465 rows=2,746 loops=1)

11. 9.051 15,589.753 ↓ 1,373.0 2,746 1

Nested Loop Left Join (cost=4.10..27,427.16 rows=2 width=282) (actual time=0.198..15,589.753 rows=2,746 loops=1)

12. 6.394 13,562.392 ↓ 1,373.0 2,746 1

Nested Loop Left Join (cost=3.67..27,426.18 rows=2 width=266) (actual time=0.169..13,562.392 rows=2,746 loops=1)

13. 8.434 8,777.958 ↓ 1,373.0 2,746 1

Nested Loop Left Join (cost=3.24..27,425.09 rows=2 width=250) (actual time=0.143..8,777.958 rows=2,746 loops=1)

14. 9.169 8,753.048 ↓ 1,373.0 2,746 1

Nested Loop (cost=2.96..27,424.49 rows=2 width=250) (actual time=0.134..8,753.048 rows=2,746 loops=1)

  • Join Filter: ("Inst"."InstanceID" = "tDate"."InstanceID")
15. 7.094 2,150.733 ↓ 1,373.0 2,746 1

Nested Loop Left Join (cost=2.39..27,422.81 rows=2 width=242) (actual time=0.102..2,150.733 rows=2,746 loops=1)

16. 7.375 2,127.163 ↓ 1,373.0 2,746 1

Nested Loop Left Join (cost=2.11..27,422.21 rows=2 width=242) (actual time=0.093..2,127.163 rows=2,746 loops=1)

17. 6.495 2,108.804 ↓ 1,373.0 2,746 1

Nested Loop Left Join (cost=1.84..27,421.63 rows=2 width=242) (actual time=0.083..2,108.804 rows=2,746 loops=1)

18. 7.387 81.253 ↓ 1,373.0 2,746 1

Nested Loop (cost=1.27..27,406.61 rows=2 width=226) (actual time=0.052..81.253 rows=2,746 loops=1)

19. 7.803 46.406 ↓ 343.2 2,746 1

Nested Loop (cost=0.84..27,359.88 rows=8 width=66) (actual time=0.038..46.406 rows=2,746 loops=1)

20. 5.651 5.651 ↑ 1.2 2,746 1

Index Scan using dvsys_search_results_data_1442_pkey on dvsys_search_results_data_1442 (cost=0.28..172.07 rows=3,186 width=18) (actual time=0.018..5.651 rows=2,746 loops=1)

21. 32.952 32.952 ↑ 1.0 1 2,746

Index Scan using dvsys_instances_pk_instanceid on dvsys_instances "Inst" (cost=0.56..8.53 rows=1 width=48) (actual time=0.012..0.012 rows=1 loops=2,746)

  • Index Cond: ("InstanceID" = dvsys_search_results_data_1442."CardID")
  • Filter: ((NOT COALESCE("Deleted", false)) AND (COALESCE(("ArchiveState")::integer, 0) = 0))
22. 27.460 27.460 ↑ 1.0 1 2,746

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 time=0.010..0.010 rows=1 loops=2,746)

  • Index Cond: ("InstanceID" = "Inst"."InstanceID")
23. 2,021.056 2,021.056 ↓ 0.0 0 2,746

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 time=0.736..0.736 rows=0 loops=2,746)

  • Index Cond: (("InstanceID" = "Inst"."InstanceID") AND ("UserID" = '22b8005a-eb94-4892-880b-c284eda80d40'::uuid))
  • Heap Fetches: 237
24. 10.984 10.984 ↑ 1.0 1 2,746

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 time=0.004..0.004 rows=1 loops=2,746)

  • Index Cond: ("RowID" = "Main"."Kind")
  • Heap Fetches: 2746
25. 16.476 16.476 ↑ 1.0 1 2,746

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 time=0.006..0.006 rows=1 loops=2,746)

  • Index Cond: ("RowID" = "Main"."Author")
  • Heap Fetches: 2746
26. 6,593.146 6,593.146 ↑ 1.0 1 2,746

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

  • Index Cond: ("InstanceID" = "Main"."InstanceID")
27. 16.476 16.476 ↑ 1.0 1 2,746

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 time=0.006..0.006 rows=1 loops=2,746)

  • Index Cond: ("RowID" = "Main"."Appointed")
  • Heap Fetches: 2746
28. 4,778.040 4,778.040 ↑ 1.0 1 2,746

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 time=1.740..1.740 rows=1 loops=2,746)

  • Index Cond: ("InstanceID" = "Main"."InstanceID")
29. 2,018.310 2,018.310 ↑ 1.0 1 2,746

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 time=0.735..0.735 rows=1 loops=2,746)

  • Index Cond: ("InstanceID" = "Main"."Resolution")
30. 30.206 30.206 ↑ 1.0 1 2,746

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=32) (actual time=0.011..0.011 rows=1 loops=2,746)

  • Index Cond: ("InstanceID" = "Main"."RegCard")
31. 27.460 27.460 ↑ 1.0 1 2,746

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 time=0.010..0.010 rows=1 loops=2,746)

  • Index Cond: ("InstanceID" = "Main"."RegCard")
32. 13.730 13.730 ↑ 1.0 1 2,746

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 time=0.005..0.005 rows=1 loops=2,746)

  • Index Cond: ("RowID" = "_CardRegistration_RegistrationData"."Kind")
  • Heap Fetches: 2746
33. 244.394 244.394 ↓ 0.0 0 2,746

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 time=0.089..0.089 rows=0 loops=2,746)

  • Index Cond: ("ParentRowID" = "System_2"."State")
  • Filter: (("LocaleID")::sql_variant = '(7,,,,,,,1049,)'::sql_variant)
  • Rows Removed by Filter: 1
34. 326.774 326.774 ↓ 0.0 0 2,746

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 time=0.119..0.119 rows=0 loops=2,746)

  • Index Cond: ("ParentRowID" = "System_1"."State")
  • Filter: (("LocaleID")::sql_variant = '(7,,,,,,,1049,)'::sql_variant)
  • Rows Removed by Filter: 1
35. 16.476 16.476 ↑ 1.0 1 2,746

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 time=0.006..0.006 rows=1 loops=2,746)

  • Index Cond: ("RowID" = "Main"."Urgency")
  • Heap Fetches: 2498
36. 5,645.776 5,645.776 ↓ 0.0 0 2,746

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 time=2.056..2.056 rows=0 loops=2,746)

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