explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Fq8X : v_surat

Settings
# exclusive inclusive rows x rows loops node
1. 7.041 26.499 ↓ 1.0 274 1

Hash Join (cost=4,059.86..6,901.55 rows=268 width=6,855) (actual time=14.436..26.499 rows=274 loops=1)

  • Buffers: shared hit=3,202
2. 0.200 19.453 ↓ 1.0 274 1

Hash Join (cost=4,021.29..4,814.45 rows=268 width=6,853) (actual time=14.35..19.453 rows=274 loops=1)

  • Buffers: shared hit=3,201
3. 0.171 19.248 ↓ 1.0 274 1

Hash Join (cost=4,020.02..4,812.05 rows=268 width=6,851) (actual time=14.343..19.248 rows=274 loops=1)

  • Buffers: shared hit=3,200
4. 0.186 19.075 ↓ 1.0 274 1

Hash Join (cost=3,981.44..4,769.79 rows=268 width=6,849) (actual time=14.338..19.075 rows=274 loops=1)

  • Buffers: shared hit=3,199
5. 0.199 18.884 ↓ 1.0 274 1

Hash Join (cost=3,980.2..4,767.43 rows=268 width=6,847) (actual time=14.331..18.884 rows=274 loops=1)

  • Buffers: shared hit=3,198
6. 0.194 18.665 ↓ 1.0 274 1

Hash Join (cost=3,977.71..4,763.28 rows=268 width=6,839) (actual time=14.307..18.665 rows=274 loops=1)

  • Buffers: shared hit=3,197
7. 0.158 18.464 ↓ 1.0 274 1

Hash Join (cost=3,975.17..4,759.47 rows=268 width=6,835) (actual time=14.297..18.464 rows=274 loops=1)

  • Buffers: shared hit=3,195
8. 0.187 18.269 ↓ 1.0 274 1

Hash Join (cost=3,967.71..4,748.33 rows=268 width=6,802) (actual time=14.258..18.269 rows=274 loops=1)

  • Buffers: shared hit=3,191
9. 0.163 17.970 ↓ 1.0 274 1

Hash Join (cost=3,936.68..4,715.82 rows=268 width=6,709) (actual time=14.144..17.97 rows=274 loops=1)

  • Buffers: shared hit=3,166
10. 0.208 17.766 ↓ 1.0 274 1

Hash Join (cost=3,929.21..4,707.01 rows=268 width=6,635) (actual time=14.1..17.766 rows=274 loops=1)

  • Buffers: shared hit=3,162
11. 0.163 17.507 ↓ 1.0 274 1

Hash Join (cost=3,921.75..4,695.87 rows=268 width=6,528) (actual time=14.046..17.507 rows=274 loops=1)

  • Buffers: shared hit=3,158
12. 0.240 16.397 ↓ 1.0 274 1

Nested Loop (cost=3,674.19..4,447.2 rows=268 width=6,385) (actual time=13.094..16.397 rows=274 loops=1)

  • Buffers: shared hit=2,975
13. 0.176 16.157 ↓ 1.0 274 1

Hash Join (cost=3,673.91..4,188.79 rows=268 width=6,352) (actual time=13.093..16.157 rows=274 loops=1)

  • Buffers: shared hit=2,946
14. 0.285 14.984 ↓ 1.0 274 1

Nested Loop (cost=3,426.36..3,940.03 rows=268 width=6,209) (actual time=12.092..14.984 rows=274 loops=1)

  • Buffers: shared hit=2,763
15. 0.194 14.699 ↓ 1.0 274 1

Hash Join (cost=3,426.08..3,681.62 rows=268 width=6,176) (actual time=12.089..14.699 rows=274 loops=1)

  • Buffers: shared hit=2,713
16. 0.174 13.553 ↓ 1.0 274 1

Hash Join (cost=3,178.53..3,430.38 rows=268 width=6,033) (actual time=11.134..13.553 rows=274 loops=1)

  • Buffers: shared hit=2,530
17. 0.182 12.629 ↓ 1.0 274 1

Hash Join (cost=2,817.76..3,065.93 rows=268 width=5,991) (actual time=10.38..12.629 rows=274 loops=1)

  • Buffers: shared hit=2,233
18. 0.170 11.485 ↓ 1.0 274 1

