explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IlBZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 141,956.962 ↓ 0.0 0 1

Insert on tmp_tbl_kst_tbl_f86af644069845039cbdbb79e983a183 (cost=4,296,512.07..4,296,512.14 rows=4 width=198) (actual time=141,956.962..141,956.962 rows=0 loops=1)

2. 0.002 141,956.959 ↓ 0.0 0 1

Subquery Scan on *SELECT* (cost=4,296,512.07..4,296,512.14 rows=4 width=198) (actual time=141,956.959..141,956.959 rows=0 loops=1)

3. 0.016 141,956.957 ↓ 0.0 0 1

Sort (cost=4,296,512.07..4,296,512.08 rows=4 width=194) (actual time=141,956.957..141,956.957 rows=0 loops=1)

  • Sort Key: "Main"."ControlTerm" NULLS FIRST
  • Sort Method: quicksort Memory: 25kB
4. 0.006 141,956.941 ↓ 0.0 0 1

Nested Loop Left Join (cost=4.00..4,296,511.93 rows=4 width=194) (actual time=141,956.941..141,956.941 rows=0 loops=1)

5. 0.009 141,956.935 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.57..4,296,509.74 rows=4 width=186) (actual time=141,956.935..141,956.935 rows=0 loops=1)

6. 0.005 141,956.926 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.14..4,296,507.54 rows=4 width=186) (actual time=141,956.926..141,956.926 rows=0 loops=1)

7. 0.007 141,956.921 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.71..4,296,505.41 rows=4 width=170) (actual time=141,956.921..141,956.921 rows=0 loops=1)

8. 0.022 141,956.914 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.42..4,296,504.21 rows=4 width=170) (actual time=141,956.914..141,956.914 rows=0 loops=1)

9. 0.001 141,956.892 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.99..4,296,502.14 rows=4 width=170) (actual time=141,956.892..141,956.892 rows=0 loops=1)

10. 0.002 141,956.891 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.71..4,296,500.94 rows=4 width=170) (actual time=141,956.891..141,956.891 rows=0 loops=1)

11. 0.000 141,956.889 ↓ 0.0 0 1

Nested Loop (cost=1.15..4,296,470.88 rows=4 width=154) (actual time=141,956.889..141,956.889 rows=0 loops=1)

12. 25,432.041 136,111.461 ↓ 399.3 6,455,459 1

Nested Loop (cost=0.99..4,093,802.09 rows=16,165 width=152) (actual time=0.043..136,111.461 rows=6,455,459 loops=1)

13. 50,627.862 50,627.862 ↓ 399.8 30,025,779 1

Index Scan using dvsys_instances_pk_instanceid on dvsys_instances "Inst" (cost=0.56..3,654,752.44 rows=75,097 width=48) (actual time=0.018..50,627.862 rows=30,025,779 loops=1)

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

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

  • Index Cond: ("InstanceID" = "Inst"."InstanceID")
15. 6,455.459 6,455.459 ↓ 0.0 0 6,455,459

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,455,459)

  • Index Cond: ("CardID" = "Main"."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 Only Scan using dvsys_refstaff_employees_pk_rowid on "dvtable_{dbc8ae9d-c1d2-4d5e-978b-339d22b32482}" "Employees_3" (cost=0.28..0.30 rows=1 width=16) (never executed)

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