explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Teu6

Settings
# exclusive inclusive rows x rows loops node
1. 1.863 3,593.047 ↓ 0.0 0 1

Insert on tmp_tbl_kst_tbl_6c46eb330504410b9faa616f730906b5 (cost=15,278.49..15,278.54 rows=3 width=326) (actual time=3,593.047..3,593.047 rows=0 loops=1)

2. 21.201 3,591.184 ↓ 210.3 631 1

Subquery Scan on *SELECT* (cost=15,278.49..15,278.54 rows=3 width=326) (actual time=3,590.378..3,591.184 rows=631 loops=1)

3. 1.987 3,569.983 ↓ 210.3 631 1

Sort (cost=15,278.49..15,278.49 rows=3 width=322) (actual time=3,569.888..3,569.983 rows=631 loops=1)

  • Sort Key: "tDate"."CreationDateTime" DESC NULLS LAST
  • Sort Method: quicksort Memory: 286kB
4. 45.012 3,567.996 ↓ 210.3 631 1

Nested Loop Left Join (cost=6.23..15,278.39 rows=3 width=322) (actual time=0.700..3,567.996 rows=631 loops=1)

5. 0.921 3,076.236 ↓ 210.3 631 1

Nested Loop Left Join (cost=5.80..15,275.26 rows=3 width=334) (actual time=0.560..3,076.236 rows=631 loops=1)

6. 0.997 3,072.791 ↓ 210.3 631 1

Nested Loop Left Join (cost=5.53..15,274.39 rows=3 width=334) (actual time=0.539..3,072.791 rows=631 loops=1)

7. 0.864 3,015.635 ↓ 315.5 631 1

Nested Loop Left Join (cost=5.38..15,270.95 rows=2 width=318) (actual time=0.259..3,015.635 rows=631 loops=1)

8. 1.028 3,014.771 ↓ 631.0 631 1

Nested Loop Left Join (cost=5.23..15,269.22 rows=1 width=318) (actual time=0.256..3,014.771 rows=631 loops=1)

9. 1.198 3,011.850 ↓ 631.0 631 1

Nested Loop Left Join (cost=4.96..15,268.93 rows=1 width=318) (actual time=0.249..3,011.850 rows=631 loops=1)

10. 1.076 3,005.604 ↓ 631.0 631 1

Nested Loop Left Join (cost=4.53..15,268.40 rows=1 width=302) (actual time=0.228..3,005.604 rows=631 loops=1)

11. 1.314 2,996.956 ↓ 631.0 631 1

Nested Loop Left Join (cost=4.10..15,267.92 rows=1 width=282) (actual time=0.215..2,996.956 rows=631 loops=1)

12. 0.906 2,287.660 ↓ 631.0 631 1

Nested Loop Left Join (cost=3.66..15,267.37 rows=1 width=266) (actual time=0.175..2,287.660 rows=631 loops=1)

13. 1.253 2,286.754 ↓ 631.0 631 1

Nested Loop Left Join (cost=3.23..15,266.88 rows=1 width=250) (actual time=0.164..2,286.754 rows=631 loops=1)

14. 0.998 2,282.977 ↓ 631.0 631 1

Nested Loop (cost=2.95..15,266.58 rows=1 width=250) (actual time=0.145..2,282.977 rows=631 loops=1)

  • Join Filter: ("Inst"."InstanceID" = "tDate"."InstanceID")
15. 0.647 532.847 ↓ 631.0 631 1

Nested Loop Left Join (cost=2.39..15,265.74 rows=1 width=242) (actual time=0.114..532.847 rows=631 loops=1)

16. 1.374 530.307 ↓ 631.0 631 1

Nested Loop Left Join (cost=2.12..15,265.45 rows=1 width=242) (actual time=0.104..530.307 rows=631 loops=1)

17. 0.854 526.409 ↓ 631.0 631 1

Nested Loop Left Join (cost=1.83..15,265.15 rows=1 width=242) (actual time=0.094..526.409 rows=631 loops=1)

18. 1.015 16.338 ↓ 631.0 631 1

Nested Loop (cost=1.27..15,257.64 rows=1 width=226) (actual time=0.052..16.338 rows=631 loops=1)

19. 1.208 10.275 ↓ 157.8 631 1

Nested Loop (cost=0.84..15,234.28 rows=4 width=66) (actual time=0.039..10.275 rows=631 loops=1)

20. 2.126 2.126 ↑ 2.8 631 1

Index Scan using dvsys_search_results_data_1479_pkey on dvsys_search_results_data_1479 (cost=0.28..86.83 rows=1,770 width=18) (actual time=0.019..2.126 rows=631 loops=1)

21. 6.941 6.941 ↑ 1.0 1 631

Index Scan using dvsys_instances_pk_instanceid on dvsys_instances "Inst" (cost=0.56..8.56 rows=1 width=48) (actual time=0.011..0.011 rows=1 loops=631)

  • Index Cond: ("InstanceID" = dvsys_search_results_data_1479."CardID")
  • Filter: ((NOT COALESCE("Deleted", false)) AND (COALESCE(("ArchiveState")::integer, 0) = 0))
22. 5.048 5.048 ↑ 1.0 1 631

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.008..0.008 rows=1 loops=631)

  • Index Cond: ("InstanceID" = "Inst"."InstanceID")
23. 509.217 509.217 ↓ 0.0 0 631

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.807..0.807 rows=0 loops=631)

  • Index Cond: (("InstanceID" = "Inst"."InstanceID") AND ("UserID" = 'fd6262dc-7f09-4152-b9b4-c66bf717907b'::uuid))
  • Heap Fetches: 261
24. 2.524 2.524 ↑ 1.0 1 631

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.004..0.004 rows=1 loops=631)

  • Index Cond: ("RowID" = "Main"."Author")
  • Heap Fetches: 631
25. 1.893 1.893 ↑ 1.0 1 631

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.003..0.003 rows=1 loops=631)

  • Index Cond: ("RowID" = "Main"."Kind")
  • Heap Fetches: 631
26. 1,749.132 1,749.132 ↑ 1.0 1 631

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.772..2.772 rows=1 loops=631)

  • Index Cond: ("InstanceID" = "Main"."InstanceID")
27. 2.524 2.524 ↑ 1.0 1 631

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.004..0.004 rows=1 loops=631)

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

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.000..0.000 rows=0 loops=631)

  • Index Cond: ("InstanceID" = "Main"."Resolution")
29. 707.982 707.982 ↑ 1.0 1 631

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.122..1.122 rows=1 loops=631)

  • Index Cond: ("InstanceID" = "Main"."InstanceID")
30. 7.572 7.572 ↑ 1.0 1 631

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 time=0.012..0.012 rows=1 loops=631)

  • Index Cond: ("InstanceID" = "Main"."RegCard")
31. 5.048 5.048 ↑ 1.0 1 631

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.008..0.008 rows=1 loops=631)

  • Index Cond: ("InstanceID" = "Main"."RegCard")
32. 1.893 1.893 ↑ 1.0 1 631

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.003..0.003 rows=1 loops=631)

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

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.000..0.000 rows=0 loops=631)

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

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.089..0.089 rows=0 loops=631)

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

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.004..0.004 rows=1 loops=631)

  • Index Cond: ("RowID" = "Main"."Urgency")
  • Heap Fetches: 374
36. 446.748 446.748 ↓ 0.0 0 631

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=0.708..0.708 rows=0 loops=631)

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