Hash Join (cost=2,570.21..2,816.77 rows=268 width=5,848) (actual time=9.413..11.485 rows=274 loops=1)

  • Buffers: shared hit=2,050
19. 0.137 10.569 ↓ 1.0 274 1

Hash Join (cost=2,209.45..2,454.4 rows=268 width=5,806) (actual time=8.664..10.569 rows=274 loops=1)

  • Buffers: shared hit=1,753
20. 0.153 9.441 ↓ 1.0 274 1

Hash Join (cost=1,961.89..2,205.75 rows=268 width=5,663) (actual time=7.67..9.441 rows=274 loops=1)

  • Buffers: shared hit=1,570
21. 0.171 8.537 ↓ 1.0 274 1

Hash Join (cost=1,601.13..1,843.89 rows=268 width=5,621) (actual time=6.916..8.537 rows=274 loops=1)

  • Buffers: shared hit=1,273
22. 0.160 8.185 ↓ 1.0 274 1

Hash Join (cost=1,551.51..1,790.62 rows=268 width=5,619) (actual time=6.733..8.185 rows=274 loops=1)

  • Buffers: shared hit=1,239
23. 0.186 7.078 ↓ 1.0 274 1

Hash Join (cost=1,303.96..1,541 rows=268 width=5,476) (actual time=5.782..7.078 rows=274 loops=1)

  • Buffers: shared hit=1,056
24. 0.130 6.027 ↓ 1.0 274 1

Hash Join (cost=943.2..1,178.11 rows=268 width=5,434) (actual time=4.912..6.027 rows=274 loops=1)

  • Buffers: shared hit=759
25. 0.173 4.820 ↓ 1.0 274 1

Hash Join (cost=695.64..929.54 rows=268 width=5,291) (actual time=3.832..4.82 rows=274 loops=1)

  • Buffers: shared hit=576
26. 0.140 3.579 ↓ 1.0 274 1

Hash Join (cost=448.09..680.26 rows=268 width=5,148) (actual time=2.76..3.579 rows=274 loops=1)

  • Buffers: shared hit=393
27. 0.134 2.563 ↓ 1.0 274 1

Hash Join (cost=87.33..317.77 rows=268 width=5,106) (actual time=1.88..2.563 rows=274 loops=1)

  • Buffers: shared hit=96
28. 0.234 2.426 ↓ 1.0 274 1

Hash Join (cost=86.24..315.66 rows=268 width=4,852) (actual time=1.875..2.426 rows=274 loops=1)

  • Buffers: shared hit=95
29. 0.373 2.127 ↓ 1.0 274 1

Merge Join (cost=80.85..307.8 rows=268 width=4,647) (actual time=1.794..2.127 rows=274 loops=1)

  • Buffers: shared hit=92
30. 0.364 1.580 ↓ 1.0 274 1

Sort (cost=80.57..81.24 rows=268 width=4,614) (actual time=1.524..1.58 rows=274 loops=1)

  • Sort Key: s.surat_distribusi_cabut_staf
  • Sort Method: quicksort Memory: 343kB
  • Buffers: shared hit=42
31. 0.118 1.216 ↓ 1.0 274 1

Hash Join (cost=29.04..69.76 rows=268 width=4,614) (actual time=0.232..1.216 rows=274 loops=1)

  • Buffers: shared hit=42
32. 0.133 1.096 ↓ 1.0 274 1

Hash Join (cost=27.92..67.37 rows=268 width=4,394) (actual time=0.228..1.096 rows=274 loops=1)

  • Buffers: shared hit=41
33. 0.104 0.959 ↓ 1.0 274 1

Hash Join (cost=26.7..64.61 rows=268 width=4,174) (actual time=0.221..0.959 rows=274 loops=1)

  • Buffers: shared hit=40
34. 0.122 0.852 ↓ 1.0 274 1

Hash Join (cost=25.54..61.71 rows=268 width=3,950) (actual time=0.216..0.852 rows=274 loops=1)

  • Buffers: shared hit=39
35. 0.117 0.728 ↓ 1.0 274 1

Hash Join (cost=24.5..58.84 rows=268 width=3,717) (actual time=0.211..0.728 rows=274 loops=1)

  • Buffers: shared hit=38
36. 0.113 0.607 ↓ 1.0 274 1

Hash Join (cost=23.34..55.51 rows=268 width=3,450) (actual time=0.205..0.607 rows=274 loops=1)

  • Buffers: shared hit=37
