explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6Llw

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.072 ↓ 0.0 0 1

Nested Loop (cost=34.16..76.33 rows=1 width=125,355) (actual time=0.072..0.072 rows=0 loops=1)

2. 0.000 0.072 ↓ 0.0 0 1

Nested Loop (cost=34.02..75.47 rows=1 width=120,421) (actual time=0.072..0.072 rows=0 loops=1)

3. 0.000 0.072 ↓ 0.0 0 1

Nested Loop (cost=33.88..75.23 rows=1 width=120,409) (actual time=0.072..0.072 rows=0 loops=1)

4. 0.001 0.072 ↓ 0.0 0 1

Nested Loop (cost=33.73..74.71 rows=1 width=120,080) (actual time=0.072..0.072 rows=0 loops=1)

5. 0.000 0.071 ↓ 0.0 0 1

Nested Loop (cost=33.59..69.74 rows=1 width=119,751) (actual time=0.071..0.071 rows=0 loops=1)

6. 0.000 0.071 ↓ 0.0 0 1

Nested Loop (cost=33.45..69.34 rows=1 width=116,563) (actual time=0.071..0.071 rows=0 loops=1)

7. 0.001 0.071 ↓ 0.0 0 1

Nested Loop (cost=33.31..68.85 rows=1 width=115,385) (actual time=0.071..0.071 rows=0 loops=1)

8. 0.000 0.070 ↓ 0.0 0 1

Nested Loop (cost=33.17..68.44 rows=1 width=114,269) (actual time=0.07..0.07 rows=0 loops=1)

9. 0.000 0.070 ↓ 0.0 0 1

Nested Loop (cost=33.03..68.04 rows=1 width=111,081) (actual time=0.07..0.07 rows=0 loops=1)

10. 0.000 0.070 ↓ 0.0 0 1

Nested Loop (cost=32.89..67.75 rows=1 width=109,930) (actual time=0.07..0.07 rows=0 loops=1)

11. 0.001 0.070 ↓ 0.0 0 1

Nested Loop (cost=32.75..67.36 rows=1 width=107,109) (actual time=0.07..0.07 rows=0 loops=1)

12. 0.000 0.069 ↓ 0.0 0 1

Nested Loop (cost=32.6..67.06 rows=1 width=106,523) (actual time=0.069..0.069 rows=0 loops=1)

13. 0.001 0.069 ↓ 0.0 0 1

Nested Loop (cost=32.46..66.8 rows=1 width=105,957) (actual time=0.069..0.069 rows=0 loops=1)

14. 0.000 0.068 ↓ 0.0 0 1

Nested Loop (cost=32.32..64.63 rows=1 width=99,635) (actual time=0.068..0.068 rows=0 loops=1)

15. 0.001 0.068 ↓ 0.0 0 1

Nested Loop (cost=32.18..64.29 rows=1 width=93,321) (actual time=0.068..0.068 rows=0 loops=1)

16. 0.000 0.067 ↓ 0.0 0 1

Nested Loop (cost=32.03..63.82 rows=1 width=92,012) (actual time=0.067..0.067 rows=0 loops=1)

17. 0.000 0.067 ↓ 0.0 0 1

Nested Loop (cost=31.9..63.39 rows=1 width=91,074) (actual time=0.067..0.067 rows=0 loops=1)

18. 0.001 0.067 ↓ 0.0 0 1

Nested Loop (cost=31.9..61.28 rows=1 width=90,128) (actual time=0.067..0.067 rows=0 loops=1)

19. 0.000 0.066 ↓ 0.0 0 1

Nested Loop (cost=31.76..60.45 rows=1 width=88,918) (actual time=0.066..0.066 rows=0 loops=1)

20. 0.000 0.066 ↓ 0.0 0 1

Nested Loop (cost=31.62..59.56 rows=1 width=83,952) (actual time=0.066..0.066 rows=0 loops=1)

21. 0.001 0.066 ↓ 0.0 0 1

Nested Loop (cost=31.48..59.23 rows=1 width=83,929) (actual time=0.066..0.066 rows=0 loops=1)

  • Filter: ((t20.type IS NULL) OR ((t20.type)::text = 'TEST'::text))
22. 0.000 0.065 ↓ 0.0 0 1

Nested Loop (cost=31.34..58.45 rows=1 width=78,230) (actual time=0.065..0.065 rows=0 loops=1)

