explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d1mo

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 133,966.323 ↓ 0.0 0 1

> Subquery Scan on "SELECT" (cost=4,296,456.49..4,296,456.55 rows=3 width=326) (actual time=133,966.323..133,966.323 rows=0 loops=1)

2. 0.009 133,966.321 ↓ 0.0 0 1

Sort (cost=4,296,456.49..4,296,456.50 rows=3 width=322) (actual time=133,966.321..133,966.321 rows=0 loops=1)

  • Sort Key: "tDate"."CreationDateTime" DESC NULLS LAST
  • Sort Method: quicksort Memory: 25kB
3. 0.001 133,966.312 ↓ 0.0 0 1

Nested Loop Left Join (cost=6.11..4,296,456.39 rows=3 width=322) (actual time=133,966.312..133,966.312 rows=0 loops=1)

4. 0.016 133,966.311 ↓ 0.0 0 1

Nested Loop Left Join (cost=5.68..4,296,454.78 rows=3 width=330) (actual time=133,966.311..133,966.311 rows=0 loops=1)

5. 0.002 133,966.295 ↓ 0.0 0 1

Nested Loop Left Join (cost=5.41..4,296,453.91 rows=3 width=330) (actual time=133,966.295..133,966.295 rows=0 loops=1)

6. 0.001 133,966.293 ↓ 0.0 0 1

Nested Loop Left Join (cost=5.25..4,296,450.46 rows=2 width=330) (actual time=133,966.293..133,966.293 rows=0 loops=1)

7. 0.002 133,966.292 ↓ 0.0 0 1

Nested Loop Left Join (cost=5.10..4,296,448.74 rows=1 width=314) (actual time=133,966.292..133,966.292 rows=0 loops=1)

8. 0.001 133,966.290 ↓ 0.0 0 1

Nested Loop Left Join (cost=4.83..4,296,448.45 rows=1 width=314) (actual time=133,966.290..133,966.290 rows=0 loops=1)

9. 0.003 133,966.289 ↓ 0.0 0 1

Nested Loop Left Join (cost=4.40..4,296,447.92 rows=1 width=298) (actual time=133,966.289..133,966.289 rows=0 loops=1)

10. 0.002 133,966.286 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.97..4,296,447.43 rows=1 width=282) (actual time=133,966.286..133,966.286 rows=0 loops=1)

11. 0.002 133,966.284 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.54..4,296,446.94 rows=1 width=266) (actual time=133,966.283..133,966.284 rows=0 loops=1)

12. 0.003 133,966.282 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.11..4,296,446.40 rows=1 width=250) (actual time=133,966.282..133,966.282 rows=0 loops=1)

13. 0.001 133,966.279 ↓ 0.0 0 1

Nested Loop (cost=2.83..4,296,446.10 rows=1 width=250) (actual time=133,966.279..133,966.279 rows=0 loops=1)

  • Join Filter: ("Inst"."InstanceID" = "tDate"."InstanceID")
14. 0.002 133,966.278 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.26..4,296,445.26 rows=1 width=242) (actual time=133,966.278..133,966.278 rows=0 loops=1)

15. 0.002 133,966.276 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.98..4,296,444.96 rows=1 width=242) (actual time=133,966.276..133,966.276 rows=0 loops=1)

16. 0.001 133,966.274 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.71..4,296,444.67 rows=1 width=242) (actual time=133,966.274..133,966.274 rows=0 loops=1)

17. 0.000 133,966.273 ↓ 0.0 0 1

Nested Loop (cost=1.15..4,296,437.16 rows=1 width=226) (actual time=133,966.273..133,966.273 rows=0 loops=1)

18. 20,427.366 128,421.278 ↓ 399.6 6,454,732 1

Nested Loop (cost=0.99..4,093,884.40 rows=16,155 width=208) (actual time=0.038..128,421.278 rows=6,454,732 loops=1)

19. 47,950.958 47,950.958 ↓ 399.0 30,021,477 1

Index Scan using dvsys_instances_pk_instanceid on dvsys_instances "Inst" (cost=0.56..3,654,345.45 rows=75,251 width=48) (actual time=0.017..47,950.958 rows=30,021,477 loops=1)

  • Filter: ((NOT COALESCE("Deleted", false)) AND (COALESCE(("ArchiveState")::integer, 0) = 0))
  • Rows Removed by Filter: 208
20. 60,042.954 60,042.954 ↓ 0.0 0 30,021,477

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.002..0.002 rows=0 loops=30,021,477)

  • Index Cond: ("InstanceID" = "Inst"."InstanceID")
21. 6,454.732 6,454.732 ↓ 0.0 0 6,454,732

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 time=0.001..0.001 rows=0 loops=6,454,732)

  • Index Cond: ("CardID" = "Inst"."InstanceID")
22. 0.000 0.000 ↓ 0.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) (never executed)

  • Index Cond: (("InstanceID" = "Inst"."InstanceID") AND ("UserID" = '1688fbf4-4d01-4b83-a634-8bd0796d7acf'::uuid))
  • Heap Fetches: 0
23. 0.000 0.000 ↓ 0.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) (never executed)

  • Index Cond: ("RowID" = "Main"."Kind")
  • Heap Fetches: 0
24. 0.000 0.000 ↓ 0.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) (never executed)

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

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

  • Index Cond: ("InstanceID" = "Main"."InstanceID")
26. 0.000 0.000 ↓ 0.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) (never executed)

  • Index Cond: ("RowID" = "Main"."Appointed")
  • Heap Fetches: 0
27. 0.000 0.000 ↓ 0.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) (never executed)

  • Index Cond: ("InstanceID" = "Main"."InstanceID")
28. 0.000 0.000 ↓ 0.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) (never executed)

  • Index Cond: ("InstanceID" = "Main"."Resolution")
29. 0.000 0.000 ↓ 0.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=32) (never executed)

  • Index Cond: ("InstanceID" = "Main"."RegCard")
30. 0.000 0.000 ↓ 0.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) (never executed)

  • Index Cond: ("InstanceID" = "Main"."RegCard")
31. 0.000 0.000 ↓ 0.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) (never executed)

  • Index Cond: ("RowID" = "_CardRegistration_RegistrationData"."Kind")
  • Heap Fetches: 0
32. 0.000 0.000 ↓ 0.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) (never executed)

  • Index Cond: ("ParentRowID" = "System_1"."State")
  • Filter: (("LocaleID")::sql_variant = '(7,,,,,,,1049,)'::sql_variant)
33. 0.000 0.000 ↓ 0.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) (never executed)

  • Index Cond: ("ParentRowID" = "System_2"."State")
  • Filter: (("LocaleID")::sql_variant = '(7,,,,,,,1049,)'::sql_variant)
34. 0.000 0.000 ↓ 0.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) (never executed)

  • Index Cond: ("RowID" = "Main"."Urgency")
  • Heap Fetches: 0
35. 0.000 0.000 ↓ 0.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) (never executed)

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