37. 0.263 0.411 ↓ 1.0 274 1

Hash Join (cost=11.67..41.5 rows=268 width=3,379) (actual time=0.12..0.411 rows=274 loops=1)

  • Buffers: shared hit=31
38. 0.036 0.036 ↓ 1.0 274 1

Seq Scan on surat s (cost=0..27.68 rows=268 width=3,274) (actual time=0.003..0.036 rows=274 loops=1)

  • Buffers: shared hit=25
39. 0.055 0.112 ↑ 1.0 252 1

Hash (cost=8.52..8.52 rows=252 width=105) (actual time=0.112..0.112 rows=252 loops=1)

  • Buffers: shared hit=6
40. 0.057 0.057 ↑ 1.0 252 1

Seq Scan on jenis j (cost=0..8.52 rows=252 width=105) (actual time=0.003..0.057 rows=252 loops=1)

  • Buffers: shared hit=6
41. 0.050 0.083 ↑ 1.0 252 1

Hash (cost=8.52..8.52 rows=252 width=71) (actual time=0.083..0.083 rows=252 loops=1)

  • Buffers: shared hit=6
42. 0.033 0.033 ↑ 1.0 252 1

Seq Scan on jenis t (cost=0..8.52 rows=252 width=71) (actual time=0.001..0.033 rows=252 loops=1)

  • Buffers: shared hit=6
43. 0.003 0.004 ↑ 1.0 7 1

Hash (cost=1.07..1.07 rows=7 width=267) (actual time=0.004..0.004 rows=7 loops=1)

  • Buffers: shared hit=1
44. 0.001 0.001 ↑ 1.0 7 1

Seq Scan on kelas k (cost=0..1.07 rows=7 width=267) (actual time=0.001..0.001 rows=7 loops=1)

  • Buffers: shared hit=1
45. 0.001 0.002 ↑ 1.0 2 1

Hash (cost=1.02..1.02 rows=2 width=233) (actual time=0.002..0.002 rows=2 loops=1)

  • Buffers: shared hit=1
46. 0.001 0.001 ↑ 1.0 2 1

Seq Scan on sifat sifat (cost=0..1.02 rows=2 width=233) (actual time=0.001..0.001 rows=2 loops=1)

  • Buffers: shared hit=1
47. 0.001 0.003 ↑ 1.0 7 1

Hash (cost=1.07..1.07 rows=7 width=224) (actual time=0.003..0.003 rows=7 loops=1)

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

Seq Scan on prioritas p (cost=0..1.07 rows=7 width=224) (actual time=0.001..0.002 rows=7 loops=1)

  • Buffers: shared hit=1
49. 0.002 0.004 ↑ 1.0 10 1

Hash (cost=1.1..1.1 rows=10 width=220) (actual time=0.004..0.004 rows=10 loops=1)

  • Buffers: shared hit=1
50. 0.002 0.002 ↑ 1.0 10 1

Seq Scan on media m (cost=0..1.1 rows=10 width=220) (actual time=0.001..0.002 rows=10 loops=1)

  • Buffers: shared hit=1
51. 0.001 0.002 ↑ 1.0 5 1

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

  • Buffers: shared hit=1
52. 0.001 0.001 ↑ 1.0 5 1

Seq Scan on lokasi l (cost=0..1.05 rows=5 width=220) (actual time=0..0.001 rows=5 loops=1)

  • Buffers: shared hit=1
53. 0.174 0.174 ↑ 1.7 1,681 1

Index Only Scan using staf_pkey on staf surat_distribusi_cabut_staf (cost=0.28..218.79 rows=2,834 width=33) (actual time=0.006..0.174 rows=1,681 loops=1)

  • Heap Fetches: 36
  • Buffers: shared hit=50
54. 0.032 0.065 ↓ 1.2 123 1

Hash (cost=4.06..4.06 rows=106 width=205) (actual time=0.065..0.065 rows=123 loops=1)

  • Buffers: shared hit=3
55. 0.033 0.033 ↓ 1.2 123 1

Seq Scan on korespondensi ks (cost=0..4.06 rows=106 width=205) (actual time=0.002..0.033 rows=123 loops=1)

  • Buffers: shared hit=3
56. 0.002 0.003 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=254) (actual time=0.003..0.003 rows=4 loops=1)

  • Buffers: shared hit=1
