explain.depesz.com

PostgreSQL's explain analyze made readable

Result: s2cd

Settings
# exclusive inclusive rows x rows loops node
1. 0.056 2.294 ↑ 1.7 710 1

Append (cost=16.74..1,318.87 rows=1,178 width=1,372) (actual time=0.072..2.294 rows=710 loops=1)

2. 0.004 0.131 ↑ 16.7 3 1

Hash Left Join (cost=16.74..37.69 rows=50 width=1,537) (actual time=0.072..0.131 rows=3 loops=1)

  • Hash Cond: (ot."transmissionResponseStateDefRef" = o_trs.id)
3. 0.027 0.124 ↑ 16.7 3 1

Hash Join (cost=15.62..36.34 rows=50 width=1,021) (actual time=0.066..0.124 rows=3 loops=1)

  • Hash Cond: (odo.id = ot."orderRef")
4. 0.045 0.045 ↑ 1.2 318 1

Seq Scan on "OrderDO" odo (cost=0.00..18.79 rows=379 width=55) (actual time=0.004..0.045 rows=318 loops=1)

5. 0.001 0.052 ↑ 16.7 3 1

Hash (cost=15.00..15.00 rows=50 width=974) (actual time=0.052..0.052 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
6. 0.037 0.051 ↑ 16.7 3 1

Hash Right Join (cost=11.12..15.00 rows=50 width=974) (actual time=0.040..0.051 rows=3 loops=1)

  • Hash Cond: (o_tt.id = ot."transmissionTypeDefRef")
7. 0.008 0.008 ↑ 1.0 100 1

Seq Scan on "TransmissionTypeDefDO" o_tt (cost=0.00..3.00 rows=100 width=28) (actual time=0.002..0.008 rows=100 loops=1)

8. 0.002 0.006 ↑ 16.7 3 1

Hash (cost=10.50..10.50 rows=50 width=950) (actual time=0.006..0.006 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
9. 0.004 0.004 ↑ 16.7 3 1

Seq Scan on "OrderTransmissionDO" ot (cost=0.00..10.50 rows=50 width=950) (actual time=0.003..0.004 rows=3 loops=1)

10. 0.003 0.003 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=520) (actual time=0.003..0.003 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
11. 0.000 0.000 ↑ 1.0 5 1

Seq Scan on "TransmissionResponseStateDefDO" o_trs (cost=0.00..1.05 rows=5 width=520) (actual time=0.000..0.000 rows=5 loops=1)

12. 0.000 0.166 ↓ 0.0 0 1

Nested Loop Left Join (cost=23.80..45.94 rows=1 width=1,312) (actual time=0.166..0.166 rows=0 loops=1)

13. 0.000 0.166 ↓ 0.0 0 1

Nested Loop Left Join (cost=23.66..45.72 rows=1 width=1,288) (actual time=0.166..0.166 rows=0 loops=1)

14. 0.018 0.166 ↓ 0.0 0 1

Hash Join (cost=23.53..45.53 rows=1 width=772) (actual time=0.166..0.166 rows=0 loops=1)

  • Hash Cond: (it."orderRef" = odo_1.id)
15. 0.050 0.050 ↑ 1.0 351 1

Seq Scan on "InvoicingTransmissionDO" it (cost=0.00..20.63 rows=363 width=725) (actual time=0.003..0.050 rows=351 loops=1)

16. 0.031 0.098 ↑ 1.2 318 1

Hash (cost=18.79..18.79 rows=379 width=55) (actual time=0.098..0.098 rows=318 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 36kB
17. 0.067 0.067 ↑ 1.2 318 1

Seq Scan on "OrderDO" odo_1 (cost=0.00..18.79 rows=379 width=55) (actual time=0.002..0.067 rows=318 loops=1)

18. 0.000 0.000 ↓ 0.0 0

Index Scan using "TransmissionResponseStateDefDO_pkey" on "TransmissionResponseStateDefDO" i_trs (cost=0.13..0.18 rows=1 width=520) (never executed)

  • Index Cond: (it."transmissionResponseStateDefRef" = id)
19. 0.000 0.000 ↓ 0.0 0

Index Scan using "TransmissionTypeDefDO_pkey" on "TransmissionTypeDefDO" i_tt (cost=0.14..0.20 rows=1 width=28) (never executed)

  • Index Cond: (it."transmissionTypeDefRef" = id)
20. 0.076 0.529 ↓ 1.1 351 1

Hash Left Join (cost=42.95..78.09 rows=314 width=1,312) (actual time=0.181..0.529 rows=351 loops=1)

  • Hash Cond: (i2o."orderRef" = odo_2.id)
21. 0.077 0.368 ↓ 1.1 351 1

Hash Left Join (cost=19.43..50.24 rows=314 width=1,273) (actual time=0.093..0.368 rows=351 loops=1)

  • Hash Cond: (it_1."transmissionTypeDefRef" = i_tt_1.id)
22. 0.059 0.272 ↓ 1.1 351 1

Hash Left Join (cost=15.18..41.68 rows=314 width=1,249) (actual time=0.073..0.272 rows=351 loops=1)

  • Hash Cond: (it_1."transmissionResponseStateDefRef" = i_trs_1.id)
23. 0.098 0.211 ↓ 1.1 351 1

Hash Join (cost=14.07..39.20 rows=314 width=733) (actual time=0.068..0.211 rows=351 loops=1)

  • Hash Cond: (it_1."invoicingRef" = i2o."invoicingRef")
24. 0.050 0.050 ↑ 1.0 351 1

Seq Scan on "InvoicingTransmissionDO" it_1 (cost=0.00..20.63 rows=363 width=733) (actual time=0.001..0.050 rows=351 loops=1)

25. 0.028 0.063 ↓ 1.1 361 1

Hash (cost=10.14..10.14 rows=314 width=16) (actual time=0.063..0.063 rows=361 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
26. 0.035 0.035 ↓ 1.1 361 1

Seq Scan on "Invoicing2OrderDO" i2o (cost=0.00..10.14 rows=314 width=16) (actual time=0.003..0.035 rows=361 loops=1)

27. 0.001 0.002 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=520) (actual time=0.002..0.002 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
28. 0.001 0.001 ↑ 1.0 5 1

Seq Scan on "TransmissionResponseStateDefDO" i_trs_1 (cost=0.00..1.05 rows=5 width=520) (actual time=0.001..0.001 rows=5 loops=1)

29. 0.009 0.019 ↑ 1.0 100 1

Hash (cost=3.00..3.00 rows=100 width=28) (actual time=0.019..0.019 rows=100 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
30. 0.010 0.010 ↑ 1.0 100 1

Seq Scan on "TransmissionTypeDefDO" i_tt_1 (cost=0.00..3.00 rows=100 width=28) (actual time=0.001..0.010 rows=100 loops=1)

31. 0.030 0.085 ↑ 1.2 318 1

Hash (cost=18.79..18.79 rows=379 width=47) (actual time=0.085..0.085 rows=318 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 34kB
32. 0.055 0.055 ↑ 1.2 318 1

Seq Scan on "OrderDO" odo_2 (cost=0.00..18.79 rows=379 width=47) (actual time=0.001..0.055 rows=318 loops=1)

33. 0.105 1.109 ↓ 1.0 350 1

Hash Join (cost=77.53..122.07 rows=345 width=1,090) (actual time=0.436..1.109 rows=350 loops=1)

  • Hash Cond: (scm."orderRef" = odo_3.id)
34. 0.042 0.904 ↓ 1.0 350 1

Hash Left Join (cost=54.00..93.80 rows=345 width=1,043) (actual time=0.331..0.904 rows=350 loops=1)

  • Hash Cond: (scm."returnAnnouncementRef" = scm_retando.id)
35. 0.084 0.852 ↓ 1.0 350 1

Hash Left Join (cost=52.24..90.73 rows=345 width=1,043) (actual time=0.319..0.852 rows=350 loops=1)

  • Hash Cond: (scm."returnRef" = scm_retdo.id)
36. 0.068 0.751 ↓ 1.0 350 1

Hash Left Join (cost=49.25..86.44 rows=345 width=1,043) (actual time=0.299..0.751 rows=350 loops=1)

  • Hash Cond: (scm."dispatchRef" = scm_ddo.id)
37. 0.052 0.639 ↓ 1.0 350 1

Hash Left Join (cost=40.88..75.42 rows=345 width=1,043) (actual time=0.252..0.639 rows=350 loops=1)

  • Hash Cond: (scm."responseRef" = scm_rdo.id)
38. 0.061 0.492 ↓ 1.0 350 1

Hash Left Join (cost=23.25..56.49 rows=345 width=1,043) (actual time=0.154..0.492 rows=350 loops=1)

  • Hash Cond: (scm."documentRef" = scm_d.id)
39. 0.082 0.330 ↓ 1.0 350 1

Hash Left Join (cost=5.36..37.30 rows=345 width=1,043) (actual time=0.030..0.330 rows=350 loops=1)

  • Hash Cond: (scm."transmissionTypeDefRef" = scm_tt.id)
40. 0.158 0.229 ↓ 1.0 350 1

Hash Left Join (cost=1.11..28.31 rows=345 width=1,019) (actual time=0.008..0.229 rows=350 loops=1)

  • Hash Cond: (scm."transmissionResponseStateDefRef" = scm_trs.id)
41. 0.068 0.068 ↓ 1.0 350 1

Seq Scan on "ShopCustomerMailTransmissionDO" scm (cost=0.00..22.45 rows=345 width=503) (actual time=0.002..0.068 rows=350 loops=1)

42. 0.002 0.003 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=520) (actual time=0.003..0.003 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
43. 0.001 0.001 ↑ 1.0 5 1

Seq Scan on "TransmissionResponseStateDefDO" scm_trs (cost=0.00..1.05 rows=5 width=520) (actual time=0.001..0.001 rows=5 loops=1)

44. 0.014 0.019 ↑ 1.0 100 1

Hash (cost=3.00..3.00 rows=100 width=28) (actual time=0.019..0.019 rows=100 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
45. 0.005 0.005 ↑ 1.0 100 1

Seq Scan on "TransmissionTypeDefDO" scm_tt (cost=0.00..3.00 rows=100 width=28) (actual time=0.001..0.005 rows=100 loops=1)

46. 0.033 0.101 ↓ 1.1 328 1

Hash (cost=14.06..14.06 rows=306 width=16) (actual time=0.101..0.101 rows=328 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
47. 0.068 0.068 ↓ 1.1 328 1

Seq Scan on "DocumentDO" scm_d (cost=0.00..14.06 rows=306 width=16) (actual time=0.004..0.068 rows=328 loops=1)

48. 0.031 0.095 ↓ 1.0 347 1

Hash (cost=13.39..13.39 rows=339 width=16) (actual time=0.095..0.095 rows=347 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
49. 0.064 0.064 ↓ 1.0 347 1

Seq Scan on "ResponseDO" scm_rdo (cost=0.00..13.39 rows=339 width=16) (actual time=0.003..0.064 rows=347 loops=1)

50. 0.019 0.044 ↓ 1.0 151 1

Hash (cost=6.50..6.50 rows=150 width=16) (actual time=0.044..0.044 rows=151 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
51. 0.025 0.025 ↓ 1.0 151 1

Seq Scan on "DispatchDO" scm_ddo (cost=0.00..6.50 rows=150 width=16) (actual time=0.003..0.025 rows=151 loops=1)

52. 0.005 0.017 ↓ 1.1 48 1

Hash (cost=2.44..2.44 rows=44 width=16) (actual time=0.017..0.017 rows=48 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
53. 0.012 0.012 ↓ 1.1 48 1

Seq Scan on "ReturnDO" scm_retdo (cost=0.00..2.44 rows=44 width=16) (actual time=0.002..0.012 rows=48 loops=1)

54. 0.005 0.010 ↓ 1.1 36 1

Hash (cost=1.34..1.34 rows=34 width=16) (actual time=0.010..0.010 rows=36 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
55. 0.005 0.005 ↓ 1.1 36 1

Seq Scan on "ReturnAnnouncementDO" scm_retando (cost=0.00..1.34 rows=34 width=16) (actual time=0.002..0.005 rows=36 loops=1)

56. 0.032 0.100 ↑ 1.2 318 1

Hash (cost=18.79..18.79 rows=379 width=55) (actual time=0.100..0.100 rows=318 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 36kB
57. 0.068 0.068 ↑ 1.2 318 1

Seq Scan on "OrderDO" odo_3 (cost=0.00..18.79 rows=379 width=55) (actual time=0.002..0.068 rows=318 loops=1)

58. 0.000 0.017 ↓ 0.0 0 1

Hash Left Join (cost=18.75..40.87 rows=34 width=1,537) (actual time=0.017..0.017 rows=0 loops=1)

  • Hash Cond: (rmat."transmissionResponseStateDefRef" = rmat_trs.id)
59. 0.004 0.017 ↓ 0.0 0 1

Hash Join (cost=17.63..39.61 rows=34 width=1,021) (actual time=0.017..0.017 rows=0 loops=1)

  • Hash Cond: (odo_4.id = rma."orderRef")
60. 0.002 0.002 ↑ 379.0 1 1

Seq Scan on "OrderDO" odo_4 (cost=0.00..18.79 rows=379 width=55) (actual time=0.002..0.002 rows=1 loops=1)

61. 0.007 0.011 ↓ 0.0 0 1

Hash (cost=17.21..17.21 rows=34 width=974) (actual time=0.011..0.011 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
62. 0.003 0.004 ↓ 0.0 0 1

Hash Right Join (cost=13.49..17.21 rows=34 width=974) (actual time=0.004..0.004 rows=0 loops=1)

  • Hash Cond: (rmat_tt.id = rmat."transmissionTypeDefRef")
63. 0.000 0.000 ↓ 0.0 0

Seq Scan on "TransmissionTypeDefDO" rmat_tt (cost=0.00..3.00 rows=100 width=28) (never executed)

64. 0.000 0.001 ↓ 0.0 0 1

Hash (cost=13.07..13.07 rows=34 width=950) (actual time=0.001..0.001 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
65. 0.001 0.001 ↓ 0.0 0 1

Hash Join (cost=1.77..13.07 rows=34 width=950) (actual time=0.001..0.001 rows=0 loops=1)

  • Hash Cond: (rmat."returnAnnouncementRef" = rma.id)
66. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on "ReturnAnnouncementTransmissionDO" rmat (cost=0.00..10.70 rows=70 width=942) (actual time=0.000..0.000 rows=0 loops=1)

67. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.34..1.34 rows=34 width=24) (never executed)

68. 0.000 0.000 ↓ 0.0 0

Seq Scan on "ReturnAnnouncementDO" rma (cost=0.00..1.34 rows=34 width=24) (never executed)

69. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.05..1.05 rows=5 width=520) (never executed)

70. 0.000 0.000 ↓ 0.0 0

Seq Scan on "TransmissionResponseStateDefDO" rmat_trs (cost=0.00..1.05 rows=5 width=520) (never executed)

71. 0.004 0.112 ↑ 7.3 6 1

Hash Left Join (cost=20.56..42.35 rows=44 width=1,537) (actual time=0.078..0.112 rows=6 loops=1)

  • Hash Cond: (rtt."transmissionResponseStateDefRef" = rtt_trs.id)
72. 0.023 0.105 ↑ 7.3 6 1

Hash Join (cost=19.45..41.04 rows=44 width=1,021) (actual time=0.072..0.105 rows=6 loops=1)

  • Hash Cond: (odo_5.id = rt."orderRef")
73. 0.034 0.034 ↑ 1.2 318 1

Seq Scan on "OrderDO" odo_5 (cost=0.00..18.79 rows=379 width=55) (actual time=0.001..0.034 rows=318 loops=1)

74. 0.002 0.048 ↑ 7.3 6 1

Hash (cost=18.89..18.89 rows=44 width=974) (actual time=0.048..0.048 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
75. 0.009 0.046 ↑ 7.3 6 1

Hash Right Join (cost=15.08..18.89 rows=44 width=974) (actual time=0.039..0.046 rows=6 loops=1)

  • Hash Cond: (rtt_tt.id = rtt."transmissionTypeDefRef")
76. 0.008 0.008 ↑ 1.0 100 1

Seq Scan on "TransmissionTypeDefDO" rtt_tt (cost=0.00..3.00 rows=100 width=28) (actual time=0.002..0.008 rows=100 loops=1)

77. 0.002 0.029 ↑ 7.3 6 1

Hash (cost=14.53..14.53 rows=44 width=950) (actual time=0.029..0.029 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
78. 0.006 0.027 ↑ 7.3 6 1

Hash Join (cost=2.99..14.53 rows=44 width=950) (actual time=0.024..0.027 rows=6 loops=1)

  • Hash Cond: (rtt."returnRef" = rt.id)
79. 0.004 0.004 ↑ 13.3 6 1

Seq Scan on "ReturnTransmissionDO" rtt (cost=0.00..10.80 rows=80 width=942) (actual time=0.004..0.004 rows=6 loops=1)

80. 0.008 0.017 ↓ 1.1 48 1

Hash (cost=2.44..2.44 rows=44 width=24) (actual time=0.017..0.017 rows=48 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
81. 0.009 0.009 ↓ 1.1 48 1

Seq Scan on "ReturnDO" rt (cost=0.00..2.44 rows=44 width=24) (actual time=0.002..0.009 rows=48 loops=1)

82. 0.003 0.003 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=520) (actual time=0.003..0.003 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
83. 0.000 0.000 ↑ 1.0 5 1

Seq Scan on "TransmissionResponseStateDefDO" rtt_trs (cost=0.00..1.05 rows=5 width=520) (actual time=0.000..0.000 rows=5 loops=1)

84. 0.000 0.003 ↓ 0.0 0 1

Hash Left Join (cost=28.74..51.88 rows=70 width=1,525) (actual time=0.003..0.003 rows=0 loops=1)

  • Hash Cond: (pnt."transmissionTypeDefRef" = pnt_tt.id)
85. 0.001 0.003 ↓ 0.0 0 1

Hash Left Join (cost=24.49..46.66 rows=70 width=1,501) (actual time=0.003..0.003 rows=0 loops=1)

  • Hash Cond: (pnt."transmissionResponseStateDefRef" = pnt_trs.id)
86. 0.002 0.002 ↓ 0.0 0 1

Hash Join (cost=23.38..45.25 rows=70 width=985) (actual time=0.002..0.002 rows=0 loops=1)

  • Hash Cond: (pn.id = pnt."paymentNotificationRef")
87. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=11.57..32.49 rows=70 width=63) (never executed)

  • Hash Cond: (odo_6.id = pn."orderRef")
88. 0.000 0.000 ↓ 0.0 0

Seq Scan on "OrderDO" odo_6 (cost=0.00..18.79 rows=379 width=55) (never executed)

89. 0.000 0.000 ↓ 0.0 0

Hash (cost=10.70..10.70 rows=70 width=16) (never executed)

90. 0.000 0.000 ↓ 0.0 0

Seq Scan on "PaymentNotificationDO" pn (cost=0.00..10.70 rows=70 width=16) (never executed)

91. 0.000 0.000 ↓ 0.0 0 1

Hash (cost=10.80..10.80 rows=80 width=938) (actual time=0.000..0.000 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
92. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on "PaymentNotificationTransmissionDO" pnt (cost=0.00..10.80 rows=80 width=938) (actual time=0.000..0.000 rows=0 loops=1)

93. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.05..1.05 rows=5 width=520) (never executed)

94. 0.000 0.000 ↓ 0.0 0

Seq Scan on "TransmissionResponseStateDefDO" pnt_trs (cost=0.00..1.05 rows=5 width=520) (never executed)

95. 0.000 0.000 ↓ 0.0 0

Hash (cost=3.00..3.00 rows=100 width=28) (never executed)

96. 0.000 0.000 ↓ 0.0 0

Seq Scan on "TransmissionTypeDefDO" pnt_tt (cost=0.00..3.00 rows=100 width=28) (never executed)

97. 0.000 0.002 ↓ 0.0 0 1

Hash Left Join (cost=28.96..52.52 rows=80 width=1,537) (actual time=0.002..0.002 rows=0 loops=1)

  • Hash Cond: (rrt."transmissionTypeDefRef" = rrt_tt.id)
98. 0.000 0.002 ↓ 0.0 0 1

Hash Left Join (cost=24.71..47.17 rows=80 width=1,513) (actual time=0.002..0.002 rows=0 loops=1)

  • Hash Cond: (rrt."transmissionResponseStateDefRef" = rrt_trs.id)
99. 0.002 0.002 ↓ 0.0 0 1

Hash Join (cost=23.60..45.71 rows=80 width=997) (actual time=0.002..0.002 rows=0 loops=1)

  • Hash Cond: (rr.id = rrt."returnRequestRef")
100. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=11.80..32.81 rows=80 width=71) (never executed)

  • Hash Cond: (odo_7.id = rr."orderRef")
101. 0.000 0.000 ↓ 0.0 0

Seq Scan on "OrderDO" odo_7 (cost=0.00..18.79 rows=379 width=55) (never executed)

102. 0.000 0.000 ↓ 0.0 0

Hash (cost=10.80..10.80 rows=80 width=24) (never executed)

103. 0.000 0.000 ↓ 0.0 0

Seq Scan on "ReturnRequestDO" rr (cost=0.00..10.80 rows=80 width=24) (never executed)

104. 0.000 0.000 ↓ 0.0 0 1

Hash (cost=10.80..10.80 rows=80 width=942) (actual time=0.000..0.000 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
105. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on "ReturnRequestTransmissionDO" rrt (cost=0.00..10.80 rows=80 width=942) (actual time=0.000..0.000 rows=0 loops=1)

106. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.05..1.05 rows=5 width=520) (never executed)

107. 0.000 0.000 ↓ 0.0 0

Seq Scan on "TransmissionResponseStateDefDO" rrt_trs (cost=0.00..1.05 rows=5 width=520) (never executed)

108. 0.000 0.000 ↓ 0.0 0

Hash (cost=3.00..3.00 rows=100 width=28) (never executed)

109. 0.000 0.000 ↓ 0.0 0

Seq Scan on "TransmissionTypeDefDO" rrt_tt (cost=0.00..3.00 rows=100 width=28) (never executed)

110. 0.000 0.008 ↓ 0.0 0 1

Hash Left Join (cost=33.62..56.09 rows=80 width=1,537) (actual time=0.008..0.008 rows=0 loops=1)

  • Hash Cond: (rspt."transmissionTypeDefRef" = rspt_tt.id)
111. 0.001 0.008 ↓ 0.0 0 1

Hash Left Join (cost=29.37..50.74 rows=80 width=1,513) (actual time=0.008..0.008 rows=0 loops=1)

  • Hash Cond: (rspt."transmissionResponseStateDefRef" = rspt_trs.id)
112. 0.002 0.007 ↓ 0.0 0 1

Hash Right Join (cost=28.26..49.27 rows=80 width=997) (actual time=0.007..0.007 rows=0 loops=1)

  • Hash Cond: (odo_8.id = rsp."orderRef")
113. 0.000 0.000 ↓ 0.0 0

Seq Scan on "OrderDO" odo_8 (cost=0.00..18.79 rows=379 width=55) (never executed)

114. 0.000 0.005 ↓ 0.0 0 1

Hash (cost=27.26..27.26 rows=80 width=950) (actual time=0.005..0.005 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
115. 0.001 0.005 ↓ 0.0 0 1

Hash Join (cost=11.80..27.26 rows=80 width=950) (actual time=0.005..0.005 rows=0 loops=1)

  • Hash Cond: (rsp.id = rspt."responseRef")
116. 0.003 0.003 ↑ 339.0 1 1

Seq Scan on "ResponseDO" rsp (cost=0.00..13.39 rows=339 width=24) (actual time=0.003..0.003 rows=1 loops=1)

117. 0.001 0.001 ↓ 0.0 0 1

Hash (cost=10.80..10.80 rows=80 width=942) (actual time=0.001..0.001 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
118. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on "ResponseTransmissionDO" rspt (cost=0.00..10.80 rows=80 width=942) (actual time=0.000..0.000 rows=0 loops=1)

119. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.05..1.05 rows=5 width=520) (never executed)

120. 0.000 0.000 ↓ 0.0 0

Seq Scan on "TransmissionResponseStateDefDO" rspt_trs (cost=0.00..1.05 rows=5 width=520) (never executed)

121. 0.000 0.000 ↓ 0.0 0

Hash (cost=3.00..3.00 rows=100 width=28) (never executed)

122. 0.000 0.000 ↓ 0.0 0

Seq Scan on "TransmissionTypeDefDO" rspt_tt (cost=0.00..3.00 rows=100 width=28) (never executed)

123. 0.001 0.009 ↓ 0.0 0 1

Hash Left Join (cost=26.03..48.96 rows=80 width=1,537) (actual time=0.009..0.009 rows=0 loops=1)

  • Hash Cond: (dspt."transmissionTypeDefRef" = dspt_tt.id)
124. 0.000 0.008 ↓ 0.0 0 1

Hash Left Join (cost=21.78..43.61 rows=80 width=1,513) (actual time=0.008..0.008 rows=0 loops=1)

  • Hash Cond: (dspt."transmissionResponseStateDefRef" = dspt_trs.id)
125. 0.002 0.008 ↓ 0.0 0 1

Hash Join (cost=20.66..42.15 rows=80 width=997) (actual time=0.008..0.008 rows=0 loops=1)

  • Hash Cond: (odo_9.id = dsp."orderRef")
126. 0.001 0.001 ↑ 379.0 1 1

Seq Scan on "OrderDO" odo_9 (cost=0.00..18.79 rows=379 width=55) (actual time=0.001..0.001 rows=1 loops=1)

127. 0.000 0.005 ↓ 0.0 0 1

Hash (cost=19.66..19.66 rows=80 width=950) (actual time=0.005..0.005 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
128. 0.002 0.005 ↓ 0.0 0 1

Hash Join (cost=11.80..19.66 rows=80 width=950) (actual time=0.005..0.005 rows=0 loops=1)

  • Hash Cond: (dsp.id = dspt."dispatchRef")
129. 0.002 0.002 ↑ 150.0 1 1

Seq Scan on "DispatchDO" dsp (cost=0.00..6.50 rows=150 width=24) (actual time=0.002..0.002 rows=1 loops=1)

130. 0.000 0.001 ↓ 0.0 0 1

Hash (cost=10.80..10.80 rows=80 width=942) (actual time=0.001..0.001 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
131. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on "DispatchTransmissionDO" dspt (cost=0.00..10.80 rows=80 width=942) (actual time=0.001..0.001 rows=0 loops=1)

132. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.05..1.05 rows=5 width=520) (never executed)

133. 0.000 0.000 ↓ 0.0 0

Seq Scan on "TransmissionResponseStateDefDO" dspt_trs (cost=0.00..1.05 rows=5 width=520) (never executed)

134. 0.000 0.000 ↓ 0.0 0

Hash (cost=3.00..3.00 rows=100 width=28) (never executed)

135. 0.000 0.000 ↓ 0.0 0

Seq Scan on "TransmissionTypeDefDO" dspt_tt (cost=0.00..3.00 rows=100 width=28) (never executed)

136. 0.001 0.152 ↓ 0.0 0 1

Hash Join (cost=47.87..730.65 rows=80 width=1,537) (actual time=0.152..0.152 rows=0 loops=1)

  • Hash Cond: (($3) = odo_10.id)
137. 0.000 0.007 ↓ 0.0 0 1

Hash Left Join (cost=24.34..706.02 rows=80 width=1,490) (actual time=0.007..0.007 rows=0 loops=1)

  • Hash Cond: (dctt."transmissionTypeDefRef" = dctt_tt.id)
138. 0.001 0.007 ↓ 0.0 0 1

Nested Loop Left Join (cost=20.09..700.67 rows=80 width=1,466) (actual time=0.007..0.007 rows=0 loops=1)

  • Join Filter: (dctt."transmissionResponseStateDefRef" = dctt_trs.id)
139. 0.000 0.006 ↓ 0.0 0 1

Nested Loop (cost=20.09..693.61 rows=80 width=950) (actual time=0.006..0.006 rows=0 loops=1)

140. 0.002 0.006 ↓ 0.0 0 1

Hash Join (cost=11.80..27.81 rows=80 width=950) (actual time=0.006..0.006 rows=0 loops=1)

  • Hash Cond: (dct.id = dctt."documentRef")
141. 0.003 0.003 ↑ 306.0 1 1

Seq Scan on "DocumentDO" dct (cost=0.00..14.06 rows=306 width=16) (actual time=0.003..0.003 rows=1 loops=1)

142. 0.000 0.001 ↓ 0.0 0 1

Hash (cost=10.80..10.80 rows=80 width=942) (actual time=0.001..0.001 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
143. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on "DocumentTransmissionDO" dctt (cost=0.00..10.80 rows=80 width=942) (actual time=0.001..0.001 rows=0 loops=1)

144. 0.000 0.000 ↓ 0.0 0

Result (cost=8.29..8.30 rows=1 width=0) (never executed)

145.          

Initplan (forResult)

146. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.27..8.29 rows=1 width=8) (never executed)

147. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "Document2OrderDO_pkey" on "Document2OrderDO" dct2o (cost=0.27..8.29 rows=1 width=8) (never executed)

  • Index Cond: (("documentRef" = $2) AND ("orderRef" IS NOT NULL))
  • Heap Fetches: 0
148. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..1.07 rows=5 width=520) (never executed)

149. 0.000 0.000 ↓ 0.0 0

Seq Scan on "TransmissionResponseStateDefDO" dctt_trs (cost=0.00..1.05 rows=5 width=520) (never executed)

150. 0.000 0.000 ↓ 0.0 0

Hash (cost=3.00..3.00 rows=100 width=28) (never executed)

151. 0.000 0.000 ↓ 0.0 0

Seq Scan on "TransmissionTypeDefDO" dctt_tt (cost=0.00..3.00 rows=100 width=28) (never executed)

152. 0.049 0.144 ↑ 1.2 318 1

Hash (cost=18.79..18.79 rows=379 width=55) (actual time=0.144..0.144 rows=318 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 36kB
153. 0.095 0.095 ↑ 1.2 318 1

Seq Scan on "OrderDO" odo_10 (cost=0.00..18.79 rows=379 width=55) (actual time=0.001..0.095 rows=318 loops=1)