23. 0.000 0.065 ↓ 0.0 0 1

Nested Loop (cost=31.2..58.03 rows=1 width=76,064) (actual time=0.065..0.065 rows=0 loops=1)

24. 0.001 0.065 ↓ 0.0 0 1

Nested Loop (cost=31.06..57.55 rows=1 width=73,308) (actual time=0.065..0.065 rows=0 loops=1)

25. 0.000 0.064 ↓ 0.0 0 1

Nested Loop (cost=30.91..57.12 rows=1 width=70,081) (actual time=0.064..0.064 rows=0 loops=1)

26. 0.001 0.064 ↓ 0.0 0 1

Nested Loop (cost=30.77..56.83 rows=1 width=70,008) (actual time=0.064..0.064 rows=0 loops=1)

27. 0.000 0.063 ↓ 0.0 0 1

Nested Loop (cost=30.63..56.57 rows=1 width=66,878) (actual time=0.063..0.063 rows=0 loops=1)

28. 0.000 0.063 ↓ 0.0 0 1

Nested Loop (cost=30.49..51.6 rows=1 width=65,712) (actual time=0.063..0.063 rows=0 loops=1)

29. 0.001 0.063 ↓ 0.0 0 1

Nested Loop (cost=30.37..46.65 rows=1 width=53,792) (actual time=0.063..0.063 rows=0 loops=1)

30. 0.000 0.062 ↓ 0.0 0 1

Nested Loop (cost=30.22..46.23 rows=1 width=52,491) (actual time=0.062..0.062 rows=0 loops=1)

31. 0.000 0.062 ↓ 0.0 0 1

Nested Loop (cost=30.08..45.98 rows=1 width=51,886) (actual time=0.062..0.062 rows=0 loops=1)

32. 0.001 0.062 ↓ 0.0 0 1

Nested Loop (cost=29.95..45.66 rows=1 width=48,698) (actual time=0.062..0.062 rows=0 loops=1)

33. 0.000 0.061 ↓ 0.0 0 1

Nested Loop (cost=29.8..44.78 rows=1 width=43,764) (actual time=0.061..0.061 rows=0 loops=1)

34. 0.000 0.061 ↓ 0.0 0 1

Nested Loop (cost=29.66..44.46 rows=1 width=43,759) (actual time=0.061..0.061 rows=0 loops=1)

35. 0.000 0.061 ↓ 0.0 0 1

Nested Loop (cost=29.52..44.14 rows=1 width=42,635) (actual time=0.061..0.061 rows=0 loops=1)

36. 0.001 0.061 ↓ 0.0 0 1

Nested Loop (cost=29.38..43.82 rows=1 width=42,069) (actual time=0.061..0.061 rows=0 loops=1)

37. 0.000 0.060 ↓ 0.0 0 1

Nested Loop (cost=29.25..43.5 rows=1 width=38,881) (actual time=0.06..0.06 rows=0 loops=1)

38. 0.001 0.060 ↓ 0.0 0 1

Nested Loop (cost=29.1..43.16 rows=1 width=32,519) (actual time=0.06..0.06 rows=0 loops=1)

39. 0.000 0.059 ↓ 0.0 0 1

Nested Loop (cost=28.96..42.85 rows=1 width=31,392) (actual time=0.059..0.059 rows=0 loops=1)

40. 0.000 0.059 ↓ 0.0 0 1

Nested Loop (cost=28.81..42.54 rows=1 width=30,067) (actual time=0.059..0.059 rows=0 loops=1)

41. 0.000 0.059 ↓ 0.0 0 1

Nested Loop (cost=28.68..42.31 rows=1 width=29,105) (actual time=0.059..0.059 rows=0 loops=1)

42. 0.012 0.059 ↓ 0.0 0 1

Hash Join (cost=28.54..34.14 rows=1 width=28,776) (actual time=0.059..0.059 rows=0 loops=1)

43. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on delivery_note_line t13 (cost=0..5.16 rows=116 width=2,780) (never executed)

44. 0.000 0.047 ↓ 0.0 0 1

Hash (cost=28.52..28.52 rows=1 width=26,004) (actual time=0.047..0.047 rows=0 loops=1)

45. 0.009 0.047 ↓ 0.0 0 1

Hash Join (cost=24.43..28.52 rows=1 width=26,004) (actual time=0.047..0.047 rows=0 loops=1)

46. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on material t43 (cost=0..3.79 rows=79 width=8,028) (never executed)

47. 0.000 0.038 ↓ 0.0 0 1

Hash (cost=24.42..24.42 rows=1 width=17,984) (actual time=0.038..0.038 rows=0 loops=1)

48. 0.006 0.038 ↓ 0.0 0 1

Hash Join (cost=20.32..24.42 rows=1 width=17,984) (actual time=0.038..0.038 rows=0 loops=1)

49. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on material t30 (cost=0..3.79 rows=79 width=8,076) (never executed)

50. 0.001 0.032 ↓ 0.0 0 1

Hash (cost=20.31..20.31 rows=1 width=9,916) (actual time=0.032..0.032 rows=0 loops=1)

51. 0.007 0.031 ↓ 0.0 0 1

Hash Join (cost=16.22..20.31 rows=1 width=9,916) (actual time=0.031..0.031 rows=0 loops=1)

52. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on material_line_status_time t42 (cost=0..3.51 rows=151 width=102) (never executed)

53. 0.001 0.024 ↓ 0.0 0 1

Hash (cost=16.21..16.21 rows=1 width=9,822) (actual time=0.024..0.024 rows=0 loops=1)

54. 0.006 0.023 ↓ 0.0 0 1

Hash Join (cost=12.13..16.21 rows=1 width=9,822) (actual time=0.023..0.023 rows=0 loops=1)

55. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on order_line t44 (cost=0..3.78 rows=78 width=6,322) (never executed)

56. 0.000 0.017 ↓ 0.0 0 1

Hash (cost=12.11..12.11 rows=1 width=3,508) (actual time=0.017..0.017 rows=0 loops=1)

57. 0.007 0.017 ↓ 0.0 0 1

Hash Join (cost=8.3..12.11 rows=1 width=3,508) (actual time=0.017..0.017 rows=0 loops=1)

58. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on request_group t45 (cost=0..3.31 rows=131 width=1,087) (never executed)

59. 0.000 0.010 ↓ 0.0 0 1

Hash (cost=8.29..8.29 rows=1 width=2,429) (actual time=0.01..0.01 rows=0 loops=1)

60. 0.010 0.010 ↓ 0.0 0 1

Index Scan using i_mtrl_ln_picklist on material_line t0 (cost=0.27..8.29 rows=1 width=2,429) (actual time=0.01..0.01 rows=0 loops=1)

  • Index Cond: (pick_list_oid = 12345)
61. 0.000 0.000 ↓ 0.0 0 0

Index Scan using delivery_information_pkey on delivery_information t1 (cost=0.14..8.16 rows=1 width=337) (never executed)

  • Index Cond: (t0.delivery_information_oid = delivery_information_oid)
62. 0.000 0.000 ↓ 0.0 0 0

Index Scan using i_cstmmnt_deliveryinformation on custom_document t2 (cost=0.13..0.22 rows=1 width=970) (never executed)

  • Index Cond: (t1.delivery_information_oid = delivery_information_oid)
63. 0.000 0.000 ↓ 0.0 0 0

Index Scan using i_rqstlst_deliveryinformation on request_list t8 (cost=0.14..0.3 rows=1 width=1,333) (never executed)

  • Index Cond: (t1.delivery_information_oid = delivery_information_oid)
64. 0.000 0.000 ↓ 0.0 0 0

Index Scan using delivery_note_pkey on delivery_note t14 (cost=0.14..0.3 rows=1 width=1,135) (never executed)

  • Index Cond: (t13.delivery_note_oid = delivery_note_oid)
65. 0.000 0.000 ↓ 0.0 0 0

Index Scan using order_line_pkey on order_line t15 (cost=0.14..0.33 rows=1 width=6,370) (never executed)

  • Index Cond: (t13.order_line_oid = order_line_oid)
66. 0.000 0.000 ↓ 0.0 0 0

Index Scan using change_id_pkey on change_id t31 (cost=0.14..0.31 rows=1 width=3,196) (never executed)

  • Index Cond: (t30.add_change_id_oid = change_id_oid)
67. 0.000 0.000 ↓ 0.0 0 0

Index Scan using finance_header_pkey on finance_header t32 (cost=0.14..0.31 rows=1 width=574) (never executed)

  • Index Cond: (t30.finance_header_oid = finance_header_oid)
