explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KPL3

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 26.831 ↓ 0.0 0 1

GroupAggregate (cost=387.06..387.13 rows=1 width=2,768) (actual time=26.830..26.831 rows=0 loops=1)

  • Group Key: resultset.woid, resultset.nokwitansi, resultset.nopolisi, resultset.unittypename, resultset.mechanicname, resultset.kategori
2. 0.047 26.825 ↓ 0.0 0 1

Sort (cost=387.06..387.06 rows=1 width=2,740) (actual time=26.824..26.825 rows=0 loops=1)

  • Sort Key: resultset.woid, resultset.nokwitansi, resultset.nopolisi, resultset.unittypename, resultset.mechanicname, resultset.kategori
  • Sort Method: quicksort Memory: 25kB
3. 0.003 26.778 ↓ 0.0 0 1

Subquery Scan on resultset (cost=387.03..387.05 rows=1 width=2,740) (actual time=26.777..26.778 rows=0 loops=1)

4. 0.013 26.775 ↓ 0.0 0 1

Sort (cost=387.03..387.04 rows=1 width=12,051) (actual time=26.775..26.775 rows=0 loops=1)

  • Sort Key: dp.woid
  • Sort Method: quicksort Memory: 25kB
5.          

CTE datapool_domain

6. 0.005 26.722 ↓ 0.0 0 1

Hash Join (cost=12.57..30.10 rows=1 width=3,116) (actual time=26.721..26.722 rows=0 loops=1)

  • Hash Cond: ((r_1.woid)::text = (r.woid)::text)
7. 26.717 26.717 ↓ 0.0 0 1

Function Scan on dblink r_1 (cost=0.00..17.50 rows=5 width=1,036) (actual time=26.716..26.717 rows=0 loops=1)

  • Filter: (to_char((paymentdate)::timestamp with time zone, 'dd/MM/yyyy'::text) = '01/01/2020'::text)
  • Rows Removed by Filter: 4920
8. 0.000 0.000 ↓ 0.0 0

Hash (cost=12.50..12.50 rows=5 width=2,596) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Function Scan on dblink r (cost=0.00..12.50 rows=5 width=2,596) (never executed)

  • Filter: ((wolastknownstate)::text = 'COMPLETE'::text)
10.          

CTE kpb

11. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=11.94..11.97 rows=1 width=525) (never executed)

  • Group Key: dp_1.woid
12. 0.000 0.000 ↓ 0.0 0

Sort (cost=11.94..11.95 rows=2 width=524) (never executed)

  • Sort Key: dp_1.woid
13. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=0.04..11.93 rows=2 width=524) (never executed)

  • Hash Cond: ((r_2.woid)::text = (dp_1.woid)::text)
14. 0.000 0.000 ↓ 0.0 0

Function Scan on dblink r_2 (cost=0.00..10.00 rows=500 width=524) (never executed)

  • Filter: (kpb IS TRUE)
15. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.02..0.02 rows=1 width=516) (never executed)

16. 0.000 0.000 ↓ 0.0 0

CTE Scan on datapool_domain dp_1 (cost=0.00..0.02 rows=1 width=516) (never executed)

17.          

CTE c2jasa

18. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=11.94..11.97 rows=1 width=525) (never executed)

  • Group Key: dp_2.woid
19. 0.000 0.000 ↓ 0.0 0

Sort (cost=11.94..11.95 rows=2 width=524) (never executed)

  • Sort Key: dp_2.woid
20. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=0.04..11.93 rows=2 width=524) (never executed)

  • Hash Cond: ((r_3.woid)::text = (dp_2.woid)::text)
21. 0.000 0.000 ↓ 0.0 0

Function Scan on dblink r_3 (cost=0.00..10.00 rows=500 width=524) (never executed)

  • Filter: (c2 IS TRUE)
22. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.02..0.02 rows=1 width=516) (never executed)

23. 0.000 0.000 ↓ 0.0 0

CTE Scan on datapool_domain dp_2 (cost=0.00..0.02 rows=1 width=516) (never executed)

24.          

CTE c2part

25. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=25.97..26.06 rows=1 width=525) (never executed)

  • Group Key: dp_3.woid
26. 0.000 0.000 ↓ 0.0 0

Sort (cost=25.97..26.00 rows=10 width=524) (never executed)

  • Sort Key: dp_3.woid
27. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=11.96..25.81 rows=10 width=524) (never executed)

  • Hash Cond: ((r_5.code)::text = (r_4.partid)::text)
28. 0.000 0.000 ↓ 0.0 0

Function Scan on dblink r_5 (cost=0.00..10.00 rows=1,000 width=524) (never executed)

29. 0.000 0.000 ↓ 0.0 0

Hash (cost=11.93..11.93 rows=2 width=1,032) (never executed)

30. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=0.04..11.93 rows=2 width=1,032) (never executed)

  • Hash Cond: ((r_4.woid)::text = (dp_3.woid)::text)
31. 0.000 0.000 ↓ 0.0 0

Function Scan on dblink r_4 (cost=0.00..10.00 rows=500 width=1,032) (never executed)

  • Filter: (c2 IS TRUE)
32. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.02..0.02 rows=1 width=516) (never executed)

33. 0.000 0.000 ↓ 0.0 0

CTE Scan on datapool_domain dp_3 (cost=0.00..0.02 rows=1 width=516) (never executed)

34.          

CTE jasa

35. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=13.89..13.94 rows=1 width=524) (never executed)

  • Group Key: dp_4.woid
36. 0.000 0.000 ↓ 0.0 0

Sort (cost=13.89..13.91 rows=5 width=524) (never executed)

  • Sort Key: dp_4.woid
37. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=0.04..13.84 rows=5 width=524) (never executed)

  • Hash Cond: ((r_6.woid)::text = (dp_4.woid)::text)
38. 0.000 0.000 ↓ 0.0 0

Function Scan on dblink r_6 (cost=0.00..10.00 rows=1,000 width=524) (never executed)

39. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.02..0.02 rows=1 width=516) (never executed)

40. 0.000 0.000 ↓ 0.0 0

CTE Scan on datapool_domain dp_4 (cost=0.00..0.02 rows=1 width=516) (never executed)

41.          

CTE partoli

42. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=32.78..32.80 rows=1 width=524) (never executed)

  • Group Key: dp_5.woid
43. 0.000 0.000 ↓ 0.0 0

Sort (cost=32.78..32.79 rows=1 width=524) (never executed)

  • Sort Key: dp_5.woid
44. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=13.90..32.77 rows=1 width=524) (never executed)

  • Hash Cond: ((r_8.code)::text = (r_7.partid)::text)
45. 0.000 0.000 ↓ 0.0 0

Function Scan on dblink r_8 (cost=0.00..18.75 rows=30 width=516) (never executed)

  • Filter: (((largepartgroup)::text = 'OLI'::text) OR ((partgroup)::text = ANY ('{ACB,ACG,GMO,OIL,FLUID}'::text[])))
46. 0.000 0.000 ↓ 0.0 0

Hash (cost=13.84..13.84 rows=5 width=1,040) (never executed)

47. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=0.04..13.84 rows=5 width=1,040) (never executed)

  • Hash Cond: ((r_7.woid)::text = (dp_5.woid)::text)
48. 0.000 0.000 ↓ 0.0 0

Function Scan on dblink r_7 (cost=0.00..10.00 rows=1,000 width=1,040) (never executed)

49. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.02..0.02 rows=1 width=516) (never executed)

50. 0.000 0.000 ↓ 0.0 0

CTE Scan on datapool_domain dp_5 (cost=0.00..0.02 rows=1 width=516) (never executed)

51.          

CTE partban

52. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=28.91..28.93 rows=1 width=524) (never executed)

  • Group Key: dp_6.woid
53. 0.000 0.000 ↓ 0.0 0

Sort (cost=28.91..28.92 rows=1 width=524) (never executed)

  • Sort Key: dp_6.woid
54. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.04..28.90 rows=1 width=524) (never executed)

  • Join Filter: ((r_9.partid)::text = (r_10.code)::text)
55. 0.000 0.000 ↓ 0.0 0

Function Scan on dblink r_10 (cost=0.00..15.00 rows=1 width=516) (never executed)

  • Filter: (((partgroup)::text = ANY ('{TIRE,TIRE1}'::text[])) AND ((largepartgroup)::text = 'HGP'::text))
56. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=0.04..13.84 rows=5 width=1,040) (never executed)

  • Hash Cond: ((r_9.woid)::text = (dp_6.woid)::text)
57. 0.000 0.000 ↓ 0.0 0

Function Scan on dblink r_9 (cost=0.00..10.00 rows=1,000 width=1,040) (never executed)

58. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.02..0.02 rows=1 width=516) (never executed)

59. 0.000 0.000 ↓ 0.0 0

CTE Scan on datapool_domain dp_6 (cost=0.00..0.02 rows=1 width=516) (never executed)

60.          

CTE partbusi

61. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=28.91..28.93 rows=1 width=524) (never executed)

  • Group Key: dp_7.woid
62. 0.000 0.000 ↓ 0.0 0

Sort (cost=28.91..28.92 rows=1 width=524) (never executed)

  • Sort Key: dp_7.woid
63. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.04..28.90 rows=1 width=524) (never executed)

  • Join Filter: ((r_11.partid)::text = (r_12.code)::text)
64. 0.000 0.000 ↓ 0.0 0

Function Scan on dblink r_12 (cost=0.00..15.00 rows=1 width=516) (never executed)

  • Filter: (((partgroup)::text = ANY ('{SPLUG,SPLUR}'::text[])) AND ((largepartgroup)::text = 'HGP'::text))
65. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=0.04..13.84 rows=5 width=1,040) (never executed)

  • Hash Cond: ((r_11.woid)::text = (dp_7.woid)::text)
66. 0.000 0.000 ↓ 0.0 0

Function Scan on dblink r_11 (cost=0.00..10.00 rows=1,000 width=1,040) (never executed)

67. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.02..0.02 rows=1 width=516) (never executed)

68. 0.000 0.000 ↓ 0.0 0

CTE Scan on datapool_domain dp_7 (cost=0.00..0.02 rows=1 width=516) (never executed)

69.          

CTE partaki

70. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=28.91..28.93 rows=1 width=524) (never executed)

  • Group Key: dp_8.woid
71. 0.000 0.000 ↓ 0.0 0

Sort (cost=28.91..28.92 rows=1 width=524) (never executed)

  • Sort Key: dp_8.woid
72. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.04..28.90 rows=1 width=524) (never executed)

  • Join Filter: ((r_13.partid)::text = (r_14.code)::text)
73. 0.000 0.000 ↓ 0.0 0

Function Scan on dblink r_14 (cost=0.00..15.00 rows=1 width=516) (never executed)

  • Filter: (((largepartgroup)::text = 'HGP'::text) AND ((partgroup)::text = 'BATT'::text))
74. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=0.04..13.84 rows=5 width=1,040) (never executed)

  • Hash Cond: ((r_13.woid)::text = (dp_8.woid)::text)
75. 0.000 0.000 ↓ 0.0 0

Function Scan on dblink r_13 (cost=0.00..10.00 rows=1,000 width=1,040) (never executed)

76. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.02..0.02 rows=1 width=516) (never executed)

77. 0.000 0.000 ↓ 0.0 0

CTE Scan on datapool_domain dp_8 (cost=0.00..0.02 rows=1 width=516) (never executed)

78.          

CTE partrem

79. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=28.91..28.93 rows=1 width=524) (never executed)

  • Group Key: dp_9.woid
80. 0.000 0.000 ↓ 0.0 0

Sort (cost=28.91..28.92 rows=1 width=524) (never executed)

  • Sort Key: dp_9.woid
81. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.04..28.90 rows=1 width=524) (never executed)

  • Join Filter: ((r_15.partid)::text = (r_16.code)::text)
82. 0.000 0.000 ↓ 0.0 0

Function Scan on dblink r_16 (cost=0.00..15.00 rows=1 width=516) (never executed)

  • Filter: (((largepartgroup)::text = 'HGP'::text) AND ((partgroup)::text = 'BRAKE'::text))
83. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=0.04..13.84 rows=5 width=1,040) (never executed)

  • Hash Cond: ((r_15.woid)::text = (dp_9.woid)::text)
84. 0.000 0.000 ↓ 0.0 0

Function Scan on dblink r_15 (cost=0.00..10.00 rows=1,000 width=1,040) (never executed)

85. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.02..0.02 rows=1 width=516) (never executed)

86. 0.000 0.000 ↓ 0.0 0

CTE Scan on datapool_domain dp_9 (cost=0.00..0.02 rows=1 width=516) (never executed)

87.          

CTE partcvt

88. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=28.91..28.93 rows=1 width=524) (never executed)

  • Group Key: dp_10.woid
89. 0.000 0.000 ↓ 0.0 0

Sort (cost=28.91..28.92 rows=1 width=524) (never executed)

  • Sort Key: dp_10.woid
90. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.04..28.90 rows=1 width=524) (never executed)

  • Join Filter: ((r_17.partid)::text = (r_18.code)::text)
91. 0.000 0.000 ↓ 0.0 0

Function Scan on dblink r_18 (cost=0.00..15.00 rows=1 width=516) (never executed)

  • Filter: (((largepartgroup)::text = 'HGP'::text) AND ((partgroup)::text = 'BLDRV'::text))
92. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=0.04..13.84 rows=5 width=1,040) (never executed)

  • Hash Cond: ((r_17.woid)::text = (dp_10.woid)::text)
93. 0.000 0.000 ↓ 0.0 0

Function Scan on dblink r_17 (cost=0.00..10.00 rows=1,000 width=1,040) (never executed)

94. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.02..0.02 rows=1 width=516) (never executed)

95. 0.000 0.000 ↓ 0.0 0

CTE Scan on datapool_domain dp_10 (cost=0.00..0.02 rows=1 width=516) (never executed)

96.          

CTE partother

97. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=46.77..46.78 rows=1 width=524) (never executed)

  • Group Key: dp_11.woid
98. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=13.90..46.65 rows=25 width=524) (never executed)

  • Hash Cond: ((r_20.code)::text = (r_19.partid)::text)
99. 0.000 0.000 ↓ 0.0 0

Function Scan on dblink r_20 (cost=0.00..28.75 rows=999 width=516) (never executed)

  • Filter: ((largepartgroup IS NULL) OR ((largepartgroup)::text <> ALL ('{HGP,OLI}'::text[])) OR ((partgroup)::text <> ALL ('{BRAKE,BATT,SPLUG,SPLUR,ACB,ACG,GMO,OIL,FLUID,TIRE,TIRE1,BLDRV,A}'::text[])))
100. 0.000 0.000 ↓ 0.0 0

Hash (cost=13.84..13.84 rows=5 width=1,040) (never executed)

101. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=0.04..13.84 rows=5 width=1,040) (never executed)

  • Hash Cond: ((r_19.woid)::text = (dp_11.woid)::text)
102. 0.000 0.000 ↓ 0.0 0

Function Scan on dblink r_19 (cost=0.00..10.00 rows=1,000 width=1,040) (never executed)

103. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.02..0.02 rows=1 width=516) (never executed)

104. 0.000 0.000 ↓ 0.0 0

CTE Scan on datapool_domain dp_11 (cost=0.00..0.02 rows=1 width=516) (never executed)

105.          

CTE cash

106. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=12.59..12.62 rows=1 width=524) (never executed)

  • Group Key: dp_12.woid
107. 0.000 0.000 ↓ 0.0 0

Sort (cost=12.59..12.60 rows=1 width=532) (never executed)

  • Sort Key: dp_12.woid
108. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..12.58 rows=1 width=532) (never executed)

  • Join Filter: ((dp_12.woid)::text = (r_21.woid)::text)
109. 0.000 0.000 ↓ 0.0 0

CTE Scan on datapool_domain dp_12 (cost=0.00..0.02 rows=1 width=532) (never executed)

110. 0.000 0.000 ↓ 0.0 0

Function Scan on dblink r_21 (cost=0.00..12.50 rows=5 width=516) (never executed)

  • Filter: ((paymentmethod)::text = 'CASH'::text)
111.          

CTE transfer

112. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=12.59..12.62 rows=1 width=524) (never executed)

  • Group Key: dp_13.woid
113. 0.000 0.000 ↓ 0.0 0

Sort (cost=12.59..12.60 rows=1 width=532) (never executed)

  • Sort Key: dp_13.woid
114. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..12.58 rows=1 width=532) (never executed)

  • Join Filter: ((dp_13.woid)::text = (r_22.woid)::text)
115. 0.000 0.000 ↓ 0.0 0

CTE Scan on datapool_domain dp_13 (cost=0.00..0.02 rows=1 width=532) (never executed)

116. 0.000 0.000 ↓ 0.0 0

Function Scan on dblink r_22 (cost=0.00..12.50 rows=5 width=516) (never executed)

  • Filter: ((paymentmethod)::text = 'TRANSFER'::text)
117.          

CTE debit

118. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=12.59..12.62 rows=1 width=524) (never executed)

  • Group Key: dp_14.woid
119. 0.000 0.000 ↓ 0.0 0