57. 0.001 0.001 ↑ 1.0 4 1

Seq Scan on ekspedisi eks (cost=0..1.04 rows=4 width=254) (actual time=0.001..0.001 rows=4 loops=1)

  • Buffers: shared hit=1
58. 0.434 0.876 ↓ 1.0 2,836 1

Hash (cost=325.34..325.34 rows=2,834 width=42) (actual time=0.876..0.876 rows=2,836 loops=1)

  • Buffers: shared hit=297
59. 0.442 0.442 ↓ 1.0 2,836 1

Seq Scan on staf surat_distribusi_staf (cost=0..325.34 rows=2,834 width=42) (actual time=0.002..0.442 rows=2,836 loops=1)

  • Buffers: shared hit=297
60. 0.610 1.068 ↓ 1.0 2,877 1

Hash (cost=211.69..211.69 rows=2,869 width=176) (actual time=1.068..1.068 rows=2,877 loops=1)

  • Buffers: shared hit=183
61. 0.458 0.458 ↓ 1.0 2,877 1

Seq Scan on staf_profil surat_distribusi_profil (cost=0..211.69 rows=2,869 width=176) (actual time=0.001..0.458 rows=2,877 loops=1)

  • Buffers: shared hit=183
62. 0.647 1.077 ↓ 1.0 2,877 1

Hash (cost=211.69..211.69 rows=2,869 width=176) (actual time=1.077..1.077 rows=2,877 loops=1)

  • Buffers: shared hit=183
63. 0.430 0.430 ↓ 1.0 2,877 1

Seq Scan on staf_profil surat_distribusi_cabut_profil (cost=0..211.69 rows=2,869 width=176) (actual time=0.001..0.43 rows=2,877 loops=1)

  • Buffers: shared hit=183
64. 0.418 0.865 ↓ 1.0 2,836 1

Hash (cost=325.34..325.34 rows=2,834 width=42) (actual time=0.865..0.865 rows=2,836 loops=1)

  • Buffers: shared hit=297
65. 0.447 0.447 ↓ 1.0 2,836 1

Seq Scan on staf surat_setuju_staf (cost=0..325.34 rows=2,834 width=42) (actual time=0.001..0.447 rows=2,836 loops=1)

  • Buffers: shared hit=297
66. 0.589 0.947 ↓ 1.0 2,877 1

Hash (cost=211.69..211.69 rows=2,869 width=176) (actual time=0.947..0.947 rows=2,877 loops=1)

  • Buffers: shared hit=183
67. 0.358 0.358 ↓ 1.0 2,877 1

Seq Scan on staf_profil surat_setuju_profil (cost=0..211.69 rows=2,869 width=176) (actual time=0.001..0.358 rows=2,877 loops=1)

  • Buffers: shared hit=183
68. 0.092 0.181 ↑ 1.0 694 1

Hash (cost=40.94..40.94 rows=694 width=35) (actual time=0.181..0.181 rows=694 loops=1)

  • Buffers: shared hit=34
69. 0.089 0.089 ↑ 1.0 694 1

Seq Scan on jabatan surat_setuju_jabatan (cost=0..40.94 rows=694 width=35) (actual time=0.003..0.089 rows=694 loops=1)

  • Buffers: shared hit=34
70. 0.412 0.751 ↓ 1.0 2,836 1

Hash (cost=325.34..325.34 rows=2,834 width=42) (actual time=0.751..0.751 rows=2,836 loops=1)

  • Buffers: shared hit=297
71. 0.339 0.339 ↓ 1.0 2,836 1

Seq Scan on staf surat_melalui_status_staf (cost=0..325.34 rows=2,834 width=42) (actual time=0.002..0.339 rows=2,836 loops=1)

  • Buffers: shared hit=297
72. 0.590 0.991 ↓ 1.0 2,877 1

Hash (cost=211.69..211.69 rows=2,869 width=176) (actual time=0.991..0.991 rows=2,877 loops=1)

  • Buffers: shared hit=183
73. 0.401 0.401 ↓ 1.0 2,877 1

Seq Scan on staf_profil surat_melalui_status_profil (cost=0..211.69 rows=2,869 width=176) (actual time=0.001..0.401 rows=2,877 loops=1)

  • Buffers: shared hit=183
74. 0.420 0.746 ↓ 1.0 2,836 1

