explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qYiG

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

Insert on tmp_tbl_kst_tbl_c370c626aac94a6fa7191055f8f90fc1 (cost=4,296,452.75..4,296,452.77 rows=1 width=230) (actual time=133,691.049..133,691.049 rows=0 loops=1)

2. 0.002 133,691.047 ↓ 0.0 0 1

Subquery Scan on *SELECT* (cost=4,296,452.75..4,296,452.77 rows=1 width=230) (actual time=133,691.047..133,691.047 rows=0 loops=1)

3. 0.011 133,691.045 ↓ 0.0 0 1

Sort (cost=4,296,452.75..4,296,452.75 rows=1 width=226) (actual time=133,691.045..133,691.045 rows=0 loops=1)

  • Sort Key: ((((((COALESCE("Employees_3"."LastName", ''::text) + ' '::text) + COALESCE("left"("Employees_3"."FirstName", 1), ''::text)) + CASE WHEN ("Employees_3"."FirstName" IS NOT NULL) THEN '.'::text ELSE ''::text END) + COALESCE("left"("Employees_3"."MiddleName", 1), ''::text)) + CASE WHEN ("Employees_3"."MiddleName" IS NOT NULL) THEN '.'::text ELSE ''::text END)) NULLS FIRST, "Main"."ControlTerm" NULLS FIRST
  • Sort Method: quicksort Memory: 25kB
4. 0.002 133,691.034 ↓ 0.0 0 1

Nested Loop Left Join (cost=4.00..4,296,452.67 rows=1 width=226) (actual time=133,691.034..133,691.034 rows=0 loops=1)

5. 0.004 133,691.032 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.57..4,296,450.87 rows=1 width=235) (actual time=133,691.032..133,691.032 rows=0 loops=1)

6. 0.001 133,691.028 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.14..4,296,450.32 rows=1 width=235) (actual time=133,691.028..133,691.028 rows=0 loops=1)

7. 0.003 133,691.027 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.71..4,296,449.79 rows=1 width=219) (actual time=133,691.027..133,691.027 rows=0 loops=1)

8. 0.002 133,691.024 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.42..4,296,449.49 rows=1 width=219) (actual time=133,691.024..133,691.024 rows=0 loops=1)

9. 0.001 133,691.022 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.99..4,296,448.97 rows=1 width=219) (actual time=133,691.022..133,691.022 rows=0 loops=1)

10. 0.003 133,691.021 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.71..4,296,448.67 rows=1 width=170) (actual time=133,691.021..133,691.021 rows=0 loops=1)

11. 0.000 133,691.018 ↓ 0.0 0 1

Nested Loop (cost=1.15..4,296,441.16 rows=1 width=154) (actual time=133,691.018..133,691.018 rows=0 loops=1)

12. 20,238.296 128,234.258 ↓ 399.6 6,454,733 1

Nested Loop (cost=0.99..4,093,888.40 rows=16,155 width=152) (actual time=0.035..128,234.258 rows=6,454,733 loops=1)

13. 47,952.992 47,952.992 ↓ 399.0 30,021,485 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.016..47,952.992 rows=30,021,485 loops=1)

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

Index Scan using dvsys_cardtask_taskdata_uc_struct on "dvtable_{794e3a56-36f4-4a48-ac56-4ce21c794e26}" "Main" (cost=0.43..5.84 rows=1 width=104) (actual time=0.002..0.002 rows=0 loops=30,021,485)

  • Index Cond: ("InstanceID" = "Inst"."InstanceID")
15. 6,454.733 6,454.733 ↓ 0.0 0 6,454,733

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,733)

  • Index Cond: ("CardID" = "Inst"."InstanceID")
16. 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" = '76f0dc7d-4d7c-4895-8c7f-285bef735648'::uuid))
  • Heap Fetches: 0
17. 0.000 0.000 ↓ 0.0 0

Index Scan using dvsys_refstaff_employees_pk_rowid on "dvtable_{dbc8ae9d-c1d2-4d5e-978b-339d22b32482}" "Employees_3" (cost=0.28..0.30 rows=1 width=65) (never executed)

  • Index Cond: ("RowID" = "Main"."Appointed")
18. 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
19. 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"."Author")
  • Heap Fetches: 0
20. 0.000 0.000 ↓ 0.0 0

Index Scan using dvsys_cardregistration_registrationdata_uc_struct on "dvtable_{f9d3ef11-a060-415a-be69-da9efd3ca436}" "RegistrationData_1" (cost=0.43..0.53 rows=1 width=32) (never executed)

  • Index Cond: ("InstanceID" = "Main"."RegCard")
21. 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.55 rows=1 width=32) (never executed)

  • Index Cond: ("InstanceID" = "RegistrationData_1"."InstanceID")
22. 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=32) (never executed)

  • Index Cond: ("InstanceID" = "Main"."InstanceID")