explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7mIM

Settings
# exclusive inclusive rows x rows loops node
1. 0.021 1.269 ↑ 1.0 1 1

Limit (cost=10.78..218.98 rows=1 width=1,918) (actual time=1.250..1.269 rows=1 loops=1)

2. 0.035 1.248 ↑ 1.0 1 1

Nested Loop Left Join (cost=10.78..218.98 rows=1 width=1,918) (actual time=1.248..1.248 rows=1 loops=1)

3. 0.013 1.211 ↑ 1.0 1 1

Nested Loop Left Join (cost=10.63..218.00 rows=1 width=2,160) (actual time=1.211..1.211 rows=1 loops=1)

4. 0.013 1.197 ↑ 1.0 1 1

Nested Loop Left Join (cost=10.06..212.59 rows=1 width=2,144) (actual time=1.196..1.197 rows=1 loops=1)

5. 0.013 1.181 ↑ 1.0 1 1

Nested Loop Left Join (cost=9.63..204.15 rows=1 width=2,088) (actual time=1.181..1.181 rows=1 loops=1)

6. 0.012 1.167 ↑ 1.0 1 1

Nested Loop Left Join (cost=9.49..203.18 rows=1 width=2,088) (actual time=1.167..1.167 rows=1 loops=1)

7. 0.012 1.145 ↑ 1.0 1 1

Nested Loop Left Join (cost=8.92..199.00 rows=1 width=2,072) (actual time=1.145..1.145 rows=1 loops=1)

8. 0.012 1.131 ↑ 1.0 1 1

Nested Loop Left Join (cost=8.49..190.55 rows=1 width=2,036) (actual time=1.131..1.131 rows=1 loops=1)

9. 0.012 1.117 ↑ 1.0 1 1

Nested Loop Left Join (cost=8.34..174.37 rows=1 width=2,020) (actual time=1.117..1.117 rows=1 loops=1)

10. 0.012 1.103 ↑ 1.0 1 1

Nested Loop Left Join (cost=7.77..157.77 rows=1 width=2,004) (actual time=1.103..1.103 rows=1 loops=1)

11. 0.012 1.089 ↑ 1.0 1 1

Nested Loop Left Join (cost=7.21..141.17 rows=1 width=1,924) (actual time=1.089..1.089 rows=1 loops=1)

12. 0.015 1.072 ↑ 1.0 1 1

Nested Loop Left Join (cost=7.06..140.20 rows=1 width=1,924) (actual time=1.072..1.072 rows=1 loops=1)

13. 0.015 0.990 ↑ 1.0 1 1

Nested Loop Left Join (cost=6.50..134.88 rows=1 width=1,908) (actual time=0.990..0.990 rows=1 loops=1)

14. 0.006 0.337 ↑ 1.0 1 1

Nested Loop Left Join (cost=6.07..126.44 rows=1 width=1,879) (actual time=0.337..0.337 rows=1 loops=1)

15. 0.005 0.292 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.50..117.84 rows=1 width=1,863) (actual time=0.292..0.292 rows=1 loops=1)

16. 0.005 0.286 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.35..109.64 rows=1 width=1,847) (actual time=0.286..0.286 rows=1 loops=1)

17. 0.005 0.280 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.79..101.05 rows=1 width=1,831) (actual time=0.280..0.280 rows=1 loops=1)

18. 0.005 0.274 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.36..92.61 rows=1 width=1,807) (actual time=0.274..0.274 rows=1 loops=1)

19. 0.006 0.265 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.94..84.17 rows=1 width=1,664) (actual time=0.265..0.265 rows=1 loops=1)

20. 0.005 0.244 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.66..75.86 rows=1 width=1,608) (actual time=0.244..0.244 rows=1 loops=1)

21. 0.005 0.228 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.24..67.43 rows=1 width=1,465) (actual time=0.228..0.228 rows=1 loops=1)

22. 0.005 0.214 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.10..59.22 rows=1 width=1,417) (actual time=0.214..0.214 rows=1 loops=1)

23. 0.004 0.146 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.53..50.64 rows=1 width=1,359) (actual time=0.146..0.146 rows=1 loops=1)

24. 0.004 0.112 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.97..42.06 rows=1 width=1,318) (actual time=0.112..0.112 rows=1 loops=1)

25. 0.005 0.089 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.68..33.75 rows=1 width=1,268) (actual time=0.088..0.089 rows=1 loops=1)

26. 0.005 0.083 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.26..25.32 rows=1 width=1,125) (actual time=0.083..0.083 rows=1 loops=1)