Hash (cost=325.34..325.34 rows=2,834 width=42) (actual time=0.746..0.746 rows=2,836 loops=1)

  • Buffers: shared hit=297
75. 0.326 0.326 ↓ 1.0 2,836 1

Seq Scan on staf surat_selesai_staf (cost=0..325.34 rows=2,834 width=42) (actual time=0.002..0.326 rows=2,836 loops=1)

  • Buffers: shared hit=297
76. 0.617 0.962 ↓ 1.0 2,877 1

Hash (cost=211.69..211.69 rows=2,869 width=176) (actual time=0.962..0.962 rows=2,877 loops=1)

  • Buffers: shared hit=183
77. 0.345 0.345 ↓ 1.0 2,877 1

Seq Scan on staf_profil surat_selesai_profil (cost=0..211.69 rows=2,869 width=176) (actual time=0..0.345 rows=2,877 loops=1)

  • Buffers: shared hit=183
78. 0.444 0.750 ↓ 1.0 2,836 1

Hash (cost=325.34..325.34 rows=2,834 width=42) (actual time=0.75..0.75 rows=2,836 loops=1)

  • Buffers: shared hit=297
79. 0.306 0.306 ↓ 1.0 2,836 1

Seq Scan on staf surat_buat_staf (cost=0..325.34 rows=2,834 width=42) (actual time=0.001..0.306 rows=2,836 loops=1)

  • Buffers: shared hit=297
80. 0.605 0.952 ↓ 1.0 2,877 1

Hash (cost=211.69..211.69 rows=2,869 width=176) (actual time=0.952..0.952 rows=2,877 loops=1)

  • Buffers: shared hit=183
81. 0.347 0.347 ↓ 1.0 2,877 1

Seq Scan on staf_profil surat_buat_profil (cost=0..211.69 rows=2,869 width=176) (actual time=0.001..0.347 rows=2,877 loops=1)

  • Buffers: shared hit=183
82. 0.000 0.000 ↓ 0.0 0 274

Index Only Scan using staf_pkey on staf surat_cabut_staf (cost=0.28..0.95 rows=1 width=33) (actual time=0..0 rows=0 loops=274)

  • Index Cond: (surat_cabut_staf.staf_id = (s.surat_cabut_staf)::text)
  • Heap Fetches: 7
  • Buffers: shared hit=50
83. 0.645 0.997 ↓ 1.0 2,877 1

Hash (cost=211.69..211.69 rows=2,869 width=176) (actual time=0.997..0.997 rows=2,877 loops=1)

  • Buffers: shared hit=183
84. 0.352 0.352 ↓ 1.0 2,877 1

Seq Scan on staf_profil surat_cabut_profil (cost=0..211.69 rows=2,869 width=176) (actual time=0.001..0.352 rows=2,877 loops=1)

  • Buffers: shared hit=183
85. 0.000 0.000 ↓ 0.0 0 274

Index Only Scan using staf_pkey on staf surat_cabut_pelaku (cost=0.28..0.95 rows=1 width=33) (actual time=0..0 rows=0 loops=274)

  • Index Cond: (surat_cabut_pelaku.staf_id = (s.surat_cabut_pelaku)::text)
  • Heap Fetches: 6
  • Buffers: shared hit=29
86. 0.605 0.947 ↓ 1.0 2,877 1

Hash (cost=211.69..211.69 rows=2,869 width=176) (actual time=0.947..0.947 rows=2,877 loops=1)

  • Buffers: shared hit=183
87. 0.342 0.342 ↓ 1.0 2,877 1

Seq Scan on staf_profil surat_cabut_pelaku_profil (cost=0..211.69 rows=2,869 width=176) (actual time=0.001..0.342 rows=2,877 loops=1)

  • Buffers: shared hit=183
88. 0.030 0.051 ↑ 1.0 154 1

Hash (cost=5.54..5.54 rows=154 width=107) (actual time=0.051..0.051 rows=154 loops=1)

  • Buffers: shared hit=4
89. 0.021 0.021 ↑ 1.0 154 1

Seq Scan on unit surat_unit (cost=0..5.54 rows=154 width=107) (actual time=0.002..0.021 rows=154 loops=1)

  • Buffers: shared hit=4
90. 0.024 0.041 ↑ 1.0 154 1

Hash (cost=5.54..5.54 rows=154 width=74) (actual time=0.041..0.041 rows=154 loops=1)

  • Buffers: shared hit=4