68. 0.000 0.000 ↓ 0.0 0 0

Index Scan using material_header_pkey on material_header t33 (cost=0.14..0.31 rows=1 width=1,132) (never executed)

  • Index Cond: (t30.material_header_oid = material_header_oid)
69. 0.000 0.000 ↓ 0.0 0 0

Index Scan using material_last_modified_pkey on material_last_modified t39 (cost=0.14..0.31 rows=1 width=13) (never executed)

  • Index Cond: (t30.material_last_modified_oid = material_last_modified_oid)
70. 0.000 0.000 ↓ 0.0 0 0

Index Scan using procure_line_pkey on procure_line t40 (cost=0.14..0.87 rows=1 width=4,942) (never executed)

  • Index Cond: (t30.procure_line_oid = procure_line_oid)
71. 0.000 0.000 ↓ 0.0 0 0

Index Scan using change_id_pkey on change_id t41 (cost=0.14..0.31 rows=1 width=3,196) (never executed)

  • Index Cond: (t30.remove_change_id_oid = change_id_oid)
72. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pick_list_pkey on pick_list t46 (cost=0.14..0.25 rows=1 width=613) (never executed)

  • Index Cond: (t45.pick_list_oid = pick_list_oid)
73. 0.000 0.000 ↓ 0.0 0 0

Index Scan using request_list_pkey on request_list t47 (cost=0.14..0.41 rows=1 width=1,309) (never executed)

  • Index Cond: (t45.request_list_oid = request_list_oid)
74. 0.000 0.000 ↓ 0.0 0 0

Index Scan using invoice_information_pkey on invoice_information t3 (cost=0.13..4.94 rows=1 width=11,928) (never executed)

  • Index Cond: (t2.invoice_information_oid = invoice_information_oid)
75. 0.000 0.000 ↓ 0.0 0 0

Index Scan using shipping_material_pkey on shipping_material t6 (cost=0.14..4.96 rows=1 width=1,174) (never executed)

  • Index Cond: (t2.shipping_material_oid = shipping_material_oid)
76. 0.000 0.000 ↓ 0.0 0 0

Index Scan using dispatch_note_pkey on dispatch_note t9 (cost=0.14..0.25 rows=1 width=3,138) (never executed)

  • Index Cond: (t8.dispatch_note_oid = dispatch_note_oid)
77. 0.000 0.000 ↓ 0.0 0 0

Index Scan using approval_pkey on approval t10 (cost=0.14..0.28 rows=1 width=81) (never executed)

  • Index Cond: (t8.pending_approval_oid = approval_oid)
78. 0.000 0.000 ↓ 0.0 0 0

Index Scan using order_line_version_pkey on order_line_version t16 (cost=0.14..0.42 rows=1 width=3,235) (never executed)

  • Index Cond: (t15.current_order_line_version_oid = order_line_version_oid)
79. 0.000 0.000 ↓ 0.0 0 0

Index Scan using delivery_note_line_pkey on delivery_note_line t18 (cost=0.14..0.47 rows=1 width=2,764) (never executed)

  • Index Cond: (t15.first_delivery_note_line_oid = delivery_note_line_oid)
80. 0.000 0.000 ↓ 0.0 0 0

Index Scan using orders_pkey on orders t19 (cost=0.14..0.42 rows=1 width=2,174) (never executed)

  • Index Cond: (t15.order_oid = order_oid)
81. 0.000 0.000 ↓ 0.0 0 0

Index Scan using alarm_pkey on alarm t20 (cost=0.14..0.77 rows=1 width=5,707) (never executed)

  • Index Cond: (t15.alarm_oid = alarm_oid)
82. 0.000 0.000 ↓ 0.0 0 0

Index Scan using order_line_last_modified_pkey on order_line_last_modified t22 (cost=0.14..0.31 rows=1 width=31) (never executed)

  • Index Cond: (t15.order_line_last_modified_oid = order_line_last_modified_oid)
83. 0.000 0.000 ↓ 0.0 0 0

Index Scan using procure_line_pkey on procure_line t23 (cost=0.14..0.88 rows=1 width=4,974) (never executed)

  • Index Cond: (t15.procure_line_oid = procure_line_oid)
84. 0.000 0.000 ↓ 0.0 0 0