27. 0.011 0.065 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.85..16.88 rows=1 width=982) (actual time=0.065..0.065 rows=1 loops=1)

28. 0.034 0.034 ↑ 1.0 1 1

Index Scan using dvsys_cardtask_taskdata_pk_rowid on "dvtable_{794e3a56-36f4-4a48-ac56-4ce21c794e26}" t0 (cost=0.43..8.45 rows=1 width=839) (actual time=0.034..0.034 rows=1 loops=1)

  • Index Cond: ("RowID" = 'b11f6005-a692-44cc-aa18-1b7459bf7e26'::uuid)
29. 0.020 0.020 ↑ 1.0 1 1

Index Scan using dvsys_refstaff_employees_pk_rowid on "dvtable_{dbc8ae9d-c1d2-4d5e-978b-339d22b32482}" t1 (cost=0.42..8.44 rows=1 width=159) (actual time=0.019..0.020 rows=1 loops=1)

  • Index Cond: (t0."Author" = "RowID")
30. 0.013 0.013 ↑ 1.0 1 1

Index Scan using dvsys_refstaff_employees_pk_rowid on "dvtable_{dbc8ae9d-c1d2-4d5e-978b-339d22b32482}" t2 (cost=0.42..8.44 rows=1 width=159) (actual time=0.013..0.013 rows=1 loops=1)

  • Index Cond: (t0."Appointed" = "RowID")
31. 0.001 0.001 ↓ 0.0 0 1

Index Scan using dvsys_refstaff_employees_pk_rowid on "dvtable_{dbc8ae9d-c1d2-4d5e-978b-339d22b32482}" t4 (cost=0.42..8.44 rows=1 width=159) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (t0."Controller" = "RowID")
32. 0.019 0.019 ↑ 1.0 1 1

Index Scan using dvsys_refuniversal_item_pk_rowid on "dvtable_{dd20bf9b-90f8-4d9a-9553-5b5f17ad724e}" t9 (cost=0.29..8.30 rows=1 width=66) (actual time=0.018..0.019 rows=1 loops=1)

  • Index Cond: (t0."Urgency" = "RowID")
33. 0.030 0.030 ↑ 1.0 1 1

Index Scan using dvsys_cardregistration_registrationdata_uc_struct on "dvtable_{f9d3ef11-a060-415a-be69-da9efd3ca436}" t10 (cost=0.56..8.58 rows=1 width=57) (actual time=0.030..0.030 rows=1 loops=1)

  • Index Cond: (t0."RegCard" = "InstanceID")
34. 0.063 0.063 ↑ 1.0 1 1

Index Scan using dvsys_instances_pk_instanceid on dvsys_instances tinst10 (cost=0.57..8.59 rows=1 width=74) (actual time=0.063..0.063 rows=1 loops=1)

  • Index Cond: (t0."RegCard" = "InstanceID")
35. 0.009 0.009 ↓ 0.0 0 1

Index Scan using dvsys_instances_archive_pk_instanceid on dvsys_instances_archive tinstarch10 (cost=0.15..8.17 rows=1 width=64) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (t0."RegCard" = "InstanceID")
36. 0.011 0.011 ↑ 1.0 1 1

Index Scan using dvsys_refstaff_employees_pk_rowid on "dvtable_{dbc8ae9d-c1d2-4d5e-978b-339d22b32482}" t13 (cost=0.42..8.44 rows=1 width=159) (actual time=0.010..0.011 rows=1 loops=1)

  • Index Cond: (t0."Executes" = "RowID")
37. 0.015 0.015 ↑ 1.0 1 1

Index Scan using dvsys_refkinds_cardkinds_pk_rowid on "dvtable_{c7ba000c-6203-4d7f-8c6b-5cb6f1e6f851}" t16 (cost=0.28..8.29 rows=1 width=72) (actual time=0.015..0.015 rows=1 loops=1)

  • Index Cond: (t0."Kind" = "RowID")
38. 0.004 0.004 ↓ 0.0 0 1

Index Scan using dvsys_refstaff_employees_pk_rowid on "dvtable_{dbc8ae9d-c1d2-4d5e-978b-339d22b32482}" t17 (cost=0.42..8.44 rows=1 width=159) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (t0."Curator" = "RowID")
39. 0.001 0.001 ↓ 0.0 0 1