Sort (cost=12.59..12.60 rows=1 width=532) (never executed)

  • Sort Key: dp_14.woid
120. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..12.58 rows=1 width=532) (never executed)

  • Join Filter: ((dp_14.woid)::text = (r_23.woid)::text)
121. 0.000 0.000 ↓ 0.0 0

CTE Scan on datapool_domain dp_14 (cost=0.00..0.02 rows=1 width=532) (never executed)

122. 0.000 0.000 ↓ 0.0 0

Function Scan on dblink r_23 (cost=0.00..12.50 rows=5 width=516) (never executed)

  • Filter: ((paymentmethod)::text = 'DEBIT'::text)
123.          

CTE cc

124. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=12.59..12.62 rows=1 width=524) (never executed)

  • Group Key: dp_15.woid
125. 0.000 0.000 ↓ 0.0 0

Sort (cost=12.59..12.60 rows=1 width=532) (never executed)

  • Sort Key: dp_15.woid
126. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..12.58 rows=1 width=532) (never executed)

  • Join Filter: ((dp_15.woid)::text = (r_24.woid)::text)
127. 0.000 0.000 ↓ 0.0 0

CTE Scan on datapool_domain dp_15 (cost=0.00..0.02 rows=1 width=532) (never executed)

128. 0.000 0.000 ↓ 0.0 0

Function Scan on dblink r_24 (cost=0.00..12.50 rows=5 width=516) (never executed)

  • Filter: ((paymentmethod)::text = 'CREDIT_CARD'::text)
129.          

CTE onlinepayment

130. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=17.72..17.74 rows=1 width=524) (never executed)

  • Group Key: dp_16.woid
131. 0.000 0.000 ↓ 0.0 0

Sort (cost=17.72..17.73 rows=1 width=532) (never executed)

  • Sort Key: dp_16.woid
132. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..17.71 rows=1 width=532) (never executed)

  • Join Filter: ((dp_16.woid)::text = (r_25.woid)::text)
133. 0.000 0.000 ↓ 0.0 0

CTE Scan on datapool_domain dp_16 (cost=0.00..0.02 rows=1 width=532) (never executed)

134. 0.000 0.000 ↓ 0.0 0

Function Scan on dblink r_25 (cost=0.00..17.50 rows=15 width=516) (never executed)

  • Filter: (((paymentmethod)::text = 'OVO'::text) OR ((paymentmethod)::text = 'GOPAY'::text) OR ((paymentmethod)::text = 'E_MONEY'::text))
135. 0.003 26.762 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.00..0.55 rows=1 width=12,051) (actual time=26.761..26.762 rows=0 loops=1)

  • Join Filter: ((c2part.idwo)::text = (dp.woid)::text)
136. 0.002 26.759 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.00..0.52 rows=1 width=2,702) (actual time=26.758..26.759 rows=0 loops=1)

  • Join Filter: ((c2jasa.idwo)::text = (dp.woid)::text)
137. 0.002 26.757 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.00..0.49 rows=1 width=2,693) (actual time=26.756..26.757 rows=0 loops=1)

  • Join Filter: ((kpb.idwo)::text = (dp.woid)::text)
138. 0.003 26.755 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.00..0.45 rows=1 width=2,684) (actual time=26.754..26.755 rows=0 loops=1)

  • Join Filter: ((onlinepayment.idwo)::text = (dp.woid)::text)
139. 0.002 26.752 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.00..0.42 rows=1 width=2,676) (actual time=26.751..26.752 rows=0 loops=1)

  • Join Filter: ((cc.idwo)::text = (dp.woid)::text)
140. 0.002 26.750 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.00..0.39 rows=1 width=2,668) (actual time=26.749..26.750 rows=0 loops=1)

  • Join Filter: ((debit.idwo)::text = (dp.woid)::text)
141. 0.002 26.748 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.00..0.36 rows=1 width=2,660) (actual time=26.747..26.748 rows=0 loops=1)

  • Join Filter: ((transfer.idwo)::text = (dp.woid)::text)
142. 0.002 26.746 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.00..0.32 rows=1 width=2,652) (actual time=26.745..26.746 rows=0 loops=1)

  • Join Filter: ((cash.idwo)::text = (dp.woid)::text)
143. 0.003 26.744 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.00..0.29 rows=1 width=2,644) (actual time=26.743..26.744 rows=0 loops=1)

  • Join Filter: ((partother.idwo)::text = (dp.woid)::text)