Index Scan using material_header_version_pkey on material_header_version t34 (cost=0.14..0.82 rows=1 width=1,218) (never executed)

  • Index Cond: (t33.accepted_material_header_version_oid = material_header_version_oid)
85. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on custom_document t4 (cost=0..2.05 rows=5 width=954) (never executed)

86. 0.000 0.000 ↓ 0.0 0 0

Index Scan using custom_document_pkey on custom_document t7 (cost=0.13..0.42 rows=1 width=946) (never executed)

  • Index Cond: (t6.custom_document_oid = custom_document_oid)
87. 0.000 0.000 ↓ 0.0 0 0

Index Scan using request_list_pkey on request_list t11 (cost=0.14..0.46 rows=1 width=1,317) (never executed)

  • Index Cond: (t10.request_list_oid = request_list_oid)
88. 0.000 0.000 ↓ 0.0 0 0

Index Scan using order_line_pkey on order_line t17 (cost=0.14..0.33 rows=1 width=6,322) (never executed)

  • Index Cond: (t16.order_line_oid = order_line_oid)
89. 0.000 0.000 ↓ 0.0 0 0

Index Scan using i_ordr_ln_orderlinealarm on order_line t21 (cost=0.14..2.16 rows=1 width=6,330) (never executed)

  • Index Cond: (t20.alarm_oid = alarm_oid)
90. 0.000 0.000 ↓ 0.0 0 0

Index Scan using finance_header_pkey on finance_header t24 (cost=0.14..0.25 rows=1 width=574) (never executed)

  • Index Cond: (t23.finance_header_oid = finance_header_oid)
91. 0.000 0.000 ↓ 0.0 0 0

Index Scan using part_alias_pkey on part_alias t25 (cost=0.14..0.29 rows=1 width=594) (never executed)

  • Index Cond: (t23.part_alias_oid = part_alias_oid)
92. 0.000 0.000 ↓ 0.0 0 0

Index Scan using requisition_pkey on requisition t27 (cost=0.14..0.38 rows=1 width=2,829) (never executed)

  • Index Cond: (t23.requisition_oid = requisition_oid)
93. 0.000 0.000 ↓ 0.0 0 0

Index Scan using supplier_pkey on supplier t28 (cost=0.14..0.28 rows=1 width=1,159) (never executed)

  • Index Cond: (t23.supplier_oid = supplier_oid)
94. 0.000 0.000 ↓ 0.0 0 0

Index Scan using change_id_pkey on change_id t35 (cost=0.14..0.4 rows=1 width=3,196) (never executed)

  • Index Cond: (t34.change_id_oid = change_id_oid)
95. 0.000 0.000 ↓ 0.0 0 0

Index Scan using material_header_pkey on material_header t36 (cost=0.14..0.4 rows=1 width=1,124) (never executed)

  • Index Cond: (t34.material_header_oid = material_header_oid)
96. 0.000 0.000 ↓ 0.0 0 0

Index Scan using material_header_version_pkey on material_header_version t37 (cost=0.14..0.48 rows=1 width=1,186) (never executed)

  • Index Cond: (t34.previous_accepted_version = material_header_version_oid)
97. 0.000 0.000 ↓ 0.0 0 0

Index Scan using change_id_pkey on change_id t38 (cost=0.14..0.4 rows=1 width=3,196) (never executed)

  • Index Cond: (t34.previous_change_id = change_id_oid)
98. 0.000 0.000 ↓ 0.0 0 0

Index Scan using delivery_information_pkey on delivery_information t5 (cost=0.14..4.96 rows=1 width=337) (never executed)

  • Index Cond: (t4.delivery_information_oid = delivery_information_oid)
99. 0.000 0.000 ↓ 0.0 0 0

Index Scan using delivery_information_pkey on delivery_information t12 (cost=0.14..0.5 rows=1 width=337) (never executed)

  • Index Cond: (t11.delivery_information_oid = delivery_information_oid)
100. 0.000 0.000 ↓ 0.0 0 0

Index Scan using part_number_pkey on part_number t26 (cost=0.14..0.23 rows=1 width=20) (never executed)

  • Index Cond: (t25.part_number_oid = part_number_oid)
101. 0.000 0.000 ↓ 0.0 0 0

Index Scan using procure_line_pkey on procure_line t29 (cost=0.14..0.85 rows=1 width=4,942) (never executed)

  • Index Cond: (t28.procure_line_oid = procure_line_oid)