Index Scan using dvsys_cardresolutio_system_uc_struct on "dvtable_{5c94dfaa-3431-4775-9093-8d7fe53a3042}" t23 (cost=0.43..8.45 rows=1 width=40) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (t0."Resolution" = "InstanceID")
40. 0.001 0.001 ↓ 0.0 0 1

Index Scan using dvsys_instances_pk_instanceid on dvsys_instances tinst23 (cost=0.57..8.59 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (t0."Resolution" = "InstanceID")
41. 0.001 0.001 ↓ 0.0 0 1

Index Scan using dvsys_instances_archive_pk_instanceid on dvsys_instances_archive tinstarch23 (cost=0.15..8.17 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (t0."Resolution" = "InstanceID")
42. 0.039 0.039 ↑ 1.0 1 1

Index Scan using dvsys_instances_pk_instanceid on dvsys_instances tinst16 (cost=0.57..8.59 rows=1 width=16) (actual time=0.039..0.039 rows=1 loops=1)

  • Index Cond: ("InstanceID" = '8f704e7d-a123-4917-94b4-f3b851f193b2'::uuid)
43. 0.638 0.638 ↑ 1.0 1 1

Index Scan using dvsys_cardresolutio_parts_pk_rowid on "dvtable_{1f6ef15c-c274-4029-8959-877479f7a29a}" t27 (cost=0.43..8.45 rows=1 width=45) (actual time=0.638..0.638 rows=1 loops=1)

  • Index Cond: (t0."ParentPart" = "RowID")
44. 0.067 0.067 ↑ 1.0 1 1

Index Scan using dvsys_instances_pk_instanceid on dvsys_instances tinst27 (cost=0.57..5.32 rows=1 width=32) (actual time=0.067..0.067 rows=1 loops=1)

  • Index Cond: (t27."InstanceID" = "InstanceID")
45. 0.005 0.005 ↓ 0.0 0 1

Index Scan using dvsys_instances_archive_pk_instanceid on dvsys_instances_archive tinstarch27 (cost=0.15..0.97 rows=1 width=32) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (t27."InstanceID" = "InstanceID")
46. 0.002 0.002 ↓ 0.0 0 1

Index Scan using dvsys_cardfile_maininfo_uc_struct on "dvtable_{b4562df8-af19-4d0f-85ca-53a311354d39}" t32 (cost=0.56..8.58 rows=1 width=96) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (t0."ReplyFile" = "InstanceID")
47. 0.002 0.002 ↓ 0.0 0 1

Index Scan using dvsys_instances_pk_instanceid on dvsys_instances tinst32 (cost=0.57..8.59 rows=1 width=32) (actual time=0.001..0.002 rows=0 loops=1)

  • Index Cond: (t0."ReplyFile" = "InstanceID")
48. 0.002 0.002 ↓ 0.0 0 1

Index Scan using dvsys_instances_archive_pk_instanceid on dvsys_instances_archive tinstarch32 (cost=0.15..8.17 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (t0."ReplyFile" = "InstanceID")
49. 0.002 0.002 ↓ 0.0 0 1

Index Scan using dvsys_cardregistration_filegroups_pk_rowid on "dvtable_{677c1a3f-7160-4042-83ac-68af8ca0cf30}" t38 (cost=0.43..8.45 rows=1 width=52) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (t0."FileGroup" = "RowID")
50. 0.010 0.010 ↓ 0.0 0 1

Index Scan using dvsys_instances_pk_instanceid on dvsys_instances tinst38 (cost=0.57..4.18 rows=1 width=32) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (t38."InstanceID" = "InstanceID")
51. 0.001 0.001 ↓ 0.0 0 1

Index Scan using dvsys_instances_archive_pk_instanceid on dvsys_instances_archive tinstarch38 (cost=0.15..0.97 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (t38."InstanceID" = "InstanceID")
52. 0.003 0.003 ↓ 0.0 0 1

Index Scan using dvsys_cardregistration_approvers_pk_rowid on "dvtable_{d045c254-e38e-4a0f-b7b0-40bcb5fb8c87}" t52 (cost=0.43..8.45 rows=1 width=72) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: (t0."DocumentApprover" = "RowID")
53. 0.001 0.001 ↓ 0.0 0 1

Index Scan using dvsys_instances_pk_instanceid on dvsys_instances tinst52 (cost=0.57..5.41 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (t52."InstanceID" = "InstanceID")
54. 0.002 0.002 ↓ 0.0 0 1

Index Scan using dvsys_instances_archive_pk_instanceid on dvsys_instances_archive tinstarch52 (cost=0.15..0.97 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=1)

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