144. 0.002 26.741 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.00..0.26 rows=1 width=2,636) (actual time=26.741..26.741 rows=0 loops=1)

  • Join Filter: ((partrem.idwo)::text = (dp.woid)::text)
145. 0.002 26.739 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.00..0.23 rows=1 width=2,628) (actual time=26.739..26.739 rows=0 loops=1)

  • Join Filter: ((partcvt.idwo)::text = (dp.woid)::text)
146. 0.002 26.737 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.00..0.19 rows=1 width=2,620) (actual time=26.736..26.737 rows=0 loops=1)

  • Join Filter: ((partaki.idwo)::text = (dp.woid)::text)
147. 0.002 26.735 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.00..0.16 rows=1 width=2,612) (actual time=26.734..26.735 rows=0 loops=1)

  • Join Filter: ((partbusi.idwo)::text = (dp.woid)::text)
148. 0.002 26.733 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.00..0.13 rows=1 width=2,604) (actual time=26.732..26.733 rows=0 loops=1)

  • Join Filter: ((partban.idwo)::text = (dp.woid)::text)
149. 0.003 26.731 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.00..0.10 rows=1 width=2,596) (actual time=26.730..26.731 rows=0 loops=1)

  • Join Filter: ((partoli.idwo)::text = (dp.woid)::text)
150. 0.002 26.728 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.00..0.06 rows=1 width=2,588) (actual time=26.728..26.728 rows=0 loops=1)

  • Join Filter: ((jasa.idwo)::text = (dp.woid)::text)
151. 26.726 26.726 ↓ 0.0 0 1

CTE Scan on datapool_domain dp (cost=0.00..0.03 rows=1 width=2,580) (actual time=26.725..26.726 rows=0 loops=1)

  • Filter: (((ahassid)::text = '00999'::text) AND (to_char((paymentdate)::timestamp with time zone, 'dd/MM/yyyy'::text) = '01/01/2020'::text))
152. 0.000 0.000 ↓ 0.0 0

CTE Scan on jasa (cost=0.00..0.02 rows=1 width=524) (never executed)

153. 0.000 0.000 ↓ 0.0 0

CTE Scan on partoli (cost=0.00..0.02 rows=1 width=524) (never executed)

154. 0.000 0.000 ↓ 0.0 0

CTE Scan on partban (cost=0.00..0.02 rows=1 width=524) (never executed)

155. 0.000 0.000 ↓ 0.0 0

CTE Scan on partbusi (cost=0.00..0.02 rows=1 width=524) (never executed)

156. 0.000 0.000 ↓ 0.0 0

CTE Scan on partaki (cost=0.00..0.02 rows=1 width=524) (never executed)

157. 0.000 0.000 ↓ 0.0 0

CTE Scan on partcvt (cost=0.00..0.02 rows=1 width=524) (never executed)

158. 0.000 0.000 ↓ 0.0 0

CTE Scan on partrem (cost=0.00..0.02 rows=1 width=524) (never executed)

159. 0.000 0.000 ↓ 0.0 0

CTE Scan on partother (cost=0.00..0.02 rows=1 width=524) (never executed)

160. 0.000 0.000 ↓ 0.0 0

CTE Scan on cash (cost=0.00..0.02 rows=1 width=524) (never executed)

161. 0.000 0.000 ↓ 0.0 0

CTE Scan on transfer (cost=0.00..0.02 rows=1 width=524) (never executed)

162. 0.000 0.000 ↓ 0.0 0

CTE Scan on debit (cost=0.00..0.02 rows=1 width=524) (never executed)

163. 0.000 0.000 ↓ 0.0 0

CTE Scan on cc (cost=0.00..0.02 rows=1 width=524) (never executed)

164. 0.000 0.000 ↓ 0.0 0

CTE Scan on onlinepayment (cost=0.00..0.02 rows=1 width=524) (never executed)

165. 0.000 0.000 ↓ 0.0 0

CTE Scan on kpb (cost=0.00..0.02 rows=1 width=525) (never executed)

166. 0.000 0.000 ↓ 0.0 0

CTE Scan on c2jasa (cost=0.00..0.02 rows=1 width=525) (never executed)

167. 0.000 0.000 ↓ 0.0 0

CTE Scan on c2part (cost=0.00..0.02 rows=1 width=525) (never executed)

Planning time : 9.560 ms
Execution time : 40.729 ms