91. 0.017 0.017 ↑ 1.0 154 1

Seq Scan on unit surat_unit_source (cost=0..5.54 rows=154 width=74) (actual time=0.001..0.017 rows=154 loops=1)

  • Buffers: shared hit=4
92. 0.038 0.112 ↓ 1.0 274 1

Hash (cost=27.68..27.68 rows=268 width=93) (actual time=0.112..0.112 rows=274 loops=1)

  • Buffers: shared hit=25
93. 0.074 0.074 ↓ 1.0 274 1

Seq Scan on surat induk (cost=0..27.68 rows=268 width=93) (actual time=0.001..0.074 rows=274 loops=1)

  • Buffers: shared hit=25
94. 0.022 0.037 ↑ 1.0 154 1

Hash (cost=5.54..5.54 rows=154 width=66) (actual time=0.037..0.037 rows=154 loops=1)

  • Buffers: shared hit=4
95. 0.015 0.015 ↑ 1.0 154 1

Seq Scan on unit iunit (cost=0..5.54 rows=154 width=66) (actual time=0.001..0.015 rows=154 loops=1)

  • Buffers: shared hit=4
96. 0.003 0.007 ↑ 1.0 24 1

Hash (cost=2.24..2.24 rows=24 width=37) (actual time=0.007..0.007 rows=24 loops=1)

  • Buffers: shared hit=2
97. 0.004 0.004 ↑ 1.0 24 1

Seq Scan on surat_dokumen_jumlah sdj (cost=0..2.24 rows=24 width=37) (actual time=0.001..0.004 rows=24 loops=1)

  • Buffers: shared hit=2
98. 0.011 0.020 ↓ 1.0 67 1

Hash (cost=1.66..1.66 rows=66 width=41) (actual time=0.02..0.02 rows=67 loops=1)

  • Buffers: shared hit=1
99. 0.009 0.009 ↓ 1.0 67 1

Seq Scan on surat_setuju_jumlah ssj (cost=0..1.66 rows=66 width=41) (actual time=0.004..0.009 rows=67 loops=1)

  • Buffers: shared hit=1
100. 0.003 0.005 ↑ 1.0 11 1

Hash (cost=1.11..1.11 rows=11 width=35) (actual time=0.005..0.005 rows=11 loops=1)

  • Buffers: shared hit=1
101. 0.002 0.002 ↑ 1.0 11 1

Seq Scan on surat_imasuk_jumlah_setuju sijs (cost=0..1.11 rows=11 width=35) (actual time=0.002..0.002 rows=11 loops=1)

  • Buffers: shared hit=1
102. 0.001 0.002 ↑ 635.0 2 1

Hash (cost=22.7..22.7 rows=1,270 width=36) (actual time=0.002..0.002 rows=2 loops=1)

  • Buffers: shared hit=1
103. 0.001 0.001 ↑ 635.0 2 1

Seq Scan on surat_imasuk_jumlah_tolak sijt (cost=0..22.7 rows=1,270 width=36) (actual time=0.001..0.001 rows=2 loops=1)

  • Buffers: shared hit=1
104. 0.004 0.005 ↓ 1.1 13 1

Hash (cost=1.12..1.12 rows=12 width=35) (actual time=0.005..0.005 rows=13 loops=1)

  • Buffers: shared hit=1
105. 0.001 0.001 ↓ 1.1 13 1

Seq Scan on surat_imasuk_jumlah_pending sijp (cost=0..1.12 rows=12 width=35) (actual time=0.001..0.001 rows=13 loops=1)

  • Buffers: shared hit=1
106. 0.003 0.005 ↑ 90.7 14 1

Hash (cost=22.7..22.7 rows=1,270 width=36) (actual time=0.005..0.005 rows=14 loops=1)

  • Buffers: shared hit=1
107. 0.002 0.002 ↑ 90.7 14 1

Seq Scan on surat_imasuk_jumlah sij (cost=0..22.7 rows=1,270 width=36) (actual time=0.002..0.002 rows=14 loops=1)

  • Buffers: shared hit=1
108.          

SubPlan (for Hash Join)

109. 0.000 0.000 ↑ 1.0 1 274

Result (cost=0..0.02 rows=1 width=0) (actual time=0..0 rows=1 loops=274)

Planning time : 28.126 ms
Execution time : 27.797 ms