explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YZ77

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 0.651 ↑ 1.0 1 1

Limit (cost=10.78..218.97 rows=1 width=1,918) (actual time=0.633..0.651 rows=1 loops=1)

  • Buffers: shared hit=48
2. 0.023 0.631 ↑ 1.0 1 1

Nested Loop Left Join (cost=10.78..218.97 rows=1 width=1,918) (actual time=0.630..0.631 rows=1 loops=1)

  • Buffers: shared hit=48
3. 0.012 0.606 ↑ 1.0 1 1

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

  • Buffers: shared hit=48
4. 0.010 0.576 ↑ 1.0 1 1

Nested Loop Left Join (cost=10.06..212.58 rows=1 width=2,144) (actual time=0.576..0.576 rows=1 loops=1)

  • Buffers: shared hit=48
5. 0.011 0.564 ↑ 1.0 1 1

Nested Loop Left Join (cost=9.63..204.14 rows=1 width=2,088) (actual time=0.563..0.564 rows=1 loops=1)

  • Buffers: shared hit=48
6. 0.010 0.552 ↑ 1.0 1 1

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

  • Buffers: shared hit=48
7. 0.010 0.541 ↑ 1.0 1 1

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

  • Buffers: shared hit=48
8. 0.010 0.528 ↑ 1.0 1 1

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

  • Buffers: shared hit=48
9. 0.010 0.517 ↑ 1.0 1 1

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

  • Buffers: shared hit=48
10. 0.010 0.506 ↑ 1.0 1 1

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

  • Buffers: shared hit=48
11. 0.009 0.493 ↑ 1.0 1 1

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

  • Buffers: shared hit=48
12. 0.010 0.474 ↑ 1.0 1 1

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

  • Buffers: shared hit=47
13. 0.011 0.437 ↑ 1.0 1 1

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

  • Buffers: shared hit=42
14. 0.009 0.397 ↑ 1.0 1 1

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

  • Buffers: shared hit=38
15. 0.009 0.360 ↑ 1.0 1 1

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

  • Buffers: shared hit=33
16. 0.008 0.350 ↑ 1.0 1 1

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

  • Buffers: shared hit=33
17. 0.009 0.340 ↑ 1.0 1 1

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

  • Buffers: shared hit=33
18. 0.009 0.328 ↑ 1.0 1 1

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

  • Buffers: shared hit=33
19. 0.010 0.306 ↑ 1.0 1 1

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

  • Buffers: shared hit=33
20. 0.010 0.279 ↑ 1.0 1 1

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

  • Buffers: shared hit=30
21. 0.007 0.260 ↑ 1.0 1 1

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

  • Buffers: shared hit=26
22. 0.009 0.217 ↑ 1.0 1 1

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

  • Buffers: shared hit=25
23. 0.008 0.183 ↑ 1.0 1 1

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

  • Buffers: shared hit=20
24. 0.009 0.148 ↑ 1.0 1 1

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

  • Buffers: shared hit=15
25. 0.008 0.119 ↑ 1.0 1 1

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

  • Buffers: shared hit=12
26. 0.009 0.102 ↑ 1.0 1 1

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

  • Buffers: shared hit=12
27. 0.016 0.076 ↑ 1.0 1 1

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

  • Buffers: shared hit=8
28. 0.038 0.038 ↑ 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.038..0.038 rows=1 loops=1)

  • Index Cond: ("RowID" = $2)
  • Buffers: shared hit=4
29. 0.022 0.022 ↑ 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.022..0.022 rows=1 loops=1)

  • Index Cond: (t0."Author" = "RowID")
  • Buffers: shared hit=4
30. 0.017 0.017 ↑ 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.017..0.017 rows=1 loops=1)

  • Index Cond: (t0."Appointed" = "RowID")
  • Buffers: shared hit=4
31. 0.009 0.009 ↓ 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.009..0.009 rows=0 loops=1)

  • Index Cond: (t0."Controller" = "RowID")
32. 0.020 0.020 ↑ 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.020..0.020 rows=1 loops=1)

  • Index Cond: (t0."Urgency" = "RowID")
  • Buffers: shared hit=3
33. 0.027 0.027 ↑ 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.027..0.027 rows=1 loops=1)

  • Index Cond: (t0."RegCard" = "InstanceID")
  • Buffers: shared hit=5
34. 0.025 0.025 ↑ 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.025..0.025 rows=1 loops=1)

  • Index Cond: (t0."RegCard" = "InstanceID")
  • Buffers: shared hit=5
35. 0.036 0.036 ↓ 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.035..0.036 rows=0 loops=1)

  • Index Cond: (t0."RegCard" = "InstanceID")
  • Buffers: shared hit=1
36. 0.009 0.009 ↑ 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.009..0.009 rows=1 loops=1)

  • Index Cond: (t0."Executes" = "RowID")
  • Buffers: shared hit=4
37. 0.017 0.017 ↑ 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.017..0.017 rows=1 loops=1)

  • Index Cond: (t0."Kind" = "RowID")
  • Buffers: shared hit=3
38. 0.013 0.013 ↓ 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.013..0.013 rows=0 loops=1)

  • Index Cond: (t0."Curator" = "RowID")
39. 0.003 0.003 ↓ 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.002..0.003 rows=0 loops=1)

  • Index Cond: (t0."Resolution" = "InstanceID")
40. 0.002 0.002 ↓ 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.002 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.028 0.028 ↑ 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.028..0.028 rows=1 loops=1)

  • Index Cond: ("InstanceID" = '8f704e7d-a123-4917-94b4-f3b851f193b2'::uuid)
  • Buffers: shared hit=5
43. 0.029 0.029 ↑ 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.029..0.029 rows=1 loops=1)

  • Index Cond: (t0."ParentPart" = "RowID")
  • Buffers: shared hit=4
44. 0.027 0.027 ↑ 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.027..0.027 rows=1 loops=1)

  • Index Cond: (t27."InstanceID" = "InstanceID")
  • Buffers: shared hit=5
45. 0.010 0.010 ↓ 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.010..0.010 rows=0 loops=1)

  • Index Cond: (t27."InstanceID" = "InstanceID")
  • Buffers: shared hit=1
46. 0.003 0.003 ↓ 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.003..0.003 rows=0 loops=1)

  • Index Cond: (t0."ReplyFile" = "InstanceID")
47. 0.001 0.001 ↓ 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.001 rows=0 loops=1)

  • Index Cond: (t0."ReplyFile" = "InstanceID")
48. 0.001 0.001 ↓ 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.001..0.001 rows=0 loops=1)

  • Index Cond: (t0."ReplyFile" = "InstanceID")
49. 0.003 0.003 ↓ 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.003 rows=0 loops=1)

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

Index Scan using dvsys_instances_pk_instanceid on dvsys_instances tinst38 (cost=0.57..4.17 rows=1 width=32) (actual time=0.001..0.001 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.002 0.002 ↓ 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.002 rows=0 loops=1)

  • Index Cond: (t0."DocumentApprover" = "RowID")
53. 0.018 0.018 ↓ 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.018..0.018 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")